Costing Help
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.
Open the Costing folder and click Reports
or click the Financials tab
on the Ribbon Bar and then click
Costing
- Reports.
Click Transaction Report.
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.
Do one of the following:
To include transactions entered today, select Today's.
To include transactions within a range of dates, select Date Range and then, under Transaction Dates, enter the range of dates required.
To include transactions entered in the current period, select This Period.
To include transactions within a range of periods, select Period Range and then, under Year/Period, enter the range of periods required.
Under Include Transaction Types, select the transaction type(s) to be included in the report.
Under Options, select Cost Code Summary or Type Summary as required to print cost code or cost type subtotals on a change of job.
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.
Click OK.
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.