Dynamics F/SCM
Dynamics F/SCM
Organizer:
- JOSE Organized by
-
-
Accounts Payable – Reports – Vendor – AP Payment Report
-
Accounts Payable – Reports – Vendor – AP Payment Report
-
We are using Microsoft Dynamics AX 2012 R2. In the accounts payable module, under reports – Vendor, is a report called AP Payment Report. This report seems to only show AP Payments paid by check. Is it a bug that this report doesn’t show payments made by other methods such as ACH? Thanks!——————————
Brad Reeves
Manager – Finance
Bill And Hillary Clinton National Airport
Little Rock AR
—————————— -
?Hi Brad,
We use AX2012 R3, and the AP reports are not that great. You might try running reports under Cash and Bank Management. The report I have used in the past is the “Bank payment summary by vendor.” I have added a screen shot of the Report Criteria I had to add to get the information I needed.
While this report does not list the Method of Payment, the Bank Account Name or the Payment Reference number can be your indicator. We have all of our MOPs in a different bank. Each MOP has a unique set of Check numbers, which also helps us identify what group a particular vendor is under.
You can also run the “Payment summary by date” report. You can select certain bank accounts or all. I think either one of these reports will return the information you need.
Good luck!
——————————
Grace Gillenwater
Accounting Clerk
Landau Uniforms
Olive Branch MS
——————————
——————————————- -
Thanks Grace. I agree that the AP reports aren’t very good. The reason I turned to the AP Payment Report is that it shows vendor payment information with the corresponding General Ledger main account. I couldn’t find another report that does this and can be exported in a fairly decent format. I was doing a research report where I needed vendor’s that we had paid using certain General Ledger numbers.
——————————
Brad Reeves
Manager – Finance
Bill And Hillary Clinton National Airport
Little Rock AR
——————————
——————————————- -
?Hi Brad.
What is weird is that in R3, there isn’t a report with that title for me to select. I tried to run the History by transaction report because you can select a General Ledger number. However, the payment information is not provided.
Maybe an SQL report would be easier to create and run?? I would be curious to hear what your resolution is..
——————————
Grace Gillenwater
Accounting Clerk
Landau Uniforms
Olive Branch MS
——————————
——————————————-
-
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Accounts Payable – Reports – Vendor – AP Payment Report’ is closed to new replies.
