Unit Cost Can't be Changed for a Decrease Adjustment error

(0) Share

Report

Posted on by Community Member

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

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

RE: Unit Cost Can't be Changed for a Decrease Adjustment error

thank you... i will pose this to the customer and see what they say..
Olaf Laos 1,890 on at

Like (0)

Report

RE: Unit Cost Can't be Changed for a Decrease Adjustment error

As per Mahmoud's comments;

With respect to "The only problem I had was entering the part back with the unit cost of 634.79...". How is this being done? Via an Inventory Adjustment?

If the quantity on the adjustment line is a negative one, the adjustment will then attempt to decrease the amount of inventory. For decrease, you can't manually override the cost because the system manages this based on the valuation method and serial number details etc - and the user will receive that error message.

If the user is entering an adjustment to put the part back into inventory (ie: increase the quantity on-hand) the quantity is specified as a positive number, and it will then allow the cost to be overridden manually.
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Unit Cost Can't be Changed for a Decrease Adjustment error

You are saying that you were entering the part back !

The error regarding the unit cost only pops up when you are trying to change the cost on an adjustment out document !

Would you illustrate further on the last part ..