Updating On-Hand Inventory

You can relieve the on-hand quantity for an item during shipment confirmation or sales update. The method that you select affects when the system writes history files to the Item Ledger File table (F4111). Consider these points when determining which method to use:

  • If you subtract the on-hand quantity from inventory during shipment confirmation, the system creates a record in the Item Ledger table with the sales order as the document number and the order type as the document type.

    During sales update, the system overwrites the record with the invoice number and type, general ledger date, and batch number.

  • If you subtract the on-hand quantity from inventory during sales update, the system writes the invoice number, type, and general ledger date to the F4111 table.

    No record is written during shipment confirmation.

To relieve the on-hand quantity for an item during shipment confirmation, you must add order types to UDC table 40/IU. During sales update, the system overwrites the F4111 table record with the invoice number and type, general ledger date, and batch number.

You can also use processing options to auto acknowledge or manually acknowledge the receipt of outbound inventory orders at the customer's location. When you set the processing option to automatically acknowledge the receipt of outbound inventory, the system updates the quantity during shipment confirmation at the locations specified in the outbound inventory branch/plant. If you select the processing option to manually acknowledge the items received, you must use the Acknowledge Outbound Order Receipt application to manually acknowledge orders. The system then updates the quantity at the locations specified in the outbound branch/plant.