How to handle credit notes in the vendor payment proposal

(0) Share

Report

Posted on by Fjorela

339

Hi All,

in the vendor method of payment, there is following parameter "Period" for grouping payment lines. In my case it is set to "Invoice" and it is fine.

Question: is there a way that only in case there is a credit note and an invoice, that only in that case the system sums up these positions and shows only 1 vendor payment line with the difference between invoice and credit note?

If not, how do you normally handle these cases?

Many thanks for your help,

Fjorela

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Frank Hamelly | MVP... 46,623 Super User 2025 Season 2 on at

Like (1)

Report

You could try settling the credit note against the invoice manually, prior to running the payment proposal. That should pull the net invoice balance into the payment proposal.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (1)

Report

Hi Fjorela,

If the period is Invoice, it will not sum up even not in case of an open credit note. Like Frank mentioned, there is a workaround by settling before creating the proposal. Another option is searching for credit notes after creating the proposal and adjust the journal lines.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Fjorela,

An alternative might be switching the method of payment to one that has the total period type selected.

Not sure if this is an option to make the switch e.g. in the payment proposal form where you edit the invoices and credit notes to be paid.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (1)

Report

If period = Invoice it will not because system assumes that you would like to create one payment line for each invoice for same vendor e.g. if you have 5 invoices you will have 5 payment lines.

If you want to settle invoice and credit note automatically with out manual settlement then use period = total

Was this reply helpful? Yes No
Somasundara Reddy K 32 on at

Like (0)

Report

Hello Saurabh,

Even if I set up the period = total, still I'm getting two summary lines in the payment proposal, i.e one for invoice lines summary and one separate line for credit notes. Can you please throw some more light how to get the payment summary in single line for both invoice and credit notes together. we are currently in 10.0.30, is there any settings or features to be enabled? Thanks.

Was this reply helpful? Yes No
JamesT 341 on at

Like (0)

Report
Hi KS,

You might be getting two lines due to some different factors:

Items like Method of Payment are different on the invoice and credit note (there is some standard MS code that checks that about 2-3 fields are the same...I cannot remember all the fields)

Has to do how you are running the Payment proposal, Due Date on the invoice/credit note and the Minimum payment date field setting.

You have some development in there (mods) that is causing it.

Regards

Was this reply helpful? Yes No
Somasundara Reddy K 32 on at

Like (0)

Report

Hello James,

Thanks for your response. in fact, the payment specification field was updated for credit note, while its not for invoices, then I have updated the payment specification for invoices as well, then the issue got sorted out. Thank you!

Was this reply helpful? Yes No