Payment Proposal not picking up Debit Notes or Payment on Account

(1) Share

Report

Posted on by CS-07100318-0

Hi All,

I am experienced in configuration and use of AX 2012 but quite new to D365 FO.

We are upgrading our companies gradually from AX 2012 to D365 FO. We have come across an issue where vendor debit notes and vendor payments on account are not picked up by the payment proposal wizard where they were in AX2012. As an example we post an AP invoice for 10,000 and then receive and post a debit note from the vendor for 1,000 due to defective product or service. When using the vendor payment proposal, it only picks up the 10,000 invoice for payment, it does not pick up the debit note and therefore proposes a payment for 10,000 for the invoice rather than automatically including the debit note.

Is this a setting or parameter somewhere that I am missing, or is this a change in the fundamental way that AP payment proposals work in D365 FO?

Thanks,

Craig.

All responses (11)

Answers (4)

VaHiX 3,119 on at

Like (2)

Report

Payment Proposal not picking up Debit Notes or Payment on Account

** Please don't forget to close up the thread here by Like and verify it as an answer if it is helpful **
Suggested answer

Bill Ngo 370 on at

Like (1)

Report

Payment Proposal not picking up Debit Notes or Payment on Account

Hi CS,

Cc Ramit,

As Ramit's suggestion is corrected, if your issue will be resolved. Then you need to double check your configuration on current default Journals. Make sure all debit notes and prepayment journals are setting up with "approved" status.

If you do not know how to check/configure please let me know.
Verified answer

Ramit Paul 22,300 Most Valuable Professional on at

Like (2)

Report

Payment Proposal not picking up Debit Notes or Payment on Account

Hi,

Please check if these transactions are "approved" to Yes, if not, please edit and make it "Approved" to YES,. see below, without this those wont come up in payment proposal.
Bill Ngo 370 on at

Like (1)

Report

Payment Proposal not picking up Debit Notes or Payment on Account

Hi CS,

I would like to verify some more information:

- How you migrated your DB from 2012 to D365Fo? Auto upgraded by MS tool or create a new DB in D365FO and import DB by DMF?

- Your current vendor is not activated for Intercompany, right?

- In the All vendors form, when open Settle transactions form, have you seen these transactions for your vendor debit notes and vendor payments or not?

Last one is very importtant: Please describle where and how you create your vendor debit notes and vendor payments?

through:

- Vendor payment journal?

- PO return/PO with nagative Qty?

- General journal?

- and so on.

The more detail the more value.

Rgds,

Bill
Verified answer

CS-07100318-0 34 on at

Like (2)

Report

Payment Proposal not picking up Debit Notes or Payment on Account

We have determined the issue. In AX2012 the parameter below just limited the maximum value of an individual invoice being included in the payment proposal. In D365, if the value of this parameter is not zero, then the code below is called which deletes any debit note transactions from the payment proposal lines (debit notes have an amount >0 while invoices have amounts <0).

This explains why the parameters screen shot that Frank replied with worked for him, because this value was zero, whereas in my one it was set to a large amount in the same manner we did in AX2012.

Thanks all for your help.

Craig.
CS-07100318-0 34 on at

Like (1)

Report

Payment Proposal not picking up Debit Notes or Payment on Account

Thanks Frank. When we run we have that flag turned off but it still doesn't include the AP Debit notes into the proposal. Just to confirm, in your experience with the AP Payment Proposal it does include debit notes without issue? Are there any other settings anywhere you can think of that could be causing this?

I am not aware of any customizations in place that would affect this, but my next step is to look at that if this is working ok for everyone else.

Thanks.
Verified answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (2)

Report

Payment Proposal not picking up Debit Notes or Payment on Account

Here's the parameter in Payment proposal. The wording is a little misleading, but "Negative payment" can mean a credit note, pre-payment, etc. If this flag is off, those transactions will be included in the proposal.
CS-07100318-0 34 on at

Like (1)

Report

Payment Proposal not picking up Debit Notes or Payment on Account

Thanks for your responses. Unfortunately in our business process we don't want the debit note to be settled prior to the payment proposal. We need the debit note to be selected in the payment proposal at time of payment so that it correctly shows on the remittance advice that we are paying selected invoices and deducting the amount of the debit note from the payment.

Regarding the payment proposal parameters, I have posted the screen shot below of the parameters available to us in Dynamics 365 Finance and Operations, and I can't see the parameter on whether to include debit notes or not. We have even selected NO to the option to delete negative payments, but that doesn't help either. This parameter screen is the same for all legal entities we have migrated to D365 so far.
Suggested answer

Bharath jain 799 on at

Like (2)

Report

Payment Proposal not picking up Debit Notes or Payment on Account

Hi Craig,

There is an option for settlement. When you post a debit note, you can settle it against the original invoice, which will reduce the balance of the original invoice.

If the settlement is not posted, you will have a parameter in the payment proposal form to include the debit note.

Regards,

Bharath Jain
Verified answer

BillurSamdancioglu 15,786 Most Valuable Professional on at

Like (1)

Report

Payment Proposal not picking up Debit Notes or Payment on Account

Hi,

Yes on the payment proposal, form, you can find the parameter.