Transactions per Type {FGLOR1-21}


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.

Two different stylesheets have been linked to this option:  
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


Example
: of PDF document

Example of ...




Example
: of CSV document

Example of ...




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.


See Also:



History of Changes

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