When posting some inventory adjustments our customer is getting the following errors โThe serial numbers and extended quantity for this item do not balanceโ and โSerial numbers already exists for this item and site in the Serial Numberโ.
I sent the customer TK Article ID: 943954
Customer says:
I did some digging in a copy of our live DB, and found that the inventory serial and lot number work table (IV10002) is missing entries for the transactions that are removing inventory. Reason being when they were set up, due to some negative allocations we have, they were not able to get a serial number assigned, despite the fact the serial numbers were available.
In our TEST db I removed the item in the transaction A00278021 which is relieving inventory of the part K1008016 serial number DMTA005082. I then removed all allocations for that part number, and was able to add the part on to the adjustment and allocate the serial number. I need to run reconcile to correct any existing allocations.
The only problem I had was entering the part back with the unit cost of 634.79. Itโs only letting me put 410.52. with error โunit cost canโt be changed for a decrease adjustmentโ not sure what we can do on this one. Ideas?
*This post is locked for comments
I have the same question (0)