Announcements
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.
Thanks
Harsha
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.
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
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
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
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
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
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
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
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.
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
André Arnaud de Cal...
293,302
Super User 2025 Season 1
Martin Dráb
232,114
Most Valuable Professional
nmaenpaa
101,156
Moderator