AX 2012 payment proposal value Total not summing all invoices

(0) Share

Report

Posted on by oysteindg

I have a vendor with several invoices, and some old (from 2014) credit notes. When I try to combine the invoices to create ONE payment line, AX splits all the credit notes from 2014 on one line, and the invoices/credit notes from 2015 on one line.

I have checked that the Method of Payment is identical for all invoices and credit notes, and that the period is set to Total. I have also tried to adjust the payment proposal values.

Any suggestions?

EDIT: It seems like all the credit notes generates as one separate line, and all the regular invoioces as another separate line. Anyone experienced this scenario before?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Pratik Bhosle 414 on at

Like (0)

Report

RE: AX 2012 payment proposal value Total not summing all invoices

how about when you transfer to next level, that should give you as one payment or total of both. Did you try transferring payment proposal to payment transfer.

Was this reply helpful? Yes No
oysteindg on at

Like (0)

Report

RE: AX 2012 payment proposal value Total not summing all invoices

Wouldn't the payment proposal lines transfer separately, since I am only allowed to transfer one line at a time from the payment proposal window?

I don't think there is any way of combining the lines after transferring to journal voucher?

Was this reply helpful? Yes No
oysteindg on at

Like (0)

Report

RE: AX 2012 payment proposal value Total not summing all invoices

Anyone experienced this before?

The Payment proposal makes one payment line for credit values, and another payment line for debit values. I want the lines to be combined.

Was this reply helpful? Yes No
Amanda1hernandez 5 on at

Like (0)

Report

RE: AX 2012 payment proposal value Total not summing all invoices

Are the remit to addresses for the credits and debits the same? if they have different remit to's, they will form two separate payment lines.

Was this reply helpful? Yes No
Suggested answer

Pratik Bhosle 414 on at

Like (0)

Report

RE: AX 2012 payment proposal value Total not summing all invoices

Can you please make sure that Method of payment is set to Total

Accounts Payable > Set Up > Payment > Method of Payment > Total that combines all invoices from vendors for the same payment, but I guess it combines invoices and may possible it combines credit note separately. In this scenario all you can do is manual add up when you transfer bacs for the payment. Hope this will solve your purpose.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: AX 2012 payment proposal value Total not summing all invoices

Another thing to look for is did you create Vendor Bank for this vendor lately and set it as default in the Vendor master ? This info updates into the invoice transactions details, and will prompt a separate grouping during payment proposal.

Was this reply helpful? Yes No
Kristi Slininger 66 on at

Like (0)

Report

RE: AX 2012 payment proposal value Total not summing all invoices

Oystein,

There are multiple criteria used during the payment proposal process to determine whether invoices/credit memos should be 'summarized' into a single payment (when method of payment is setup as Total). Just a few of those are Remit to address, due date, etc. Plus, it also depends on whether criteria you define when running the payment proposal (are you using Total payment date or Minimum date). It might be using Minimum payment date, which is causing them to be split. Here's a quick definition of how the Minimum date works:

Minimum payment date – Enter the minimum payment date. For example, the From date and To date fields specify a range from September 1 to September 10, and the minimum payment date is September 5. In this case, all invoices that have a due date from September 1 to September 5 have a payment date of September 5. However, all invoices that have a due date from September 5 to September 10 have a payment date that is equal to the due date of each invoice.

If you still have them split, you CAN EDIT the results after you transfer the payments to the payment journal. Let's say that three payments were created (which means three lines in the payment journal) and you only wanted one. To change the payment, delete the two payments you don't want (probably the credit memo 'payments'). Go to the remaining payment which you want to include the credit memos in. Open the Settlement form and the credit memos will be available to mark for settlement, which will now include them in THIS payment. When you close settlement, AX will tell you that the settlement amount is different than the payment amount and asks if you want to change it. Say yes, which will update the payment amount to be net the credit memo amounts.

Hope this helps.

Kristi

Was this reply helpful? Yes No