1,858
Hi,
What is the difference between these 2 reports:
Accounts Payable > Reports > Transactions > Vendor > Account Statement
Accounts Payable > Reports > Status > Vendor Balance List
I'm getting a difference in amount for same vendor for same time period (2017).
SUM(AMOUNT) is sum of only transacitons, it doesn't include opening and closing balances.
*This post is locked for comments
@Ludwig,
I ran the Vendor Balance List and got the same amount (308850169.84).
The Vendor Account Statement is taking too much time to run. Before it completes I have close it and do some other work.
I'll keep this thread posted when I arrive at a resolution.
@Katy
I have replied in the other thread related to ExchangeRate.
Dear MYGz,
the reason might be a different currency code and one report shows transaction currency but the other the accounting currency and sums it up. Or it shows both but sums up the values with different currencies, I remember something like this. I wrote the same in the other discussion, let me know if that’s the problem.
Kind regards
Katy
Hi MYGz,
The last screenprint is great because it shows no difference between AP and GL.
If you can find the same amount (308850169.84) in the vendor balance list and the vendor account statement form if you run those reports for the same period then everything is fine.
Can you also run the vendor balance list and vendor account statement report again for 01/01/2017-12/31/2017?
Best regards,
Ludwig
Hi Ludwig,
Actually I'm more towards technical side and less towards functional. This is integration data from CRM system that I'm posting in 2 journals eg. 'CAP' and 'CAPR' and both journals are of type daily.
I actually ran the report for a smaller company in the earlier reply. Below is for the same company that I ran the 2 reports earlier in the original post.
Hi MYGz,
There seem to be some inconsistencies in your data.
I noticed that you run the vendor/ledger reconciliation report for the whole year 2017.
If you run the vendor account statement and the vendor balance list reports for the same time period, do you see the same balance that you see in the vendor column in the reconciliation report?
Can you explain why you have so many transactions recorded in GL but not at the vendor level as shown in the reconcilation report?
Best regards,
Ludwig
Hi Ludwig,
Thanks for your reply.
We are posting the vendor transactions from General Journal in a Daily journal Type. All the journal batches are created and posted in 1 company (eg. 'COM1') irrespective of the vendor company. The transactions for Vendor of other companies are auto created with the Intercompany setup.
Here's the GL reconciliation report for 1 company:
Hi,
Both reports should ideally show the same amount.
Can you check the GL reconciliation reports and whether they show a difference between the GL module and AP?
If you calculate the difference between both sums, can you identify this difference amount in one of the reports e.g. for a specific vendor?
Can you also check since when you have this difference e.g. by running the report for a previous year/period?
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (