QTYSHNOCST field NOT zero and day end has been run

SOLVED

Client has issue that appeared when comparing the IC Location Details screen to the Service Manager Location Details screen.  The Quantity On Hand for an item did not agree.  The IC Location Detail screen had a lower quantity that I understand was a result of an inventory adjustment entry. 

Given that the two screens are looking at the same data it seems strange.

Looking at the data in SQL I discovered that the field QTYSHNOCST had a value equal to the adjustment quantity.  I would expect that field to be zero after day end.  I ran data integrity check with the  fix option on and it reported that item data was wrong but didn't fix it.

Is there a repair or hot fix for this issue?  Does anyone know how or why the issue occurs?

Technisoft provided a fix that brings their location details screen in agreement with the IC location details screen which is great but the issue is really in Inventory Control because the QOH is not updated correctly.

Any and all advice greatly appreciated,

Dana

Parents Reply Children
No Data