Calculated measures

This table shows the measures that are calculated in the fact:


Measure	Measure description
Outstanding Payable	Outstanding Payable indicates the total un-paid invoice amount. It is calculated from the sum of all invoice amounts and adjusted amounts minus the sum of all payments and discounts taken. Calculation: `Outstanding Payable = aptrxp.inv_amt – amt_paid – amt_disc`
Invoice Amount	Invoice Amount indicates the total invoices value in base currency. It is composed of voucher and adjustment amounts. It is calculated from invoice amount of voucher plus invoice amount of adjustment by aging date. The reference field is aptrxp.inv_amt and aptrxp.type when type is V voucher and A adjustment. Calculation: `Invoice Amount = aptrxp.inv_amt when type is V or A`
Payment Amount	Payment Amount is the total payment value in base currency. It is composed of all types of payments, for example P for payment, O for open check, and N for Non-A/P payment. It is calculated from the sum of aptrxp.amt_paid. Calculation: `Payment Amount = aptrxp.amt_paid`
Open Invoice Count	Open Invoice Count indicates the total number of un-fully paid invoices.
Outstanding Payable %	Outstanding Payable % is the percentage of outstanding payable. This is a rule created in BV.