Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Difference in Vendor open transactions balance VS Ledger Balance

Posted on by 10

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.

  • Satyavj Profile Picture
    Satyavj 10 on at
    RE: Difference in Vendor open transactions balance VS Ledger Balance

    Hi All,

    Pls help me the above query.

  • Satyavj Profile Picture
    Satyavj 10 on at
    RE: Difference in Vendor open transactions balance VS Ledger Balance

    Hi  Vamsi,

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

    Regards,

    Satya.

  • Vamsi Pranith Profile Picture
    Vamsi Pranith 682 on at
    RE: Difference in Vendor open transactions balance VS Ledger Balance

    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.

  • Satyavj Profile Picture
    Satyavj 10 on at
    RE: Difference in Vendor open transactions balance VS Ledger Balance

    Hi Ludwig,

    please find the report result,

    pastedimage1588844029550v2.png

    it is showing settlement voucher.

    Thanks,

    Satya

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Difference in Vendor open transactions balance VS Ledger Balance

    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

  • Satyavj Profile Picture
    Satyavj 10 on at
    RE: Difference in Vendor open transactions balance VS Ledger Balance

    Hi Ludwig,

    We recorded through payment journal (AP).

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

      Bank ---xxx.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Difference in Vendor open transactions balance VS Ledger Balance

    Hello Satyavj,

    How did you record the advance payment?

    Best regards,

    Ludwig

  • Satyavj Profile Picture
    Satyavj 10 on at
    RE: Difference in Vendor open transactions balance VS Ledger Balance

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

  • Satyavj Profile Picture
    Satyavj 10 on at
    RE: Difference in Vendor open transactions balance VS Ledger Balance

    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)

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Difference in Vendor open transactions balance VS Ledger Balance

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans