That is an old utility that you do not want to be running.  The current balancing utility is "Balance Inventory Quantity and Cost".  Depending on your version, it should be on the *UTL menu.  For Lifo/Fifo/Lot/Serial items, it will look at the totals in the IM_ItemCost table (The cost tier masterfile) and compare the totals to those from the item transaction table (IM_ItemTransactionHistory).  Any differences will be (optionally) corrected by the creation of new adjustment transactions.  It will also give an option to update the total quantity and value in the item (CI_Item) and Item/Warehouse (IM_ItemWarehouse) tables.  This option will be given even if no adjustments are made.  If any adjustments are made, the "Recalculate Item History" utility should be run next (I/M Utility menu).  It will update the I/M history tables based on the Item Transaction table.

KBatch,

Thank you for that quick reply.  That was the actual utility I was referring to.  Thank you for your description of this utilities function.  Unfortunately I don't think this utility will help me.

Given your knowledge I would like to get your thoughts on my current issue.  Basically I work for a company that has poor processes and does a very poor job of using the system to maintain accurate inventory.

Our inventory quantities are only accurate once per year and that is when we perform a year end inventory physical.  But after the physical is processed and posted if I run Recalculate Item History which I am supposed to do the utility runs and messes up the QuantityOnHand balance of the IM_ItemWarehouse file.  Thus we never have accurate quantities in the system.  And since I cannot run a VI job that could update the QuantityOnHand field to be the actual physical item count I do not know what to do.

Do you have any advice on this delima?  I wish Sage would actually make the physical count the physical count rather than performing an adjustment to the transaction file.  Poor logic design in my developer's opinion.

Thank you again for any direction you might have...

All of the history and on-hand values are tied to the transaction table.  I would suggest running the balancing utility directly before freezing and entering the physical count.  You would then be starting from a point where everything is in balance.  Any Physical Count adjustments would then carry to the quantity buckets.