Sage 100

Hey all you WO specialists, I'm confused! I have an inventory item which is lot tracked and is included as a material component on a work order. My understanding under this scenario is that the item cost should be included for planning purposes (Standard Cost under WO Inquiry) based upon 'Standard Cost' found in item maintenance. (I love it when the same term is used in two different places to mean the different things. No confusion here!) However, I have a client in which the system is pulling material costs based upon average, which somehow or another went negative and now they have a HUGE negative number under material cost under standard cost in WO Inquiry. What the heck? (I'll find the cause of the negative average cost. I need help understanding why planning costs are pulling from the wrong bucket.)

Warehouse Average cost at the time the work order is created is used for the planned cost.

That sucks. So, what's the best way to reset the average cost value? The client uses Standard Cost for all manufactured goods. For raw materials they use either specific item costing for lotted items or FIFO for non-lotted items. If I adjust Avg cost in Item_Warehouse, just how many evil Genie's am I going to free?

The best way to fix average cost is to take everything out of stock so the quantity is zero and then put it back in at the correct average cost. What version? Hopefully that will fix it.

I'll confirm tomorrow but I believe it is 4.5. I think there are several where the Avg cost is messed up. They haven't monitored it as they don't use it. (Except for it being use to defined planned costs in WO. It is causing some wild swings in scrap and manufacturing variances. Since many of the items are costed by lot, clearing and then re-loading item quantities on a regular basis is going to be a pain. I want to come up with an automated process to keep average costs at a reasonable level.