Technical Information

GENERAL LEDGER CODE (GL Code)

The GL Code used for a transaction is written to the relevant fields in the Job Transactions table (for Activity Codes) and Job Invoice Lines table (for Sales Codes).

The GL Code is determined when a number of processes are initiated:

• When a Batch List is printed: It determines the GL Code for the selected Batch/es only.
• When the General Ledger Enquiry is run: The initial entry into the program determines the GL Code for all Job Transactions and Job Invoice Lines.
• When the export to the financials is done: It determines or re-determines the GL Code for the selected Batch/es only.

The GL Coded column identifies the updated status of the GL Code.

• 0 means that the GL Code has not been determined. Any of the above 3 processes will determine the GL
  Code and make the GL Coded field -1
• -1 means that the GL Code has been determined but that every time one of the above 3 processes are
  Initiates the GL Code is recalculated.
• 1 means that the transaction has been exported and the GL Code is now fixed.
• 2 means that these transactions have been initialised at set up time. They will never be recalculated.

Note that when you un-export a batch the GL Coded field is put back to -1. (It unlocks it.)