Purpose
This function is used to add or change parameters for each End Of Day (EOD) report available to run via the EOD Reports Manager tool. It is a software development tool and as such should not be made available to general users.
Data Input
Step 1 – EOD Report Code
Report Sequence Code
Enter ‘N’ for “Next” to allocate the next available ‘EOD Report Code’ when adding a new report to EOD. You can also enter or search for an existing EOD Report Code so you can edit/update details. To find existing reports, searching by the actual report code or report name is best.
The code for each EOD report is a system allocated sequence number of no significance, except for code ‘DEF’ which contains the default EOD report destination details. The code ‘CTLVAR’ is another exception – this code contains flags to indicate if any variances detected in the sub ledger control reports have been reported. Do not maintain information about the DEF and CTLVAR codes using this function. Default destination details (DEF) are maintained via the EOD Reports Manager and the CTLVAR details are system maintained.
Return to the Top
Step 2 – Details
Report Code
This is the code of the report to launch. Only an existing report can be selected and this is a mandatory entry.
Override Report Name
If nothing is entered here, the report name is taken from the Report Query. However, if there are multiple EOD report options using the same Report Query, then you need to distinguish them by entering an Override Report Name here. For example, the ‘Print and Post General Journal’ report is triggered at several stages during End of Month so the override report name specifies if it’s the stock, GL or Assets EOM report. If you don’t do this, then you will see duplicate names in the EOD Report Manager and it will cause confusion.
Sequence
This is only required if multiple EOD report options using the same Report Query (varying by filter only) are used. For example, the Tax Summary report is run at Debtors End of Month and Creditors End of Month. This sequence number helps to distinguish the correct report instance. It is coded into the proc when the report is triggered. The correct report ‘instance’ is found by matching the Report Code : Sequence via a btree index.
Mandatory
Select this if you do not wish to allow user’s to be able to exclude this report from an EOD run via the EOD Reports Manager. For example, the Interest Charged report would not be mandatory – not all sites charge interest, however the Profit & Loss Clearing report that is produced in period 12 as part of GL EOM is extremely important so users should not be able to exclude it. Selecting mandatory causes the ‘Exclude’ check box in the EOD Reports Manager function to be disabled so that the user cannot exclude the report from the run.
Branch Report Code
If the report is capable of branch reporting (i.e. the output can be logically separated by branch) then enter a code here. This code triggers the ability to edit destinations by branch in the EOD Reports Manager. If no code is entered here, the EOD Reports Manager shows a disabled button labelled ‘N/A’ for ‘not applicable’.
Branch Reporting Dict ID
This is the dictionary ID of the report file that defines the branch data extraction for the file being reported on. This is required for formulating queries to the database. It is used as a filter for branch reporting. If blank, the default dictionary ID ‘BranchCode’ is used.
When To Run Code
The ‘When To Run’ code defines when the report is included when EOD runs. For example, if you want to run a report when EOD is run on Fridays, you can choose the code ‘Every Friday’. If you want to run a report when Assets EOM is run, choose ‘End of Month Assets’. This ‘when to run’ code appears in short format on the EOD Reports Manager and can be used to sort the reports
Report Type
This defines what section of the EOD Reports Manager the report will appear in for maintenance. For example, ad-hoc user created reports appear in the ‘Other’ section whereas available standard sales reports appear in the ‘Sales Formatted’ reports section.
Formatted Report Code
For Sales and General Ledger formatted reports, this is the report code to run e.g. P682A-9