Calculated measures

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

Name Calculation Rule
Outstanding Payable

Outstanding Payable indicates the total un-paid invoice amount. It is calculated from the sum of all invoice amounts and adjust 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 for voucher and A for 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 Amount Open Invoice Count indicates the total number of un-fully paid invoices.
Outstanding Payable %

The percentage of outstanding payable is a rule created in BV.

Calculation:
Outstanding Payable % = Outstanding Payable / Invoice Amount * 100