Share via


Historical Inventory Trial Balance Inventory Reset Tool for Microsoft Dynamics GP

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

  1. 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.

  2. Download and extract the appropriate HITB_IVReset tool.

  3. 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.

  4. Launch Microsoft Dynamics GP and login with sa or DYNSA. Answer YES to include new code.

  5. Run the HITBIvResetProcedures.sql script in Query Analyzer or the SQL Server Management Studio against all company databases to create the required stored procedures.

  6. Refer to page 6 in the 10.0HITB.pdf for the steps to use the IV Reset Tool.

  7. 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:

  1. Open the HITBIvResetProcedures.sql in SQL Server Management Studio
  2. Press Ctrl + H to open the Quick Replace
  3. In the Find What type Dynamics
  4. In the Replace With type the name of your named Dynamics db
  5. Click Replace All
  6. 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.

Downloads

HITB_IVReset_Build08_GP10.zip - HITB Reset Tool for Microsoft Dynamics GP 10.0 - Build 8 - ZIP (41 KB)

HITB_IVReset_Build04_GP2010.zip - HITB Reset Tool for Microsoft Dynamics GP 2010 - Build 4 - ZIP (97 KB)

GP2013IVReset_Build2.zip - HITB Reset Tool for Microsoft Dynamics GP 2013 - Build 2 - ZIP (113 KB)

GP2015IVReset.zip - HITB Reset Tool for Microsoft Dynamics GP 2015 - ZIP (158 KB)

GP2016IVReset.zip - HITB Reset Tool for Microsoft Dynamics GP 2016 - ZIP (155 KB)

GP2018IVReset.zip - HITB Reset Tool for Microsoft Dynamics GP 2018 - ZIP (164 KB)

GP18.2IVReset.zip - HITB Reset Tool for Microsoft Dynamics 18.2 or later - ZIP (164 KB)

10.0HITB.PDF - Installation Guide for HITB Tool for Microsoft Dynamics GP - PDF (408 KB)

HistoricalInventoryTrialBalanceWhitePaper.pdf - White Paper for HITB Tool for Microsoft Dynamics GP - PDF (595 KB)

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.