Sage 100

Upgraded a client from 4.4 to 2016 this past weekend. Everything seemed to go well except we have an inventory SNAFU. They system automatically ""Recalculated Item History"" and now we have some items that have 0 quantity and 0 unit cost but have an inventory valuation. Is there a quick way to fix this without making a bunch of entries or editing a ton of records in DFDM?

Copy live company to a test company and test this in the test company first. Create a file with the affected inventory items. Import (and then update) an inventory adjustment transaction with a qty of 1 and a cost of $1.00. Then import the same items with a qty -1 and unit cost equal to whatever is showing on the valuation by period report.

I was thinking about doing something like that, @DougHiggs . I can actually export the IM_ItemWarehouse file and filter the items that have 0 count and a valuation amount to get a definitive list. I'll discuss the options with the client and keep you posted.

Great. Be sure to update after the first import.

You could use a cost of $.01 instead of $1.00 to reduce the potential risk.

Curious @ChuckPeddy did you rebuild the files and sorts prior to migration and conversion? I'm just wondering. Sometimes it seems like a useless exercise when you still have theses types of issues post conversion.

Yes, @MoiraGoggin , I did a rebuild before and after when we noticed the problem.

I usually import a transaction entry qty of 1 with the cost negative the amount on the valuation report. Post that and you will have qty 1 with value zero. The you import again with qty -1 and cost zero. That will clear the qty to zero