Historical Inventory Trial Balance Inventory Reset Tool for Microsoft Dynamics GP
Article
The Historical Inventory Trial Balance (HITB) report shows your inventory value as of a specific date or date range and the value of the five different quantity types. Download this tool if you would like to use the Historical Inventory Trial Balance report.
Overview
The Historical Inventory Trial Balance (HITB) 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. The HITB report is available after you have completed the tasks under the Installation Notes section.
System Requirements
Microsoft Dynamics GP 2013 or later
Installation
If you are using Microsoft Dynamics GP 10.0, verify that you are using Service Pack 2 or the latest patch release for Microsoft Dynamics GP 10.0. Click HERE to go to the latest patch release page.
Download and extract the appropriate HITB_IVReset tool.
Copy the IVReset.cnk file into the Microsoft Dynamics GP application folder. The default location is C:\Program Files\Microsoft Dynamics\GP. The IVReset.cnk file only needs to be installed on one machine.
Launch Microsoft Dynamics GP and login with sa or DYNSA. Answer YES to include new code.
Run the HITBIvResetProcedures.sql script in Query Analyzer or the SQL Server Management Studio against all company databases to create the required stored procedures.
Refer to page 6 in the 10.0HITB.pdf for the steps to use the IV Reset Tool.
Refer to page 2 in the 10.0HITB.pdf for the steps to print the Historical Inventory Trial Balance.
NOTE:
If you are using a named Dynamics database in your install, follow the steps below:
Open the HITBIvResetProcedures.sql in SQL Server Management Studio
Press Ctrl + H to open the Quick Replace
In the Find What type Dynamics
In the Replace With type the name of your named Dynamics db
Click Replace All
Use the update file to run against each of your company databases
IMPORTANT NOTICE TO CUSTOMERS
We recommend that you contact your Microsoft Dynamics Partner before installing service packs or hot fixes. It is important to verify that your environment is compatible with the service pack(s), hot fix(es), or download(s) being installed. A service pack, hot fix, or download may cause interoperability issues with customizations, and third-party products that work with your Microsoft Dynamics solution.
FAQHITBKB_3.pdf - FAQ for the HITB Tool for Microsoft Dynamics GP - PDF (136 KB)
We recommend that you contact your Microsoft Dynamics Partner before installing service packs or hot fixes. It is important to verify that your environment is compatible with the service pack(s) or hot fix(es) being installed. A service pack, hot fix, or download may cause interoperability issues with customizations, and third-party products that work with your Microsoft Dynamics solution.