Hi,
We recently noticed that the "Qty On S/O" in the "Quantities" tab in ICWIN Item Inquiry is displaying different numbers than those stated on the Order Action reports.

For example, one of our items shows 872 in Qty on S/O, meanwhile the sum of all the orders for that item on the Order Action report in OEWIN is only 130. Our Open Order Crystal report agrees with the latter. Where is Qty On S/O field pulling the data from?

Thanks.

A few questions:

• Does your database pass the Data Integrity Check without errors?
• What versions of Adagio Inventory and OrderEntry are you running (see Help | About)?
• What is the costing method for the item in question?
• Have you customized the Order Action report in any way?

The Data Integrity Checks comes out clean.
ICWIN 8.1B (100310) and OEWIN 8.1C (100208).
All our Items use standard costs which consists of material cost from the BOMs + a percentage for overhead.
Besides picking and choosing what fields to include, the Order Action report is not customized in any way.

Thank you.

The Qty On S/O is the sum of the open orders.

As you are on an older version of OE, you have only just noticed this problem, and no one has complained about this issue, then something has changed in the way you use Adagio or your Adagio setup.

It could be a timing issue. Check to see if the difference is the Qty shipped not costed. I believe you will need Adagio Reports or GridView to see this number, its not on the Item Inquiry.