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 |