Journal ID

When you create a new journal spreadsheet header, the Journal ID default depends on whether you selected the Use Next Journal ID check box in the Journal Entry Options section of the User Preferences - General Ledger page.

If the Use Next Journal ID is not selected for your user ID, you can change the value by manually entering a journal ID value in the dialog box for a new spreadsheet header.

If the Use Next Journal ID is selected for your user ID, the Journal ID field is always populated with NEXT and the field is unavailable for change or to manually enter of Journal ID in the add mode.

The user ID is not a required field for the spreadsheet journal header, so the check against user preferences for the user ID occurs during load time. The system determines the user ID according to these rules:

  • If a user ID field is populated on the spreadsheet journal header, the system uses that user ID when checking user preferences.

  • If the user ID field is not populated on the spreadsheet journal header, the system uses the user ID of the individual loading the spreadsheet journal when checking user preferences.

You can load a journal using NEXT as the journal ID during online import and batch import.

  • When using Batch Import: If you choose to use NEXT as the journal ID and write the journal data to a file, the text file in XML format has NEXT as the journal ID for each journal header.

  • When using Online Import: If you choose to import the spreadsheet journal online using the Import Now functionality, the NEXT journal ID on the spreadsheet is updated with an actual system generated journal ID number.