D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

AP Payment by Vendor Report

  • 1.  AP Payment by Vendor Report

    Posted 8 days ago
    How do i run a report that will give me all payments out of AP subtotaled by vendor and month?  It would be great if it could also show where the expense was coded as well.

    ------------------------------
    Terra Rollins
    Controller
    Augeo Affinity Marketing
    St. Paul MN
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: AP Payment by Vendor Report

    GOLD CONTRIBUTOR
    Posted 8 days ago
    Are you on D365? Here are my notes on some options I have created over time:

     

    Vendor spend analysis

    • Procurement and sourcing > inquiries and reports > purchase performance analysis > purchase and spend analysis
      • Requires powerbi
    • Procurement and sourcing > inquiries and reports > vendor statistics > top 100 vendors
      • Pros - summarized data, shows you vendor by spend, can change how many vendors come through
      • Cons - no detailed transactions
      • Sorting - by revenue, quantity, or account #
    • Vendor spend / vendor spend total dollars
      • Cash and bank management > inquiries and reports > Payment summary by vendor report
        • Pros - detailed report, can be ran by vendor, provides payment date
        • Cons - lengthy time to run depending on query


    ------------------------------
    Ian Gorman, PMP, MCSE
    Senior Consultant
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: AP Payment by Vendor Report

    TOP CONTRIBUTOR
    Posted 8 days ago
    You could also try the Vendor posted payment journal report and modify it to get the additional information and formatting required.. You will need to add a filter by date range. It will not subtotal payments by vendor (i.e. it will list multiple payments sequentially) or have the bank offset account.




    ------------------------------
    Christopher Ho Yee
    Altius Consulting
    Richmond BC
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role