Skip to main content

Accounting Inventory Transactions: Checking and resolving wrong quantities in delivery orders updated from sales orders

Change or delete outstanding quantity from sales order which is wrongly calculated when updating delivery orders from sales order

Updated over 3 weeks ago

To change the outstanding quantity from sales order you need to follow the steps below:

  1. Go to Housekeeping, Manual Update Trancode.

  2. Select the Manual Update Trancode (Iclink.dbf) from ARPSO.

  3. Check the table in the third row with quantity, bill type, and reference no.

  4. If there were no sales orders cleared for deliveries, delete the entries in the third row.

  5. You may change the Quantity delivered to the matching bill type and reference no if the totals do not match the physical count in this table.

  6. Make sure Qty matches the matching To ship (PO) after deleting DO information in the second row of the table.

  7. You may also check the To ship (PO) quantity remaining to match outstanding Sales orders not delivered.

  8. Shipped (SO) are the total cleared goods that have been cleared for delivery.

  9. Make sure Order_cl is blank when all the sales orders have not been cleared for deliveries.

  10. Create a Delivery Order using Up the date SO to DO function:

  11. Do not select Quick Edit, instead, check all quantities manually.

  12. Quick Edit will auto-populate qty from the sales order, and the full order from the sales order quantity outstanding.

Did this answer your question?