Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Difference Between Mod...
Microsoft Dynamics GP (Archived)

Difference Between Module AP And GL

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Good day all;

We've found a difference between the GL report and AP module totals for the open fiscal year.

We've checked the results of the report "Reconcile To GL", and compared the total of the module's records with the Credit/Debit of GL, and found them exactly the same... but still, HATB total and GL-Summary show different totals, by a huge amount.

BTW, in "Reconcile To GL" report, did not show unmatched transactions, but the matched & potentially matched.

 

The difference still exists even after we did revaluation and all transaction were applied.

Any advice?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference Between Module AP And GL

    Dear Leslie;

    We finished comparing Apply transactions between GL & module, and found no difference.

    And since there was no difference between GL Transactions and module transaction, so we hit a dead end!

    Could you please help with specifying the HATB’s tables or script?

    So we can do a manual test for the report (with smaller intervals), and compare the results with GL… in order to confirm Reconcile to GL’s result.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference Between Module AP And GL

    Dear Leslie;

    Thanks for your response...

    We have been checking the results of the view of Victoria Yudin's website for two days (the data is huge)... filtering them and the comparing them with Apply TRx in GL.

    And thank you for pointing out the tables names... will check them also.

    Will get back with an update soon.

    Best Regards;

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Difference Between Module AP And GL

    Hi,

    If I'm understanding correctly, you compared just the invoice amount to the credit amount in the Accounts Payable account(s) and found them all to be correct. You have not checked the credit or payment amounts. Victoria Yudin's website includes a view where you can see which documents were applied to what invoice and then match them to the GL.

    I'm more of a raw data person when I run into issues like this. I would compare the entries in the GL20000 table to the PM20000 and PM30000 tables (I would actually use the view named Payables Transactions or union the two tables). You can also get this information from SmartList using the Payables Transaction folder and adding a few columns. Have compared those?

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference Between Module AP And GL

    Please be informed that we exported all our transactions (based on Suppliers ID) to Excel, and compared them with GL Account (after we removed all Apply Transactions & revaluation from the Excel file) and did not find any differences.

    So we are suspecting that the Apply Transactions are the cause of the difference.

    Is there any method to get/export the Apply Transactions on the AP Module to compare them with the GL-Apply Transactions?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference Between Module AP And GL

    Yes, I mean the report HATB. Report HATB corresponding to the date of 31/12/2015 and there is no difference and when determining the date from 01/01/2016 to 31/12/2016 shows the difference, knowing that when run reconcil gl  for 2016 The result of accounts payables and  Accounts Payable trial balance report is equal and no difference

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Difference Between Module AP And GL

    Hi,

    I see you have HATB problems, but if on the general ledger, the sum of your accounts payables accounts (including discounts available if you have a different account) and the Accounts Payable trial balance report is different, then you need to run the Reconcile to GL routine using a start date of when those two were in balance. If you just run it for the current period, it's not going to help if the outage occurred in an earlier period. The initialization process Frank is talking about is for inventory, not payables. It is a report called HITB which stands for Historical Inventory Trial Balance. The HATB report, which is the one I think you are speaking of, is the Historical Aged Trial Balance for payables, is that correct?

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference Between Module AP And GL

    Dear Leslie;

    Thanks for your response…

    Indeed, GL and PM Trial Balance are out of balance even after the relevant transactions are posted.

    Regards;

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference Between Module AP And GL

    Dear Frank;

    Thanks for your response…

    The version is 10.00.1368

    I will be waiting for your kind reply about the initialization process of HATB.

    Regards;

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Difference Between Module AP And GL

    Hi,

    As of the current date, after all relevant transactions are posted,  is the GL and PM trial balance out of balance?

    Leslie

  • Peter Bailey Profile Picture
    Peter Bailey 80 on at
    RE: Difference Between Module AP And GL

    If it helps, the approach I use to try to home in on the difference e.g. work out on which vendor the difference appeared, then after knowing which vendor it appeared on work out which date the difference appeared. Knowing both the vendor and date, I then tick off individual transactions on that one vendor on that one date between the HATB and the GL to find which transactions are creating the difference.

    Revaluation is something to watch out for - you may be in a situation where the revaluation is hitting your GL account but not your HATB

    Inconsistent apply data is also something to watch out for - i.e. where the original document amount less applies does not equal the document remaining amount. This can cause the HATB to yield unexpected results. Hope that helps.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans