About Day End Processing

Learn more

You perform Day End Processing in Inventory Control, using the I/C Day End Processing screen. To keep your audit trail and reports up to date, you should run Day End Processing as part of your daily routine.

Day End Processing processes all transactions posted since the last time you ran Day End Processing, and performs several tasks, depending on the processing options that you select in Inventory Control, Order Entry, and Accounts Receivable:

Activates and posts future orders that have reached their order date, and updates the quantities on sales order. When Day End Processing is complete, you can print order confirmations and picking slips, enter quantities shipped, and issue invoices for these orders.

Tip: If you usually run Day End Processing at the end of the work day, future orders set to be activated on a certain day become active only at the end of the day. To be sure a future order is ready to be processed on the correct date, assign a date earlier than the desired date for the order.
Removes quotes with expiration dates up to and including the session date for Day End Processing,and deletes expired quotes from the system if you selected the Clear Expired Quotes option and specified a number of days on the O/E Options screen.
Optionally, costs items and creates subledger transactions in Inventory Control. Depending on whether you cost inventory during posting or during Day End Processing, you can set options to cost items and create subledger transactions in Inventory Control, on the I/C Options screen.

Costing inventory during posting ensures that item costs are updated immediately. However, because costing calculations require more system resources, they can slow down processing. To avoid delays, you can select the Cost Items During Day End Processing option on the I/C Options screen.
Calculates the unit cost for each item on an invoice, using the item's costing method. (For more information, see the Inventory Control help.) The unit costs calculated are the default unit costs for credit notes entered against the invoices.
Updates costing information for LIFO- and FIFO-costed items in Inventory Control.
Updates Inventory Control with the costs of items returned as negative shipments on invoices.
Updates statistics and history in both Order Entry and Inventory Control.
Updates sales commissions if you selected the Track Commissions option on the O/E Options screen, and if you entered salesperson commission rates in Accounts Receivable (or if you allow commissions for item categories in Inventory Control).
Creates a batch of Accounts Receivable summary invoices and credit notes from posted Order Entry transactions using the next available Accounts Receivable batch number. For more information, see About Batches Created in Accounts Receivable .
Creates the invoice and credit note posting journals in Order Entry for the new day-end sequence number. These journals are the detailed records of the general ledger entries that will be created when the Accounts Receivable batches are posted.

Improving the Performance of Day End Processing

Important! The time required to complete Day End Processing varies according to your computer and the number of transactions you entered since the last time you ran Day End Processing. We recommend that you run Day End Processing overnight, or when you do not need to use your computer for other tasks.

If performance is important, you can select the following options:

On the I/C Options screen, select the Cost Items During Day End Processing option, rather than cost inventory during posting.
On the O/E G/L Integration screen, select the Create G/L Transactions Using Create Batch Screen option.
On the O/E Options screen, select the Post A/R Batches On Request Using Create Batch Screen option.

Inventory Control Costing Options

The costing options you select in Inventory Control determine whether the following additional tasks take place during posting or during Day End Processing:

Updating item costs in Inventory Control
Creating audit records or general ledger transactions
Updating sales statistics and customer accounts in Accounts Receivable

This flexibility allows you to decide between processing speed and keeping your inventory data up to date.

If you select the Cost Items During Day End Processing or Create Subledger Transactions And Audit Info During Day End Processing options on the I/C Options screen, you must run Day End Processing in Inventory Control to finish updating Order Entry, General Ledger, Inventory Control, and Accounts Receivable.
If you cost inventory items during Day End Processing, the program will also create subledger transactions then. (You will not be able to select the Cost Items During Posting option.)
If you cost items during posting, you can also specify when to create subledger transactions and audit information—during posting or when you run Day End Processing.
If you want to speed up order processing, you should create subledger transactions and cost inventory when you run Day End Processing.

Posting to Locked Fiscal Periods

If a fiscal period is locked for General Ledger but not for Order Entry, you can create batches for General Ledger in the following ways:

During posting.
Using the G/L Batch screen (depending on the options you select on the O/E G/L Integration screen).

Note:

If you try to post transactions to a locked period in General Ledger, transactions will be added to an error batch. To prevent this from happening, create and post General Ledger batches for outstanding Order Entry transactions before locking the period for General Ledger.

Similarly, you can create transactions for Accounts Receivable from Order Entry transactions, but you cannot post them to a period that is locked for Accounts Receivable.