System ID

The system ID is a sequential number that is unique to each journal created across all journal sheets within a spreadsheet journal workbook file. System ID starts with a value of 1001 and recycles when it reached 9999.

The purpose of system ID is to avoid confusion when using NEXT as the journal ID where there are multiple journal headers in a journal spreadsheet with each showing the value NEXT. The system generates a separate system ID for each journal header as a visual indicator that makes it possible to identify different journal headers while they are all showing NEXT and after the various journal IDs are generated. The system ID is called a visual indicator because it is not stored in the journal tables but is available to differentiate the journals within the spreadsheet interface and when performing various spreadsheet functions, such as:

• Copy Journal

• Delete Journal

• Change Import Status

• Edit Journal Header

• Select Journal Header

The system ID is also included in error messages in addition to reference, business unit, journal ID, and date to identify problem journals.