In this release, we have created a new financial report which lists all job related invoices and journals that have occurred over a transactional period at a General Ledger Level. This report is only available as a CSV and is located under Management -> Reports -> Finance -> Transactional Job/GL Code Detailed and Finance -> Reports -> Operational Finance -> Transactional Job/GL Code Detailed.
The report contains the following fields:
- Transaction Date
- this either the invoice date, journal date or date that profit was taken up
- Customer Code and Name
- this is either the bill to party (debtor) or payee (creditor) from the debtor/creditor invoice line.
- please note this will read JP for all journals as these do not have a customer attached to them.
- Business Unit
- this will list the business unit for the customer if applicable
- Job Number
- this is the job that the transaction is on
- Department
- this is the department linked to the transaction
- Forw Code
- this is the forwarders code from the job
- Goods
- this contains a description of goods from the job
- Customer Reference Number
- GL Code
- this is the general ledger code the transaction relates to
- GL Description
- Invoiced
- this is the amount that was billed on the debtor invoice for that GL Code
- Credits
- this is the amount that has been credited back to the debtor for that GL Code
- Cost
- this is the amount that has been paid to the creditor for that GL code
- Journal
- this is the amount that has been journaled to / from the current job
- Profit
- this is the amount that has been taken up as profit for the GL code.
- if an amount was invoiced out against a 4000 series, the amount will show up twice on teh line: once in either the invoiced/cost column and again in the profit column.
This report can be filtered by Debtor/Creditor, GL code or department.