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 GL 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.
2means 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.)