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

All responses (4)

Answers (0)

André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

Consolidate vendor payment advice

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.
Suggested answer

Mario J. 94 on at

Like (0)

Report

Consolidate vendor payment advice

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 ...
Mario J. 94 on at

Like (0)

Report

Consolidate vendor payment advice

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
André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

Consolidate vendor payment advice

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.

Consolidate vendor payment advice

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Leaderboard

Featured topics

Product updates

Consolidate vendor payment advice

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Subscribe to

Leaderboard

Featured topics

Product updates