Sage 100

Doing an upgrade from 4.3 to 2016. Running the pre-migration steps, specifically, the Inventory Balance Util. For the items that appear on the list, the Whse Qty matches the Valuation Rpt, but the Trans Qty does not match the Detail Trans Rpt. Where does the Trans Qty come from? At first glance, the client thinks the Whse Qty is the right answer - but if I remember correctly, it's going to make adjustments to the Detail Transaction WHICH DOES NOT APPEAR TO BE WRONG!? Has anyone run into this before, what did you do? - Thanks

If you run imzbl1 in version 4.3 your item cost table can be balanced to the warehouse table. Then I'm pretty sure that the balancing utility can be run to add ""dummy"" transactions to to transactions table to match those two tables.

@DavidOverholt is the item cost table where the trans qty is coming from? will give that a try.

Greg, I'm not 100% sure which field that is, but from memory, I believe that is calculated based on the IM5 Transaction history table. I remember having to run IMZBL1 at one client to get Im2 (warehouse) and IM3 (cost detail) to match. Then, I was thinking the pre-migration utility let you decide whether to add a balancing transaction in the transaction detail table or change the warehouse quantity to match the detail.

I balance to the greatest detail. More likely has the most accurate audit trail, unless an update was interrupted.