25
how can i manually reconcile my vendor balance from module to GL. i want to check if balances from module is ties to GL. meaning from where i can check the balances in GP
Hello Braw,
For Inventory, you would want to the HITB report and compare that to the Trial Balance report.
If you have never used this before or have used Inventory before this was introduced into GP, you might need to do a HITB Reset for this report to be accurate.
Below is an article on the HITB and GL TB not reconciling.
docs.microsoft.com/.../hitb-report-and-gl-trial-balance-do-not-reconcile
Here is an article about the HITB Reset tool.
docs.microsoft.com/.../mdgp10_hitb
I apologize i don't have as great of information as i did on the PM/GL Reconcile side.
I hope this helps!
Thank you!
Brandon Jarrett | Microsoft Support Engineer.
dear Mr Brandon.
the things you said was truly helpful and worked for me thank you so much. and i had a final question. i am doing the same for inventory meaning reconciling inventory to GL and i ran the reports and inquiries and there are differences, the question is how to find the differences so that i know what caused them where to look for them? but i don't want to use reconcile to GL tool
thanks.
Hello Braw,
With regards to your response, when you run the PM HATB report and compare it to the GL TB report, are these in balance. If these are in balance you shouldn't have an issue as these are the two reports Microsoft will stand behind when you reconcile them.
As you are looking at the summary windows, if the reports above are correct, you can try to reconcile your Payables and General Ledger to see if it corrects your summary values. I recommend running this in test as we don't have a way to know what the process will do. In general, the Reconcile process will update your Summary Amounts based on your Detail Amounts.
If that does not help, you can possibly use the following to determine what is causing the difference between your PM and GL.
Alternatively, you can use Smartlist to attempt to locate the cause of the issue.
Using Smartlist would be your next best thing. This is because the Smartlist report already has header information and it details out the transactions in PM. Together with the Reconcile to GL report, you can check the distributions that make up the PM transactions then use them both to tie with the GL Detailed Trial Balance.
Another suggestion is within Smartlist, open up the Payables Transactions Smartlist object. Add the column Posted Date. This column stores the date from your computer of when the document was physically entered in payables. Even if the document date was for the previous year, the posted date stores the date of when you physically entered it. You can compare the Posted Date to the Posting Date (holds the Document Date) or the Document Date as well. You can narrow your search by entering this month's Posted Date since you were in balance last month. This will tell you all of the transactions that were entered in Payables since then and you can compare your GL report to that and see if one module is missing the transaction, has a different document date, or a wrong amount as well (possibly the batch was edited in GL before it was posted).
Next, you will want to open the Account Transactions Smartlist object. Add the column Originating Posted Date. This stores the Posted Date (system date) from the originating module. Even if you change the batch date, this stores the date of when it was entered. You can compare the originating posted date to the trx date (document date) in account transactions as well to see if they vary from what your payables transaction report returns. For example, if you were in balance last month, then you can create a report for the payables transactions based on the system date range and then create a report for GL (using the Account Transactions Smartlist object) for the system date range. This way, you can compare when the information was physically entered in the system (even with a different document date between modules). If one of the modules has the transaction posted and the other is missing, you can determine if the transactions were posted with a different date in GL than in Payables.
Lastly, if the above is not helpful and you still see a difference, you will need to hand tick and tie both the PM HATB and GL TB to determine where you are off.
I hope this helps!
Thank you!
Brandon Jarrett | Microsoft Support Engineer.
hello Mr Brandon
I completely understand what you are saying and i have checked all of it when i am using the reconcile to GL tool the balances are correct and equal but when i compare the summary inquiry with the vendor balances there is a difference between the numbers.
thank you
Hello Braw,
When Reconciling your Payables Management to the General Ledger, you will want to use the PM Historical Aged Trial Balance and compare it to your General Ledger Trial Balance.
Below are a few articles you can review for additional information.
Reconciling Payables to General Ledger (microsoft.com)
We also have the Reconcile to GL Tool. Please note, this is just a tool and not a Reconciliation. This tool can help you locate transactions that might have a problem causing the difference between the Sub Module and the GL. This tool only looks at distributions where the PM HATB and GL TB uses complex calculations and uses the Transaction and Apply Record to determine when it should drop off the report.
I hope this helps!
Brandon Jarrett | Microsoft Support Engineer.
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
