Typical functions performed by the various Period End Processes are as follows:
EOD End of Day
- Auto scheduling of end of day processing
- Various auditing and control reports
- Flexible daily sales and stock reports
EOM End of Month
- Run after an EOD
- The sales and stock (distribution) EOM can be combined with the Debtors EOM or run separately
- Transactions are summarized for each accounting period
- Debtor EOM updates the debtor files and purges necessary information, for each accounting period.
- Periods are closed off.
- AP and GL EOM can be run at any time and can be run as a combined process
EOY End of Year
This is general ledger function to transfer Profit and Loss values to the balance sheet
End of day
The end of processing run may be carried out at different times of the day but usually run outside normal working hours.
The following tasks will be performed:
- The interface file (to the general ledger system) is created for all transactions entered to the accounts payable module since the previous end of day. If the document type consolidation flag on the system control file is set to Y for consolidate, one summarized entry is written to the accounts payable control account, grouping invoices of the same document type together. All individual invoices can be viewed on the same journal. The reference number on the summarized entry is the accounts payable daily control number. If the consolidate flag is set to No, an individual entry is created for each transaction.
- An audit trail listing all today’s accounts payable transactions sequenced by creditor, invoice number.
- The control number is incremented on the system control file.
- Job submitted to load the current period’s AP figures into InfoMaster.
End of Month
The end of period processing run should be carried out at the end of each accounting month.
The following tasks are performed during the end of period processing:
- The current accounting period is advanced and transactions are aged.
- The accounts payable transactions are purged depending on the retention period defined by the user at the setup time.
The creditor masterfile records are purged for closed accounts but only if no transactions or balances exist.
Distribution End of Month
The distribution EOM can be combined with debtors EOM. The sequence of events is to first run an EOD, then the sales and stock EOM and then the debtors EOM. If the warranty and service module is in use, this module’s EOM must be run before the debtors EOM so that the claims/credits generated by the warranty process are included in the debtors update.
The sequence and use of background functions as performed by this EOM process is listed below:
- Retrieve current period
- Stock reset
- Increment period
- PSI reset and Purchase Order update
- Next month inventory update
- Warehouse Location History Update
- Update Rebate Earned
Other EOM processes that can be run separately are:
- Goods In Transit (GIT) updates
- Sales Budget Rebuilds
- BI monthly Processing – check if active
Debtors End of Month
The debtors EOM can be combined with Sales and Stock (Distribution) EOM and must run after the distribution EOM process.
The debtors EOM can also be run in two stages: according to Debtors Accounting Period and then again according to Collection Period. This caters for companies who want to keep their collection period open for a while after the distribution periods have closed off.
The sequence and use of background functions as performed by the debtors EOM process are listed below:
- Retrieve current period
- Increment A.R period
- Reset A/R Age, Movement, Transaction
- Next Month Transaction Update
Other EOM processes that can be run separately are:
- Debtors Exchange Gains/Losses
Service End of Month
This function is used by warranty and service module. It performs a mostly reset which includes creating the monthly files for the job card files.
InfoMaster End of Month
The InfoMaster EOM will be submitted if BI is active.
End of Day Report Reprints
These reports are run from the EOD process and can be reprinted as of the EOD by entering the control number.
The details of these reports can be found in the section Reports and Processes run from various End of Day programs from DSCEOD.
The reports that can be reprinted are:
DSZ010: Claim allocation discrepancy
DSR580: Daily Lost Order Report
DSR845A: Daily Sales by Title/Cust
DSR610: Daily Stock and Sales Report
DSR360: Dist Detailed Audit Trail
DSR847: Orders Past Delivery Date Report
DSR735: Price Exception Report
DSR120: Returns Loading Report
DSR215: Unit Cost Discrepancy Report
DSR581: Daily Lost Order Report)
