(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