Sales (Accounts Receivable Invoices & Credits)

Owned by Former user (Deleted)
Last updated: Apr 02, 2013 by John Cooper (Unlicensed)

(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:

  • -1   AR Credit
  • 1    AR Invoice
  • 2    AR Internal
  • 3    Revenue Journal