Please make the balancing utility like the Pre-Migration Inventory Balancing Utility where you can choose which report/file is correct.

The utility is used when the stock status report and inventory valuation report quantities don't match. The utility will only correct quantities to match the valuation report. If the valuation report is not correct then the procedure per sage tech support is to enter inventory transactions and determine if you need to deselect the gl integration. I have not found any documentation to detail these steps.

This is an unacceptable process because it is too easy for the IM and GL to become off and the inventory quantities to become a disaster this way. A good ERP system shouldn't be this hard and labor intensive to keep a proper count. If you have 100 items that are lot tracked and each item has 100 possible lots to choose from of the same quantity, it would take a very long time to find the right lot and the potential to make a mistake is high. You would need to do 100 inventory transactions and find the exact lot and determine if the original transaction actually posted to the gl. It is a lot of work.

From Help:
Use IM Balance Inventory Quantity and Cost to correct out-of-balance inventory items.

For items that use the FIFO, LIFO, Lot, and Serial valuation methods, this utility assumes that the quantities and costs that appear on the Inventory Valuation Report are correct. The utility compares the Item Cost file, which is the source of the quantity and cost information on the Inventory Valuation Report, to the Item Transaction History file, which is the quantity and cost information source for the Inventory Detail Transaction Report. If discrepancies exist, you can elect to have the utility create adjustment transactions for the quantity, cost, or both. (the adjustment transaction here does not mean the ones that you manually have to enter. this is the one that adjusts the inventory the wrong way)

by: Christine K. | over a year ago | Sales & Distribution