HITB Essentials Series – HITB Reset Tool Deployment

Following up with the HITB Essentials Series, in a previous post HITB Reset Tool and SEE Tables, several technical aspects of the inventory reset process were provided.

In this post, a quick overview for the overall process is provided on a step by step bases.

HITB Reset Tool Installation

1- Download the appropriate HITB build associated for your Dynamics GP version on the customer source reference : Customer Source Download - Historical Inventory Trial Balance Inventory Reset Tool for Microsoft Dynamics GP

2- The download will have two main files which are;

• IVReset.cnk | This is to be copied to your Dynamics GP Folder (Program Files > Microsoft Dynamics > GP )
• HITBIVResetProcedures.sql | This script will create all the stored procedures required for the IV Reset Process. Further details related to these procedures can be found here.

First copy the .cnk file into your Dynamics GP folder, then run Microsoft Dynamics GP (Right Click > Run as Admin) and click yes to include the new code.

Helping Note  “Sign in to Dynamics GP With (SA) account”. It is better to log all Dynamics GP users out of the systems before starting this process.

Second, run the sql script on your SQL Management Studio using the (SA) account as well.

HITB Reset Tool – Steps

Now that you have completed the installation, you will need to proceed with the IV Reset Process, including several steps as thoroughly provided below;

Prerequisites

Post all pending inventory-related transactions. Then go to (Microsoft Dynamics GP menu > Tools > Utilities > Inventory > HITB IV  Reset Tool)

Step One and Two | Inventory reconciliation and Data Integrity

Before inventory reset, it is important to run inventory reconciliation and Data integrity, in order to ensure that no corrupted data are considered through the reset.

Helping Note !

Along with the download of HITB, there is an FAQ document including essential information

For further explanations, refer to the FQ document for specific details:

• HITB_SkipReconciles=TRUE
• HITB_SkipErrorChecking=TRUE
• HITB_SkipClearingTransactions=TRUE
• HITB_SkipVersionChecks=TRUE
• HITB_DebugFile=c:\somefile.txt

 

Step Thee|  Populate Tables

At the end of this step, you will get a report on the variances to be considered throughout the inventory reset process. This is a very important part before you proceed.

This is called the “Inventory Staging Report”

Step Four and Five |  Create General Ledger Clearing Transactions and HITB records

Include an offset account in the following two steps, to be considered in the reset process.

At the end of the steps above, you will have a corresponding HITB (SEE30303) but not yet recorded in SEE30303, rather in a staging table

In addition, clearing GL transactions are already calculated and ready to be saved within Dynamics GP

Steps 6,7 and 8 | Finalizing

Best Regards,
Mahmoud M. AlSaadi