Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

(Batch Type = AR Invoice or AR Credit) (Job Invoice Lines Table)
CR GL Account

  • If the CR GL Account on the job has an Account Code entered, then the revenue is posted to that Account Code. Note that the full code is required i.e. includes the prefix, account number (or suffix)
  • If the CR GL Account on the Sales Code on the Job Invoice line commences with the '@' symbol (e.g. @WN.01.200), and the CR GL Account on the job is blank, then CR the account code which follows the @ (e.g. WN.01.200)
  • If the CR GL Account on the Sales Code on the Job Invoice line does not commence with the '@' symbol (e.g. 200), and the CR GL Account on the job is blank, then CR the GL Prefix of the Job Profit Centre + CR GL Account of the Sales Code + GL Suffix of Job Profit Centre


DR GL Account

  • The host financials will determine the Debtors Control Account to which the DR will be posted, so this account code is not part of the export.


An AR Credit will still have a +'ve value in the Job Invoice Lines Table. The Job Invoices table has a -1 in the Invoice Credit Flag field to distinguish the AR Credit. The Job Invoice Lines value becomes a -'ve when multiplied by this field in the Job Invoices table.
Other Invoice Credit Flag codes are:-
-1AR Credit
1AR Invoice
2AR Internal
3Revenue Journal

  • No labels