Run RW Reports

Run GL Report Writer reports (GLR385)

  1. In the menu, expand Base Modules > General Ledger > Other > Report Writer > G/L Report writer  and then double-click GL RW Run Reports GLR385 Report Writer Print selection panel appears. A list of all defined General Ledger Reports are displayed, each identified by a Report Number.  The first panel provides the option to select one of the reports on the list.
  2. Select a Report Format to run. GLR385 Report Run Parameter selection panel appears.

Field Description
Period

 The Period for which to run the report,  this defaults but can be overridden.

Company

 A range of Companies can be selected for inclusion in the report.  To consolidate all Companies set the Consolidate flag to ‘Y’.

Prof ctr level 1-3 A range of Profit Centre levels can be selected for inclusion in the report.  To consolidate all profit centre levels set the Consolidate flag to ‘Y’.
Profit centre group A range of Profit Centre Groups can be selected for inclusion in the report.  To consolidate all Profit Centre Groups set the Consolidate flag to ‘Y’.
Profit centre A range of Profit Centres can be selected for inclusion in the report.  To consolidate all Profit Centres set the Consolidate flag to ‘Y’.
Print zero lines Indicate whether all accounts, even those with zero balances should print on the report.  An entry in this field will print zero balances and if this field is left blank it will instruct the system to not print zero balances.
Include closed p/centres Indicate whether Profit Centres that have been flagged as closed should print on the report.  Select the field to include closed Profit Centres, or leave this field blank to not include closed Profit Centres.
Level of detail Indicate the level of Detail to be printed on the report.
Print sub-headings Indicate whether or not to print Sub-headings on the report.
Print actuals Indicate whether or not to print Actuals on the report
Print budgets Indicate whether to print Budget values on the report.  Select the field to print Budget values, or leave this field blank to not print Budget values.
Budget type Select the type of Budget to be used for printing Budget values.
Currency Select the Currency the report is to be printed in.
Year start month Select the month from which you would like the report to start, for example, the beginning of the financial year will be 00.
Output device

Select the type of Output Device from the options provided on the screen.

P = will create a spool file only

D = will create an excel output only. 

B = Both the spool file and an excel will be created. 

Note For Output device options D and B, template GLR385 must exist in the appropriate network drive for the excel report. The excel report will not pop up; it will be written to the nominated network path specified in XAM160 Document exchange.
  1. Enter the above selection fields and click OK to generate the report.