Skip to main content

Notifications

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 IV trial Ba...
Microsoft Dynamics GP (Archived)

Historical IV trial Balance.

(0) ShareShare
ReportReport
Posted on by Community Member

I have a Customer who wants to reconcile their inventory accounts to the inventory sub ledger. It looks like the Historical IV trail Balance would be great as it sorts by Inventory accounts but when I run it in my Fabrikam I see a few issues. By the way this is GP2010.

 

First it does not give me a place to put in a date range or cut-off for the report. If it is historical it should have a date. Secondly it only shows me a limited number of transactions on the report. The value on the report is only 78K when a historical stock status report shows 375K. Am I missing something? It seems to me that it is only showing things I entered after the Test Database was installed.

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    Re: Historical IV trial Balance.

    Have you tried using the Reconciler from Software Index or The Closer.

    www.swareindex.com/Reconciler_for_Inventory.asp

    www.microsoftdynamicsaddons.com/.../reconcile-great-plains-with-the-closer-l626.html

    There is much more functionality with these two products. If the problem is important enough then it is worth the cost.

  • Suggested answer
    Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: Historical IV trial Balance.

    I can say that we found no use for the HITB tool.  When we evaluated it with our partner, it just seemed not to provide any insight into where the problem lies if we are out of balance.  We have multiple g/l accounts for inventory and the HITB tool does not track subledger entries to specific g/l accounts, so the tool was not going to show us what exists/does not exist at a subledger item that hit/did not hit the g/l.  We realized that the way we currently find out of balances would be no different with the "tool" and appeared to just add needless work to our process.  The HITB tool was highly taughted, so we were very disappointed in the limited scope of this feature.  I only give my opinion on this to ensure your customer does a complete evaluation of what this tool does compared to a proper tool so they can evaluate the true costs of each option.  Good luck.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: Historical IV trial Balance.

    Great, just read about the HITB Reset Tool and that will give you the headstart on it, i know HITB came along but as it is from the system works when you are new to the system no historical, but when you have sometime operating you need to create that point in time where things "match" and then accurately use the report in any future discrepancies :-) Thanks!!!

  • Community Member Profile Picture
    Community Member on at
    Re: Historical IV trial Balance.

    I do not want to reconcile without proper setup, lol. I posted to find out what I needed to do if anything.Since the report is part of the standard package in 2010 I was not aware I need to do anything for it to run but it in looking at the result it was obvious something was missing.

    I was aware and have used the closer but this customer will not pay $4000.00 cost to buy the proper tool. It will of course most likely cost them more but what can you do.

  • Community Member Profile Picture
    Community Member on at
    Re: Historical IV trial Balance.

    First things first, do you know if ever the Reset tool was run and did the journal entry was posted to match IV to GL?

    If after running the reconcile tool, the inventory is not matching then you can use HITB to try figure out where is the error. And HITB does provide date range, otherwise whats the point of Document date vs GL posting date on the report options, go to the ranges drop down and find there the date field which you can use to "filter" your report :-)

    Also if you really want to reconcile without a proper setup of the HITB then I wish you luck, or wish you can get a hold of Mr. Gianmarco out at The Closer, they have a tool that helps you reconcile.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans