Finance | Project Operations, Human Resources, ...

Settlement voucher with status non being posted in AP

(0) Share

Report

Posted on by Kumar_Sat

1,282

I have created an AP invoice. While paying the invoice, I am getting 3 different vouchers - one for the invoice, one for the payment and one for the vendor settlement. I really did not understand the requirement for the vendor settlement transactions. No automatic settlement is marked either in AP parameters or in posting profile. I am using single posting profile. I tested the same thing in USMF and it creates just 2 vouchers - one for invoice and one for the payment. I am not sure why my environment is creating 3 vouchers and what is this settlement transaction for?

I think it is a setup issue but not able to figure out, please help.

USMF data (plain and simple):

My environment one invoice posting and payment:

Details of the extra lines generated

I have the same question (0)

All responses (15)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you please add the posting type to all of your screenprints - not only to the last one - where the different vouchers are illustrated?

Without the posting type it is not possible to assess why a posting has been made.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 304,072 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Kumar,

When there is an exchange difference or a difference in financial dimensions between the invoice and the payment, the settlement will generate an additional voucher. As there are full amounts debit and credit for the settlement, I do assume it is because of the financial dimensions. You can check this by looking at the dimension on the customer transaction for the invoice and the payment.

Was this reply helpful? Yes No
Kumar_Sat 1,282 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre, I think your assumptions are right. I have my invoice posted with a misc account 99999-999 and and being offset by the same account as I did not want to hit the balance in GL. Payment is made from a cash account which has a department of 100 while the offsetting AP account continues to be 999999-999.

I have 2 follow up questions if you could clarify for the community as I believe sooner of later people will refer this post - 1. Why 2 additional vouchers for settlement even if the department is different and 2. Can we stop it somehow? Thanks in advance for your help.

Was this reply helpful? Yes No
Kumar_Sat 1,282 on at

Like (0)

Report
Copy link

Link copied!

Actually, I would like to correct myself and state that even if I keep the same financial dimension in the invoice, payment, it still produces extra settlement lines so I guess the above cannot be the reason. I will present some screenshot for the clarification: 1 is the invoice, 2 is the payment and 3 and 4 are the settlement transactions

Lets look at the invoice posting (knowingly I posted to the same department)

Payment voucher posting:

Despite this, I get 2 additional vouchers as depicted above. Surprisingly they are the same account in both and the same amount too (no currency exchange, no discount, etc). Have a look at the settlement voucher (both have the same voucher and same amount, same account)

Hence, I would disagree with the assumption that because of dimensions or exchange rate, it is creating extra lines.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Kumar,

Can you please include the posting and transaction type fields in your screenprints.

We don't know your chart of account and the ledger accounts that you use; what is important to understand what has been posted are those 'type' fields.

Also, let us know the exact D365FO version.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Kumar_Sat 1,282 on at

Like (0)

Report
Copy link

Link copied!

I do not think your question is relevant.

Was this reply helpful? Yes No
Satish Panwar 14,671 Moderator on at

Like (0)

Report
Copy link

Link copied!

Posting type help provide details on how transactions gets posted, so of you provide that would be very helpful.

Was this reply helpful? Yes No
Kumar_Sat 1,282 on at

Like (0)

Report
Copy link

Link copied!

I thought I had included this, nevertheless, it is here.

In total, the payment is creating these 4 lines:

The only difference I noticed in USMF (where it is not creating 4 lines) and my company is this field under settlement tab on the payment is marked yes in USMF and not marked in my company

Was this reply helpful? Yes No
Kumar_Sat 1,282 on at

Like (0)

Report
Copy link

Link copied!

In total, the payment is creating these 4 lines:

The only difference I noticed in USMF (where it is not creating 4 lines) and my company is this field under settlement tab on the payment is marked yes in USMF and not marked in my company

My simple question is - what is prompting these vendor settlement vouchers and why I have 2 more useless vouchers same number, same amount, same account , same type?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you check and compare the following setups in your system and USMF:

a) Vendor posting profile: Whether the 'automatic settlement' parameter is turned on?

b) What terms of payment has been used in your environment compared to the one that you used in your tests in USMF

Can you also let us know whether an open payment transaction was selected for settlement in the purchase order?

Many thanks,

Ludwig

Was this reply helpful? Yes No