Just posted items change with Toolkit and did a Integrity Check in IC as required. Below are just a few examples of the DIC in Adagio Inventory ( DIC in DataCare didn’t show thiese type of errors…)

How to get rid of the problem like these?


Item location file has duplicate location information for item 944.
Item location file has duplicate location information for item 983.
Item location file has duplicate location information for item 1032.
Item location file has duplicate location information for item 1602.
Item location file has duplicate location information for item 1994.
Item location file has duplicate location information for item 2015.
Item 2268 quantity on purchase orders is 0, but should be -24
Item location file has duplicate location information for item 2749.

Hi Fong,

Within Adagio Inventory, use the Item Inquiry with Sales and Costs function and take a look at one of the items listed above. Go to the Quantities tab. I believe you may see the same location listed twice, and one of them will show a quantity on purchase order.

There have been a couple reports of integrity errors such as these - they are valid errors - probably caused by Purchase Orders writing a record to the Item Location data file with the wrong field justification. It may have been fixed, but I am unaware if that is the case.

You likely require a database repair to fix these errors. I would not suggest attempting to rebuild the data until you talk with your Adagio consultant.

I don't believe these errors would have been caused by the Toolkit.