Dynamics GP - The Historical Inventory Trial Balance Reset Tool and Report

 

 

If your company has ever wanted to have historical information about inventory, the Historical Inventory Trial Balance (HITB) Reset Tool  is a tool you will want to add to your Dynamics GP toolkit.  And, yes, it is different that the Historical Stock Status report that users can find under Inventory>Reports>Activity>Historical Stock Status.

The Historical Inventory Trial Balance  report shows your inventory value as of a specific date or date range and the value of the five different quantity types. You can use this report to balance your inventory value with the appropriate accounts in General Ledger. 

Microsoft created this tool so that it creates a starting point where the General Ledger and Inventory Control Balance, and then the tool creates the report.

• The HITB Report was specifically designed to balance IV to GL
• The report shows your inventory value as of a specific date or date range and the value of the five-different quantity types. (On Hand, In Use, In Service, Damaged, Returned) The Historical Stock Status report only shows on hand quantities.
• The HITB Report shows specific cost adjustments which can cause the inventory balance to differ from the General Ledger balance
• The HITB Report always updates when a transaction is posted to the General Ledger. 
• The HITB Report works faster that the Historical Stock Status report

The Historical Inventory Trial Balance Reset Tool has specific steps that must be followed to correctly install it.  Microsoft Partners and Customers can find the system requirements and installation notes at https://mbs.microsoft.com/customersource/northamerica/GP/downloads/service-packs/MDGP10_HITB#Downloads.

For more information on Microsoft Dynamics GP or available tools for Dynamics GP, contact us at Dynamics MCT Consulting.  Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP