Item Inquiry On SO quantity does not match the Orders tab total quantity
Description

To find 1-step sales order invoices for the item in question:

  1. Open Library Master, Utilities, Data File Display and Maintenance
  2. Browse to ....MAS90\MAS_xxx\SOxxx\SO_InvoiceDetail.m4t (where xxx = Company Code)
  3. Select Key No, KITEM
  4. Type the item number in the Key field and hit enter
    • This will return the first invoice line with that item number
  5. Click the right arrow to advance to the next record

Cause

There are one-step invoices (no Sales Order associated) in Invoice Data Entry which have not been updated.
If batches are enabled, there could be an invoice in a batch that does not show in look-up.

When using a job number in sales order entry, you must add a cost code/type on the lines tab for each line.

Resolution

When a one-step Sales Order invoice is created, the Item Inquiry On SO and Committed quantities are increased by the quantity on the invoice. The In Shipping field in Item Inquiry is also populated with the quantity. There is not a Sales Order that is referenced on the Orders tab.

If the Orders tab total does not match the On SO amount on the Main tab, check the In Shipping column to see if there are one-step invoices (with no Sales Order) that are not updated.

Or, if job cost is used....

Enter a Cost Code and Cost Type on the lines tab for the item in question.

DocLink: Quantities are incorrect for PO, SO or WO in Item Maintenance and Item Inquiry
Defect ID
Steps to duplicate
Related Articles