Finance | Project Operations, Human Resources, ...

Differences between Vendor ledger balance (in GL vendor reconciliation) and Trial Balance

(0) Share

Report

Posted on by Karan Nair

Hi Experts,

Please let me know how to rectify differences found in vendor balance and ledger balance in Vendor reconciliation report. which tables to check on backend to identify where the difference is arising from? please provide a solution from a techinal viewpoint.

My AX version is AX 2012 R2 CU6

Regards,

Karan

All responses (6)

Answers (0)

Karan Nair 30 on at

Like (0)

Report

RE: Differences between Vendor ledger balance (in GL vendor reconciliation) and Trial Balance

Hi Ludwig,

This is the 1st scenario i was referring to in my previous reply

This is the 2nd scenario

Main Account is 2111 for both the scenario
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Differences between Vendor ledger balance (in GL vendor reconciliation) and Trial Balance

Hello Karan,

Can you share one of those examples by making a screenprint of the voucher and the transaction origin that you see?

Many thanks,

Ludwig
Karan Nair 30 on at

Like (0)

Report

RE: Differences between Vendor ledger balance (in GL vendor reconciliation) and Trial Balance

Hi Ludwig,

I tried with two scenarios wherein

in first scenario i checked for the transaction origin of the voucher which was having 0 value in the ledger balance field of the report

in that there was no line of main account record in that

in the second scenario i checked for the transaction origin of the voucher which was having 0 value in the vendor balance field of the report

in that there was a line for main account record

Also there is a third scenario where the values in both ledger balance field and vendor balance field are not null

but both are different values and hence there is a difference in the end

As i am not much familiar with the accounts part please guide me on this

Regards,

Karan
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Differences between Vendor ledger balance (in GL vendor reconciliation) and Trial Balance

Hello Karan,

If you see the vouchers included in the report then open then and try to navigate to the transaction origin to see what happened.

Check especially the main accounts used in the voucher.

Best regards,

Ludwig
Karan Nair 30 on at

Like (0)

Report

RE: Differences between Vendor ledger balance (in GL vendor reconciliation) and Trial Balance

Hi Ludwig,

Thank you for the prompt reply

I am running the report with parameters set for From date to To date and also posting profile is set as general and i am selecting both the checkboxes for including details as well as only show the differences.

once i get the vouchers which are getting differences how can i check both the ledger transactions and vendor transactions why those differences are occuring from the back end?

Regards,

Karan
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Differences between Vendor ledger balance (in GL vendor reconciliation) and Trial Balance

Hi Karan,

Can you run the report again and enable the parameter for enabling details that provide you the vouchers that caused the variance?

Many thanks,

Ludwig