This report reflects the summary
or detail of
transactions for a specified range of types and for a specified period.
Subtotals per type for debits and credits are calculated.
Only posted transactions are reported.
User Selection | Prompt Text * an item between square brackets [ ] is the default answer |
Type & Length |
Comments |
---|---|---|---|
Report to be Extracted in Excel or CSV Format (Y/N) | A1 | ||
Enter the Reporting Year | YYYY | ||
Enter Start Cycle | N2 | ||
Enter End Cycle | N2 | ||
Enter Start Transaction Code [0] | N4 | ||
Enter Start Transaction Code [9999] | N4 | ||
Enter Start Reference Number or [ALL] | A12 | ||
Do you Want to Select between Dates (Y/N) | A1 | If your selection = Y the next prompt
is 'Enter Start Date' If your selection = N the next prompt is 'Enter Subsystem of Origin of Transaction Types (AR, BC, CB, CT, GL, LL, PM, PR, SD, or [ALL])' |
|
Enter Start Date | DD-MON-YYYY | ||
Enter End Date | DD-MON-YYYY | ||
Enter Subsystem of Origin of Transaction Types (AR, BC, CB, CT, GL, LL, PM, PR, SD, or [ALL]) | A3 | ||
Do you Need an Exception Report (Y/[N]) | A1 | If your selection = Y the next prompt is 'Enter Start Date' | |
Specify [C]c or (A)ccount or (G)LA | A1 | If your selection = C the next prompt
is 'Enter the Start Cost Centre' If your selection = A the next prompt is 'Enter the Start Account' If your selection = G the next prompt is 'Enter the Start Cost Centre' |
|
Enter the Start Cost Centre | A4 | ||
Enter the End Cost Centre or <Return> if End is the same as Start | A4 | ||
Enter the Start Account | A8 | ||
Enter the End Account or <Return> if End is the same as Start | A8 | ||
Test for the Specified Combination to be [T]rue or (F)alse | A1 | ||
Summary or [D]etail | A1 |
Sort Order | Per | Comments |
---|---|---|
System Select | |
---|---|
No special system selection |
|
|
Processing Rules |
|
---|---|
When the report is run with Report to be Extracted in Excel or CSV Format (Y/N) = 'Y' the report will not produce any headings or page breaks. The output will also be comma delimited. This is to make it easier to use in MS-Excel. |
Date | System Version | By Whom | Job | Description |
---|---|---|---|---|
12-Dec-2007 | v01.0.0.0 | Amanda Nell | t146612 | New manual format. |
27-May-2009 | v01.0.0.1 | Charlene van der Schyff | t158348 | Edit language obtained from proof read language Juliet Gillies. |
22-Apr-2012 | v02.0.0.1 | Raymond Schoonraad | t176548 | Add input parameter to enable easier exporting to .csv |