Difference in Vendor open transactions balance VS Ledger Balance

(0) Share

Report

Posted on by Satyavj

Hi All,

we are facing below issue

Difference in Vendor open transactions balance VS GL Balance in Ax 2009

we have a one vendor we paid advance and after receiving the invoice both are settled, it showing Difference in Vendor open transactions balance VS ledger Balance(COA)

there is no open transactions in vendor account.

Pls help me the above query.

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello Satyavj,

Is there any chance that transactions are posted manually in the vendor controlling account without posting it in subledger vendor account?

This may lead to such value mismatch between main account and subledger account.

You can do the following.

--- Generate the account statement for the main account of that vendor.

--- Verify each and every posted transactions in that statement and find out which transaction is posted with subledger vendor and which one is posted directly in that main account.

--- Once this is figured out; you may have to pass adjustment entry to correct the balance. OR, you may have to reverse those transactions posted directly in that main account and then post the corrective transactions with vendor account to match the balance.

Kindly check and let us know.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

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

Like (0)

Report

Hello Satyavj,

Can you share some details on how you recorded and paid the advance and how you identified the difference?

Some screenprints would help here.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Satyavj 10 on at

Like (0)

Report

Hi Sourav,

Thanks for your reply,

--- Generate the account statement for the main account of that vendor.

--- Verify each and every posted transactions in that statement and find out which transaction is posted with subledger vendor and which one is posted directly in that main account.

Verified all transactions there is direct entry in main account(main account is locked for posting)

Was this reply helpful? Yes No
Satyavj 10 on at

Like (0)

Report

Verified all transactions there is no direct entry in main account(main account is locked for posting)

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Satyavj,

How did you record the advance payment?

Best regards,

Ludwig

Was this reply helpful? Yes No
Satyavj 10 on at

Like (0)

Report

Hi Ludwig,

We recorded through payment journal (AP).

Vendor Debit ---xxx(we select vendor advance posting profile)

Bank ---xxx.

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

Like (0)

Report

Hello Satyavj,

So, your process of prepayments and applying them works as described on this site:

dynamicsax-fico.com/.../

Is that right?

Have you run the reconciliation reports in GL and identified the voucher that is responsible for the difference in AP and GL that you see? Can you share a screenprint of this report?

Best regards,

Ludwig

Was this reply helpful? Yes No
Satyavj 10 on at

Like (0)

Report

Hi Ludwig,

please find the report result,

it is showing settlement voucher.

Thanks,

Satya

Was this reply helpful? Yes No
Vamsi Pranith 682 on at

Like (0)

Report

Are you using different posting profiles and different settlement accounts? If that is the case, it may cause some of these issues. I would suggest start looking from there.

Was this reply helpful? Yes No
Satyavj 10 on at

Like (1)

Report

Hi Vamsi,

Yes we are sing different posting profiles and different settlement acconts.

Regards,

Satya.

Was this reply helpful? Yes No