Unwanted vendor settlement transactions

(0) Share

Report

Posted on by Community Member

We are experiencing some strange vendor transactions that I am not able to explain. They are vendor transactions (VendTrans) that have the transaction type of “Settlement”. They seem to debit and credit the same account and net each other out but they are very confusing for our client and I do not know why they are created at all. They seem to appear when you do a vendor payment proposal > Produce a payment and post the payments for several vendors. I tried to isolate this and re-create it for a single vendor but I was unable to do so. If anyone could please give me some insight into 1) What they are for and why they are created? 2) How do we get them to stop being created?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, What AX2012 version do you run? Are you aware of any system modification that has been implemented that triggers those Transactions? Can you show us the voucher of one of those settlements e.g. for voucher no. ...98? Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

We are running AX 2012 CU10. The voucher is below. We have not implemented any customization that would trigger this. I have also seen this in a vanilla environment. Thanks in advance!

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, Did you activate the "balanced financial dimension" parameter in GL for one of your financial dimensions? Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

No, that checkbox is unchecked for all of our financial dimensions. Should this be checked?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, I would not check this Checkbox but was wondering whether this one triggered the issue. Another thing that you could check is whether or not the "automatic settlement" parameter in AP-parameter-settlement is activated as its activation might be responsible for the behavior you see. If you also did not activate this one, probably have a look at LifeCycle services for a possible hotfix. Best regards, Ludwig

Was this reply helpful? Yes No
Suggested answer

binitshah 660 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This has been an issue in all my implementation, however I just managed to explain to the customer that this is just an offsetting transactions for the different dimensions selected on the invoice and the payment.

If you find any hotfix please let me know.

Was this reply helpful? Yes No
Alex Thompson on at

Like (0)

Report
Copy link

Link copied!

Use default financial dimensions on the vendor control account to avoid using a different set of dimensions for the invoice and the payment.

Was this reply helpful? Yes No
Suggested answer

real_ashwin 1,229 on at

Like (0)

Report
Copy link

Link copied!

This is quite normal for ax it happens during settlement if the financial dimension used during booking of invoice was different from the payment.

Just explain it to the customer. No issue here. If you match the financial dimensions then no posting is made during settlement.

Was this reply helpful? Yes No
Suggested answer

M.I.A 20 on at

Like (0)

Report
Copy link

Link copied!

Check this link it will help you understand why those transactions are created

Additional “Settlement” type transactions on Customer and Vendor transactions page in D365 Finance – Why do you see these and how to fix it? | Dynamics 365 F&O and Project Operations Blog (sandeepchaudhuryd365.com)

Regards

Was this reply helpful? Yes No