Finance | Project Operations, Human Resources, ...

Consolidate vendor payment advice

(1) Share

Report

Posted on by Mario J.

Hello,

where can I control how AX 2012 R3 is generating Vendor payment adivces. My problem is that for every line in the payment journal, AX generates a separate payment advice even if the vendor account is the same. When I am doing it for the customer, I always get a consolidated payment advice, as it should be.

I can consolidate if I n invoices to 1 payment. But the problem is, on the payment advice I would have n invoices and only one payment amount, which does not look very nice. So I asume, there must be another way.

FYI, we are using an external software for document creation, not the standard SSRS documents.

Is this a printing setup or some parameters in the AP module?

Thank you in advance!

BR Mario

I have the same question (0)

All responses (4)

Answers (0)

Sort by

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

Like (0)

Report
Copy link

Link copied!

Hi Mario,

Your question is a bit confusing. Is your question about a report or the journal lines? In case you need to consolidate journal lines for vendor payments, you can manage this with the field Period on the Method of payments. You can group by date, week, or all invoices: Total.

Was this reply helpful? Yes No
Mario J. 94 on at

Like (0)

Report
Copy link

Link copied!

Hello André,

yes you are right, it's quite confusing...

It's more about the payment advice that I want to generate while creating and exporting (via outbound ports) the payment file. As I mentioned before, we are using a third party software to generate payment advices (and other documents) rather than the standard SSRS Payment advice document. The payment file consolidates all invoices but the payment advice that you can generate by checking this flag creates three indivudal payment advices for the same customer with the same payment method:

And I know that an other company in our AX environment can print consolidated payment advices, but I cannot spot any differences in the setup. Do you have any idea?

Thank you

Was this reply helpful? Yes No
Suggested answer

Mario J. 94 on at

Like (0)

Report
Copy link

Link copied!

I have found my mistake.

In order to consolidate all the invoices from a customer into one payment advice, you must use the payment proposal function . Once you add the journal lines for a customer using the payment proposal, the invoices are consolidated into one journal line and no invoice number is displayed in the invoice field, but a "*" to indicate that there are more than one invoices associated with this payment.

My mistake was, that I thought adding each invoice manually would also create only one payment advice, as the methode of payment, customer account and everything else isthe same.

Now I know better ...

Was this reply helpful? Yes No
André Arnaud de Cal... 304,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the update, Mario. I was assuming you were using the payment proposal feature already. At that time, it will do the consolidation based on the settings on the method of payment.

Was this reply helpful? Yes No