Transaction Report

Use the Transaction Report to produce a list of all transactions for the ranges selected, with totals for transaction types. You can print records in the order entered or you can choose a range by job, cost code, date and period. If the report is printed in job sequence, you can also choose whether transactions are listed or summarised by cost code for each job. Options are provided so you can select which transaction types are included. Under Options, you can choose whether you want cost code or cost type subtotals printed on a change of job.

When specifying a range under Year/Period on the Costing Transaction List form (having selected the Period Range option), your selections are validated against the current year and period defined on the Set Options form and you are not allowed to select periods or years greater than the current ones. If you want to include forward transactions, you can do this by selecting a date range. To do this, select the Date Range option and specify the range under Transaction Dates.

To Print the Transaction Report

  1. Open the Costing folder and click Reports or click the Financials tab on the Ribbon Bar and then click Costing - Reports.

  2. Click Transaction Report.

  3. Under Sequence, click to select the sequence for the report. You can select 'As Entered', 'Cost Code' or 'Job' from a list. The default is 'Job'. For either the 'Job' or the 'Cost Code' options, you can choose the range of records to be included under Job Selection or Cost Selection. If the sequence is by job, an additional option called Show Transactions is available. With this option selected, transactions are listed by job with job subtotals. If the option is cleared, a cost code summary is provided per job with job totals.

  4. Do one of the following:

  5. Under Include Transaction Types, select the transaction type(s) to be included in the report.

  6. Under Options, select Cost Code Summary or Type Summary as required to print cost code or cost type subtotals on a change of job.

  7. On the Criteria tab, you can specify additional selection criteria. You can define ranges for cost code, department, sales account and project leader. Note that specifying a cost code range effects actual costs rather than budgets.

  8. Click OK.

  9. On the Publisher form, click the tab to select the output device you want to use and then complete any settings or options you want to apply to the output device. To process the output, click Publish.

To save this report as a Microsoft Excel spreadsheet, select Excel Report from the Report Layout box on the Publisher form.

When specifying a range under Year/Period on the Costing Transaction List form (having selected the Period Range option), your selections are validated against the current year and period defined on the Set Options form and you are not allowed to select periods or years greater than the current ones. If you want to include forward transactions, you can do this by selecting a date range. To do this, select the Date Range option and specify the range under Transaction Dates.