Sage 100

Man, this is a crap day. So, have a client on 4.5 (oh, crap, they may be on 2013 - I can't remember now but if it matters I'll go look it up) who is trying to change an avg cost. They do a negative adj to zero out the QOH. They they do a positive adj at a new cost. It keeps doing an IZ adj and putting it back at the same value. Probably one of those new files, but which?

The items are surely LIFO or FIFO valuation.... correct? I am having the same issue in 3.74. I suspect it has something to do with IM3 not agreeing to IM5. If IM5 shows a negative balance then inv trans update may try and create an IZ to reconcile. Since you are on a recent version, have you tried running the Inventory balancing Utility? This is pure speculation and would love to know the resolution. I may call Sage today on this.... problem is that they don't support 3.74.

OK, so here's what I found on this particular item. The item was already on a sales order. If you looked in the ItemWarehouse file, you could see the Qty Committed was the total OH, and the Cost Committed was the total value at the wrong cost. (Wrong as in not what they wanted, but not wrong according to the file.) I DFDM'd the two Committed fields to 0. Then I did the adjust off, adjust back in one more time. This time it held with the new average cost. I then DFDM's the value back in (new value) to the Committed fields. So I'm going to suggest to them next time they need to do this - delete the item from any sales orders while you are changing the average cost, then add the lines back in. We'll see if that works.

Thanks Beth. That is great info. I will be testing this today.