Announcements
Hi everyone!
I am looking for a Vendor Payment Advice (not sure that's what it should be called) in AX 2009.
We need a system generated report that gives us a summary of pending payments to the vendor with amount and other details per purchase order number.
The need for the report is that we can print it from AX and use it for approval from Management for payments. Right now we are using an excel spreadsheet and manually entering the information into it.
Is there such a report currently in AX 2009? It would also be amazing if we can also mark payments in the report once it is made so that the status of the payments are closed and only pending payments are shown in the report. We have had cases of our accountants mistakenly making payments twice because they forgot to update the payments.
Any help on such a report would be helpful. Thanks a lot in advance.
*This post is locked for comments
Hi Mercedes,
The functionality in D365FO is totally different from the one that was available in AX2012 and prior versions.
Can you please create a new thread in the D365FO forum because you ended up here in the 'AX' forum.
Many thanks,
Ludwig
Hi Ludwig,
I'm working in D365 v10 update 26
thanks!
Hello Mercedes,
What Dynamics version do you operate?
Best regards,
Ludwig
Hi Ludwig,
I'm trying to confirm if the Payment advice available on the payment journals (Print / Payment advice) can only be generated if the journal hasn't been posted yet.
If so, we are afraid the users will forget to generate it on time, or even change the journal and not re print the advice.
You mentioned here that the Payment advice can be automatically generated when the "Generate payment" is done, that will solve our issues, could you please tell me how do you set it up to be printed automatically?
Kind regards
Mercedes
Hi,
The payment advice report can only be printed if you generate the payments in the payment journal.
That is, you must select functions-generate payments and depending on the method of payment and the country specific features/format, the payment advice is printed.
If you only settle payments without generating the payments then the report is not printed.
Best regards,
Ludwig
Thank you Dr. Ludwig for your reply. Could you direct me to this payment advice report. Our accountants dont seem to be able to print this report. Since my experience with financial side is limited, pls let me know how I can print this report.
Currently our finance is updating vendor payments as follows.
1. Payment journal entry in accounts payable between bank and vendor.
2. The journal entry is posted after selecting it as "settlement" in the functions menu of the journal.
Hi,
AX2009 ships with a standard payment advice report that is automatically printed at the time a vendor payment is generated in AX. The report can, however, not easily reprinted unless you regenerate the payments.
The standard payment advice report lists all payments by vendor, not separated by PO number. You get details of the invoices that are paid but as far as I remember the PO number is not part of the standard report. If this is a must have criteria for you then you may have to modify the standard report or create your own report design.
Best regards,
Ludwig
André Arnaud de Cal...
294,118
Super User 2025 Season 1
Martin Dráb
232,866
Most Valuable Professional
nmaenpaa
101,158
Moderator