Before Running HITB Reset Tools in Dynamics GP
In Dynamics GP, when running your HITB (Historical Inventory Trial Balance) report, do you find it isn’t populating the data correctly even after running the HITB Reset process? Whenever customers face issues with their HITB report populating incorrect data, Microsoft recommends running the HITB Reset process, details on this can be found in a previous Encore blog here.
We have found that many times, even though the HITB reset tool is run, the data is still incorrect for the HITB report. Below we will talk about the steps you need to perform before running the HITB reset process.
Please perform these steps in test company first before running them in production. Currently, our standard recommendation would be to run the following SQL scripting against the erring company database prior to running the HITB reset process to ensure it is working with vacant table content only:
DELETE SEE99997
DELETE SEE99998
DELETE SEE99999
DELETE SEE30303
DELETE SY01401 WHERE coDefaultType = 5597
(The SY01401 table associates Dynamics GP processes with a User ID by default so clearing this table out for the ‘5597’ HITB reset process will ensure the user performing the new activity will be the recommended ‘sa’ user)
For more details on this process in Dynamics GP, please contact the Encore team.
Webinar - Dynamics GP Coffee Break | Maintenance of SOP Tables
Find out what happens in SOP to cause orphan records, and why we care. Learn about removing these transactions and how that affects inventory allocations.
December 12
9:00 am – 9:25 am PST