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 the history records that the system writes to the F4111 table. If you subtract the on-hand quantity from inventory during:

  • Shipment confirmation, the system creates a record in the F4111 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.

  • Sales update, the system writes the invoice number, type, and general ledger date to the F4111 table.

    No record is written during shipment confirmation.

    Note: If the user relieves the inventory for an item during shipment confirmation and after relieving, if the user changes the standard cost of the item in the Work With Item Cost program (P4105), the Sales Update application (R42800) retrieve the Standard Cost value from the Item Ledger File (F4111).

To relieve the on-hand quantity for an item during shipment confirmation, you must add order types to the user-defined code (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.

See "Locating On-Hand Quantity Information" in the JD Edwards EnterpriseOne Applications Inventory Management Implementation Guide.