Skip to main content

AP Invoice Payments

The AP Invoice Payments data model for Sage 300 contains the views AP Invoice vs Payment HC and AP Invoice vs Payment TC. It includes the measures total amount paid, which is the sum of payments made towards AP invoices, average payment amount for each AP invoice payment, number of payments made towards AP invoices, and maximum and minimum payment amount per AP invoice.

How to use the account payable invoice payments data model​

  • Analyze vendor performance by vendor ID, vendor code, and vendor name.
  • Compare company performance by company code and company name.
  • Follow payment dates, due dates, and related metrics to manage payments and forecast cash flow.
  • Analyze transactions in different currencies with the transaction currency dimension, including currency fluctuations and international transactions.

Available views​

View nameType of viewWhat it shows
AP Invoice vs Payment HCWorksheetCompares high level trends between AP invoices and payments.
AP Invoice vs Payment TCWorksheetTracks the detailed metrics of AP invoices and payments.