web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Historical Inventory T...
Microsoft Dynamics GP (Archived)

Historical Inventory Trial Balance vs. Historical Stock Status Report

(0) ShareShare
ReportReport
Posted on by Charlotte Ballard 350

I recently read that Dynamics GP 10.0 SP2 includes a new report called the Historical Inventory Trial Balance. 

Does anyone know the details behind this report?  Does it have quantities as well as values for inventory?

Does it replace the Historical Stock Status report?

We are currently begining to use the historical stock status report for a "point in time" value of inventory and aren't sure if the HITB will work like this or not.  As everyone knows, it is difficult to begin shipping and posting invoices in a new month while trying to obtain the past month's value and quantities of inventory. 

 Thanks for any insight.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Dear Charlotte,

    No, there is a big difference ... the HITB is a report for reconcile IV to GL and it’s columns are: (Journal Entry - Date – Document Number – Source - Variance Qty –  Quantity -Unit Cost – Value).

    BR,

    Ahmed

  • winthropdc Profile Picture
    winthropdc Microsoft Employee on at

    Hi Charlotte

    Here are links to some documentation on the Historical Inventory Trial Balance (HITB) Report.

    Understand the Historical Inventory Trial Balance Report for Microsoft Dynamics GP
    https://mbs.microsoft.com/partnersource/newsevents/events/webseminars/mdgpunderstandinvttrialbalrpt.htm?printpage=false

    Historical Inventory Trial Balance Inventory Reset Tool for Microsoft Dynamics GP 10.0
    https://mbs.microsoft.com/partnersource/downloads/releases/mdgp10_hitb.htm?printpage=false

    Changes made in the ability to edit inventory account numbers in the Purchase Order Processing module beginning in Microsoft Dynamics GP 9.0 Service Pack 3 and Microsoft Dynamics GP 10.0 Service Pack 2
    https://mbs.microsoft.com/partnersource/support/selfsupport/hottopics/changesmadeabilitytoeditinventoryaccountsinpop.htm?printpage=false

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

  • Susan Moore Profile Picture
    Susan Moore 110 on at

    I know quite a bit about the pitfalls of initializing HITB. Contact me directly and I'd be happy to share a document I wrote specifically for our Horizons Manufacturing customers, but the information is pretty relevant for all.

  • Bron Profile Picture
    Bron 4 on at

    Susan - I would like to review your document if you are willing to share.

    My email address is:

    bron.tamulis@tectura.com

    I've been contemplating whether to push some of my clients into deploying HITB.......

    Thank you, in advance.......

     Bron

  • Community Member Profile Picture
    Community Member on at

    Hi Susan, I'd also be interested in your document if you're willing to share. I'm not too up to date on HITB, but want to investigate.

    My email is is@genesys.ie

    Best regards,

  • Jocelyn Eure Profile Picture
    Jocelyn Eure 465 on at

    Hello!  I am having trouble with the wizard on this report.  I want to test it out in Fabrikam first before I use it at my other clients.  I am getting errors on the IV HITB Reset Tool Validation Report that read "Open layer exists in purchase receipts table where valuation method not stamped" and "Serial/Lot tracked item's receipt layer adjusted unit cost does not equal unit cost."  Can you please tell me how I can fix this so I can actually see the HITB report?

     Thanks,

    Jocelyn Eure 

  • djr03 Profile Picture
    djr03 45 on at

    Jocelyn,

    I received the same errors.  Were you able to find a way to get these corrected during the initialization?

     

    Thanks!

  • Jocelyn Eure Profile Picture
    Jocelyn Eure 465 on at

    No, no one has responded to my post and I cannot find any documentation on how to fix it.  Please let me know if you have any luck.

    Thanks, Jocelyn

  • Suzanne McLaughlin Profile Picture
    Suzanne McLaughlin 5 on at

    Hi - There is an heierarchy to the errors.  The serial number error can be corrected by setting the ADJUNITCOST equal to the UNITCOST in IV10200 - I just made the change in SQL.  The second set of errors resolved themselves after I fixed that cost problem and I was able to proceed with the HITB reset process. 

    Good luck with this.  It loos like super functionality for people trying to reconcile book to perpetual in inventory. 

  • Community Member Profile Picture
    Community Member on at

    Hi Susan

     I really need your help. We are having tough time in balancing Stock value and GL balance for stock. Everytime we post the purchase transaction using ship & invoice (including landed cost), we see that there is a difference between GL & SL balance. we tried implementing Service pack 3 and when ever we run the HITB tool it balances. But subsequently the next transaction the difference appears. Is it that i need to run the tool evertime  i want to balance. Sounds ridicolous. Is there anyway of straight forward approach which will balance the value between Stock and GL.

    Please reply me at grvenkat99@hotmail.com

    Thanks

     Venkat

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans