Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How to avoid system from creating Vendor settlement transactions

(0) ShareShare
ReportReport
Posted on by 35

Hi

The customer is on Ax 2012 R2.

Ax is creating vendor settlement entries which are creating problems in reconciling the GL account. Is there a way to turn this off from making any entries in future. I have attached the screenshot. 

pastedimage1605188899909v1.png

Thanks

Harsha 

  • Verified answer
    Harry S Profile Picture
    35 on at
    RE: How to avoid system from creating Vendor settlement transactions

    System will create vendor settlement entries:

    1. if there is a change in financial dimension from Invoice and payment.

    2. If the payment journal is marked as prepayment and settled against invoice.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How to avoid system from creating Vendor settlement transactions

    Hi Harsha,

    Good to hear that you figured things out.

    To get this thread completed can you be so kind and verify the answers?

    Many thanks,

    Ludwig

  • Harry S Profile Picture
    35 on at
    RE: How to avoid system from creating Vendor settlement transactions

    Hi Ludwig

    After couple of tests I noticed that what system is doing is correct with respect to vendor settlement entries. System will create vendor settlement entries:

    1. if there is a change in financial dimension from Invoice and payment.

    2. If the payment journal is marked as prepayment and settled against invoice. 

    Thanks Ludwig, I feel this issue is closed now. 

    Thanks

    Harsha 

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How to avoid system from creating Vendor settlement transactions

    Hello Harsha,

    Many thanks for the update.

    Can you list the steps that you executed when you created the PO and the payment?

    Did you post a payment fist and then apply it when you posted the PO invoice?

    Or... did you make a payment without a direct settlement of the invoice in the payment journal and applied the payment later on?

    Would be great if you could list us the steps executed one by one so that we can understand what has been done and replicate your issue.

    Many thanks,

    Ludwig

  • Harry S Profile Picture
    35 on at
    RE: How to avoid system from creating Vendor settlement transactions

    Hi Ludwig

    POI-0067735 is a PO invoice and there is no prepayment for the PO related. $748.33 is the total PO amount and the same is settled against the payment entry. Since the PO is completely invoiced there are no prepayment entries for the invoice POI-0067735.

    I am not sure why there is a prepayment settlement entry created. The PO Invoice has posting profile that is not enabled for prepayment.

    Thanks

    Harsha

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How to avoid system from creating Vendor settlement transactions

    Hello Harsha,

    In your screenshots I see a first voucher with the number: POI-0067735

    That must be the purchase order invoice. Is that right?

    Then you have the voucher 140023813, which is the prepayment made.

    Finally, I can see voucher APP-0018136, which seems to be the AP payment voucher.

    Can you confirm that?

    Based on that, I don't see a problem with the vouchers created.

    What is wrong in your opinion?

    Best regards,

    Ludwig

  • Harry S Profile Picture
    35 on at
    RE: How to avoid system from creating Vendor settlement transactions

    Hi Ludwig, Junaid

    1. Here is the screenshot of voucher 140023813. Accounts payable Dr and Supplier deposit Cr. The number seq of this entry is linked to AP parameter->payment voucher

    pastedimage1605232720402v1.png

    2. An invoice was made as shown in the screenshots of the previous post and payment was manually settled. When you look at it the debit and credit match but why should this vendor settlement entry create since the currency is USD and invoice is completely settled against payment. 

    Can I avoid this extra entry from happening in the future, this only adds to confusion. 

    Thanks

    Harsha 

  • Junaid Idrees Profile Picture
    on at
    RE: How to avoid system from creating Vendor settlement transactions

    Hello Harry S,

    Did you settle the invoice manually from "Settlement transaction" screen?  Logically system should not create any extra voucher because i can see your invoice and payment currencies both are in USD.

    Can you share the voucher screen print of 140023813 voucher, what is Debit/Credit? Please also check the origin of 140023813 number sequence to get a hint from where exactly it is linked to.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How to avoid system from creating Vendor settlement transactions

    Hello Harry S,

    Can you elaborate what you mean by future?

    All entries are made in the past.

    What would help is if you could provide more details about the transactions that you shared, what has been recorded / processed and what does not work as expected.

    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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,302 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,114 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans