The Cost Centre by Detail Code Transaction List Report provides full transactional information for Actuals, Commitments, Total Spend, Budget and Left to Spend amounts for each Detail Code in a specified Period of a specified Year for a specified Cost Centre.
This Report is similar to the Cost Centre by Detail Code Summary Report but provides full transactional details for each Detail Code:
An example of the Report is displayed below:
The columns on the Report are as follows:
- Date: This displays the date of each transaction.
- Trans Code: This displays the transaction code of each transaction.
- Journal No: This displays the Journal number of each transaction.
- Ref 1: An addition reference number may have been added to the transaction to help identify it further. Where one has been added it will be displayed in this column.
- Account No: Where the transaction was created from an Account number, this will be displayed on this column.
- Description: Where a description has been added to the transaction, it will be displayed in this column.
- Amount: This will display the amount of each transaction.
The following total details will also be displayed at the bottom of each Detail Code:
- Commitments: This displays the total Commitments for the Detail Code for the specified Period in the specified Year.
- Actual: This is the amount spent for the Detail Code for the specified Period in the specified Year.
- Total Spend: This is the amount in the Commitments total plus the amount in the Actual total.
- Budget: This displays the allocated Budget amount for the Detail Code for the Year.
- Balance: This is calculated as follows: Budget amount less Commitments amount less Actual amount. That is the balance of the specified Year's Budget.
- % spend: This is the amount in Balance column expressed as a percentage, i.e. the Commitment amount plus the Actual amount as a percentage of the Budget amount. This will be over 100% where there has been an overspend.
To run the Report the following options should be added to these fields on the GL Job Request form:
- Report Master: Management Reports
- Report Folder: All Styles
- Report Style: Cost Centre by Detail Code Transaction List
Click on the 
button and the following Parameters and Criteria will be displayed in a Grid at the bottom of the form:
Parameters
The Parameters for this Report are as follows:
- Year: Ensure the Year that the Report is to cover is added to this field - it must be in the full year format, e.g. 2018.
- Period: Ensure the Period which the information on the Report is to cover, e.g. 1, 2, 3, etc, is added to this field.
- Group 1 Level: This field will default to 0 and should not be changed.
- Group 1 Dimension: This field will default to Cost and should not be changed.
Criteria Fields
The Criteria for the Report is as follows:
- Cost code: In the Value field add the code of the Cost Centre to be included on the Report. Alternatively click on the Find Criteria button to the right of this field to search for and select the required Cost Centre.
Click on the 
button.
