1. Sales Order Management Implementation Guide
  2. Updating Tables

Updating Tables

When you run the Sales Update program, the system generates:

  • Information about customer sales.

  • Accounts receivable and general ledger entries.

  • Sales for different categories, such as stock sales and freight, COGS, and profit percentages.

  • Errors that result from running the program.

Depending on how you set the processing options, the system updates or creates:

  • All status codes according to the order activity rules.

    For example, the system updates all order detail lines with a status of 600 to a closed status of 999.

  • On-hand inventory in the Item Location File table (F41021), the Item Ledger File table (F4111), and the Item History File table (F4115), if the quantity is not updated during shipment confirmation.

    Note: Writing to the F41021 table depends on whether an item's on-hand quantity is decremented at ship confirmation.

  • On-hand inventory for bulk items in the F41021 table, and writes a record to the Bulk Product Transaction File table (F41511).

  • Commission information in the Sales Commission File table (F42005), and summaries of COGS and sales by item in the Sales Summary History File table (F4229).

  • The status to 999 or the specified status in the Sales Order Detail File table (F4211).

  • Costs with the current information in the Item Cost File table (F4105) and prices in the Price Adjustment Ledger File table (F4074).

    Note: The F4105 table is updated only if inventory was not relieved at ship confirm.

  • Invoice information, such as the dates of the first and last invoices, and year-to-date totals for invoices.

  • The Account Ledger table (F0911), Customer Ledger table (F03B11), and S.O. Detail Ledger File table (F42199).

    Note: The business unit that you enter on the sales order header is the business unit that the system updates on the invoice in the F03B11 table.

  • Interbranch sales information.

  • The Ship and Debit History table (F4575) with ship and debit information and the Ship and Debit Claims table (F4576).

Depending on how the processing options are set, the system purges:

  • The header and detail text that is entered in the Media Objects Storage table (F00165).

  • The records in the Sales Order Header File table (F4201). These are sent to the Sales Order Header History File table (F42019).

  • The records in the Sales Order Detail File table (F4211). These are sent to the F42199 table.

The system also creates invoices and assigns invoice numbers to sales orders that you do not process through the Print Invoices program (R42565).