The End of Day application processing options set-up determines the default values that update the customer sales program, and also creates General Ledger and Accounts Receivable entries.
- Go to EnterpriseOne Menus | Order Management | Sales Order Management | Daily Sales Order Management Processing | End of Day Processing, and then select Update Customer Sales (R42800). Click on the Row menu and then select the Processing Option.
- In the Invoice Date option, enter the invoice date for the accounts receivable.
- In the Select Date Value as A/R Invoice Date option, specify the order processing date.
- Enter the Specific Date as G/L Date.
- For the Date Value as G/L Date option, specify the order processing date. If you do not specify a G/L date in this field, then you should specify a value of either 1 for Sales Invoice, 2 for Ship Date, or 3 for Execute Date.
- Specify the G/L Account Business Unit to which the system assigns general ledger entries, if you do not specify a business unit in the AAIs.
- For the Override Next Status Code option, enter the UDC (40/AT) that is the next step in the order process.
- On the Update tabbed page, select the mode as either Proof or Final mode.
- Use Bypass Update to Accounts Receivable (F0311) especially for cash sales orders, as the system does not create an AR invoice for these order types.
- Specify Bypass Update to Inventory (F41021/F4115) , if the system updates On-Hand inventory in the F41021 and F4115 tables.
- Specify Bypass Update to Commissions (F42005), if the system updates the commission information in the F42005 table.
- Specify Bypass Update to Sales History Summary (F4229) , if the system updates the F4229 table.
- Specify Purge to Sales Detail History (F42119), if the system purges detail information from the F4211 table.
- Specify Purge to Sales Header History (F42019) , if the system copies records from the F4201 table to the F42019 table, and then deletes the original records.
- Specify the A/R Next Number index to indicate the next number that the system uses to assign an invoice (Account Receivable) number.
- Specify the Sales Journal Version (R42810) that the system uses to print the sales journal before running the Update Customer Sales program.
- Specify whether the system writes General Ledger journal entries in Summary or Detail.
When you set up the Sales Update (R42800) processing option, you should specify the specific date to use as the accounts receivable invoice date. You should also enter the specific date for G/L Date in the processing option. The R42800 processing option provides the set up of default values that affect the cost update, interbranch orders, flexible accounting, bulk products, agreement management, and prepayment processing. Through the R42800 processing option, you can also instruct the system to avoid updating the tables during the Sales Update process. You can also control the sales journal printing option, and define whether entries are written in detail or in a summarized format.
When you run the Customer Sales Update, the system will move the order detail lines from the F4211 table to the F42119 table based on the processing option set-up, in order to improve system performance.