Purchases (Accounts Payable Invoices & Credits)

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

(Batch Type = Accounts Payable Invoices or Sub Claim or Accounts Payable Credit) (Job Transaction Table)

DR GL Account

  • If the DR GL Account on the job has an Account Code entered, then the expense is posted to that Account Code. Note that the full code is required i.e. includes the prefix, account number (or suffix). This handles purchases into Stock going to the correct Control Account. It will also handle the situation where users may wish to run a separate WIP account for a particular job or range of jobs.
  • If the DR GL Account on the job is blank, and the DR GL Account of the Activity Code does not commence with the '@'symbol, then the expense is posted to GL Prefix of the Job Profit Centre + DR GL Account of the Activity Code + GL Suffix of Job Profit Centre
  • If the DR GL Account on the job is blank, and the DR GL Account of the Activity Code commences with the '@'symbol (e.g. @WN.01.200) , then the expense is posted to that account e.g. WN.01.200



CR GL Account

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

 

An AP Credit will still have a +'ve value in the Job Transaction Table. The AP Invoices table has a --1 in the Invoice Credit Flag field to distinguish the AP Credit. The Job Transaction value becomes a --'ve when multiplied by this field in the AP Invoices table.

Other Invoice Credit Flag codes are:
-1  AP Credit
1   AP Invoice