Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Rosemary 2

Hi,

I would like to print a Historical IV Trial Balance as @ September 2016, should I input the range of item numbers as well as a specific date?

If a date is needed am I using the September date.

This is the first time I am looking at this report to reconcile to the GL, currently the Inventory Department would pull reports from the Smartlist and Reconcile to GL, but this can be time consuming. Before I make any recommendations I would like to better understand how it works and what could be the inconsistencies. I have read the other posts, just looking for more information.

Regards,

Rosemary

*This post is locked for comments

  • MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: Historical IV Trial Balance

    If going by site doesn't help, you may want to go backwards in time to find out when (if ever) it was in balance.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Historical IV Trial Balance

    Hi,

    Well the TB did not balance with the GL, it did not even pick up the same values as that done on September 30th.

    I decided to go per location, it may be easier to see where the errors are.

    Regards

    Rosemary

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Historical IV Trial Balance

    Thanks Matt for your response, will give it a try.

    Regards,

    Rosemary

  • MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: Historical IV Trial Balance

    If you want to do it as of September 30, 2016 then you'll want to enter in that as a date filter.  You don't need to put in item numbers unless you are trying to run it for a certain range of items.

    So if you are just trying to do a quick comparison of the HITB to GL I'd run it as Summary and a date of 09/30/2016.  That should be the only filter you'd need to tie it out to the GL.  If you find a discrepancy then you may need to move to a detailed version of the report to do some analysis.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans