Initial Setup

There is a script that is run over the database to initialise the General Ledger Codes in the Job Transaction and Job Invoice Lines tables.

You specify a batch date that the General Ledger Codes will populate the transaction fields from. Eg from 1 April 2010.

• General Ledger Codes for transactions prior to this date will remain Null.
• General Ledger Coded field for these transactions will be set at 2 for all transactions prior to this date.
• The General Ledger Coded field will be set to 1 for all transactions after these dates which have been exported.
• The General Ledger Coded field will be set to -1 for all transactions after these dates which have not been exported.