Distribution, Manufacturing, and Internet Modules

[andrew4]

We are changing from average cost to FIFO for all inventory items. In testing this in a test company, I noticed that for the new established cost it pulls from Last Cost. If we believe that Standard Cost is more accurate than Last Cost is there any way to make it pull from Standard Cost instead?

MAS 200, version 4.4.

[givingtr]

If you don't use the "Allocated" field in Item Maintenance, you could import the difference between the Standard Cost and Last Cost into the Allocated field. Valuation Change Maintenance will use the Total of Last Cost and Allocated Amount as the new cost. I haven't done this before, so test it first.

[andrew4]

The import you suggested seemed to work in instances where the standard cost is higher than the last cost, but when the opposite is true a negative amount in allocated cost is required, and it doesn't seem to take negatives. Unfortunately, most of the ones we need to adjust would be negative.

How about just importing directly into Last Cost before we do the valuation change? Anyone see any issues with this?

[givingtr]

Interesting. I can manually enter a negative into the field in Item Maintenance, so wonder why you can't import a negative?

[andrew4]

After further testing it doesn't seem that it does go off of Last Cost.

So, here is a more general question: how can I control the costs assigned to items after the inventory valuation is changed to FIFO? I don't care if I need to import the correct costs before or after the valuation change, I just want them correct in the end. I have a list of correct costs for each item--how can I put them into action?

[givingtr]

You could do a physical and bring all qty's to zero. Then import the qty's and costs as Receipts into IM transaction Entry. I'd turn off integration to the GL if you don't want it to update. Else, you'll have to follow-up with a couple JE's to true up Purchase Clearing, etc.

[DLB]

If you are changing from average cost to FIFO, the newly created FIFO tiers should be using the average cost from the IM_ItemWarehouse table.