Updating Tables

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

  • Information about customer sales

  • Accounts receivables and general ledger entries

  • Any errors that the system generates when you run the report

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

  • All status codes as per order activity rules

    After you run the Sales Update program over internally owned shipment orders lines, the system updates order status codes to 999

  • Updates the Item Ledger File table (F4111)

  • Updates the Sales Order Detail File table (F4211)

  • Updates the Outbound Inventory Agreement Acknowledge table (F42I02) if inventory is relieved when running the Sales Update program

    Note: For customer owned VMI orders, the system also creates invoices and assigns invoice numbers to outbound inventory orders that you do not process through the Print Invoices program (R42565). For internally owned shipment orders, the system creates the document number and assigns document numbers to the orders.