Sage 100

v2017 Premium. The end user is changing the inventory valuation method from average cost to serial for a couple of thousand items. I know the steps necessary to change the valuation. The main concern is once the valuation has been changed, how do I get the item quantities back into inventory at the correct cost. The costs can vary significantly. Do we simply bring all the serialized items back in at the average cost? Should they use a physical count to add the items back to inventory and let the system calculate the cost, or should they use inventory transaction receipts or adjustments and specify the unit cost for each item?

Best case scenario is to adjust the items back in at the correct cost. I would suggest an Inventory Adjustment or Receipt and bring in the proper cost. You will already have to enter the serial numbers so the associated cost would not be terrible. Bringing the items in at average cost seems to defeat the purpose.

Thanks Cooper.

I agree with @CooperBlack if you can have them put it in a spreadsheet and import it as a ""RECEIPT"" type transaction then you can control the cost. One thing to be aware of though is that a receipt type transaction will post to the purchases clearing account; your initial inventory transaction that adjusted all the quantities to zero probably hit inventory adjustments account. So the client will probably need to do a journal entry to reclass the entries to the same account once everything is updated.

Thanks @DavidOverholt