Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Inventory Historical Report

Posted on by Microsoft Employee

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

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Inventory Historical Report

    Thank you, this has helped.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Historical Report

    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

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Inventory Historical Report

    I am not sure what to check for???

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Inventory Historical Report

    We upgraded from GP 10 to GP 2013.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Historical Report

    Rosemary

    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,

  • Suggested answer
    RE: Inventory Historical Report

    Hi Rose,

    the HITB might not be included in the dynamics.set file please check the same.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Inventory Historical Report

    Hi, why would I not be able to see the above report, Historical Inventory Trial Balance?

    We are using GP 2013.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Historical Report

    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans