You’re offline. This is a read only version of the page.
Announcements
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
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.
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;
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
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?
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
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
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.
#1
André Arnaud de Cal...
293,531
Super User 2025 Season 1
#2
Martin Dráb
232,597
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
