PeopleSoft Journal Workbook: JRNL1_WS

The JRNL1_WS.xlsm workbook is the PeopleSoft Spreadsheet Journal Import user interface. Use it to prepare and enter journals, group and manage journals in journal sheets, and import them into your PeopleSoft database using various pages, dialog boxes, and buttons. PeopleSoft provides a utility to move ChartFields and rearrange columns in your journal workbook. The workbook contains one or more journal sheets, and each journal sheet can contain one or more journals.

When you open the file JRNL1_WS.xlsm, you begin with the Control page. The Control page contains three sets of buttons that enable you to:

• Set workbook defaults, configure ChartFields, and rearrange columns.

• Maintain the journal sheets in the workbook.

• Import the journal sheets from the workbook.

You use the journal sheet page to prepare journals. There are buttons and dialog boxes for you to add, delete, and copy journals. Because you are entering data offline in the spreadsheet, there is no validation of the values that you are entering. Validation of journals takes place when you import the journal and during the Journal Edit process.

However, while there is no data validation, spreadsheet journal import provides offline validation because journal IDs cannot contain an apostrophe, open item key values cannot contain spaces, and the field length must be valid (except for the Amount and Date fields).