Finance | Project Operations, Human Resources, ...

Vendor Balance Report and Trial Balance are not matching : Accounts Payable in Dynamics 365

(0) Share

Report

Posted on by Community Member

Hi,

My vendor balance List and Trial Balance are not showing the same closing Balance. Not sure if I am setting the correct filter in Vendor Balance List. or Trial Balance.

In below screenshot : I applied filters

8228.pastedimage1573795793729v2.png

Below screenshot is the Vendor Balance List Result

6403.pastedimage1573796259847v4.png

For Trial Balance

4201.pastedimage1573796024128v3.png

I have the same question (0)

All responses (7)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Moved this to the D365F forum as you ended up in the old 'AX' forum

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Can you run the AP - GL reconciliation report that is available in the report section in AP?

When doing that select 'differences only' and 'details'.

Is October 2019 already closed or do people still post transaction into previous periods?

What is your accounting period? Is it Jan-December or something else?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Zain Mehmood 4,187 Most Valuable Professional on at

Like (0)

Report

Hi Anubar Gaur,

Is the check box for not allowed manual posting for account 2211001 enabled or not. If not then you have to check whether there are any manual adjustments made to this account. Other then that also check if the vendor groups are changed for a specific vendor during the financial period for which you are checking.

Please mark YES against the answer that helps you. Thanks.

Warm Regards,

Zain

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

look for subledger journal entries not yet transferred to GL, process all and then run an update of account balance

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

I am running from Jan to Oct and Jan to Nov both. Trying multiple combinations .

Yearly when I ran its working fine now . But now when I check Oct month Trial Balance and Oct Month Vendor Balance List , its not matching.

Regards

Anubha

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

how many posting profile you have?

Any prepayments?

Run report in AP - Vendor to ledger reconciliation

Was this reply helpful? Yes No
CU16050318-0 26 on at

Like (0)

Report

Hi,

How did you resolve this issue?

could you help me I am facing same issue.

Was this reply helpful? Yes No