Microsoft Dynamics AX (Archived)

Difference Between Reports Vendor Balance List and Vendor Account Statement

(0) Share

Report

Posted on by MYGz

2,170

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
MYGz 2,170 on at

Like (0)

Report

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:

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
MYGz 2,170 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Katy3992 322 on at

Like (1)

Report

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

Was this reply helpful? Yes No
MYGz 2,170 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No