Our service provider, which customized GP for our company, told us that there is a logical error on Historical Stock Status report and we should not use it because the report will not be accurate.
Is it true that Historical Stock Status report is useless because of the logical issue on the product itself?
*This post is locked for comments
Thank you, this has helped.
Hello Rosemary
Apparently, you need to run the IV Reset tool in order to build the HITB table and report, which is a must for reconciling inventory to GL
here is a reference HITB Essentials Series – HITB Reset Tool Deployment
I am not sure what to check for???
We upgraded from GP 10 to GP 2013.
Have you upgraded from previous old versions to GP 2013 ? If so, you need to run the inventory reset tool in order to build the HITB.
Your feedback is highly appreciated,
Hi Rose,
the HITB might not be included in the dynamics.set file please check the same.
Hi, why would I not be able to see the above report, Historical Inventory Trial Balance?
We are using GP 2013.
I would not say that, it depends on the purpose for which you are running this report. In case you were looking for reconciling your inventory to the general ledger module, then the Historical Inventory Trial Balance is the report that you should consider, Historical Stock Status would hardly tie to your GL especially if your inventory valuation method is average costing. The reason for that is simply that this report is precisely designed to report "History", if a specific receipt got updated with a cost adjustment, the cost will not be changed in this report, to maintain the historical cost.
On the other hand, if your target is to report quantity, it should do just fine and should be free of errors.
I personally give training to our clients to use the HITB (Historical Inventory Trial Balance) report. I may hardly consider the historical stock status report since the HITB was introduced. It is the perfect report to consider regardless of the reporting purpose, whether it is for stock quality or cost, reconciliation with the GL, historical or as of today ...etc
Please never hesitate to share any further inquiries,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156