Accounts payable analysis fact

Accounts Payable Analysis is used to analyze how much money is owed by a business to its suppliers on a current date. The fact contains invoices vouched for payment, and AP sub ledger if it has outstanding amounts that have not been paid.

These calculation rules are used:


Name	Calculation Rule
Payment Amount	`If aptrxp.type is one of P or O or N, then return (aptrxp.amt_paid / aptrxp.exch_rate)`
Invoice Amount	`If aptrxp.type is V or A, then return (aptrxp.inv_amt / aptrxp.exch_rate)`
Aging Date	`If apparms.inv_due is invoice date (I) then choose aptrxp.inv_date` `If apparms.inv_due is due date (D) then choose aptrxp.due_date` `If apparms.inv_due is discount date, then choose aptrxp.disc_date` `else choose aptrxp.due_date`
Age	Current Date - Aging Date

Multi-currency

Birst uses the current exchange rate to convert the amount to the report currency amount. To get the report currency amount, Birst multiplies the domestic amount by the current rate. If there is no currency rate, then 0 displays.

Calculation:

current rate amount = domestic amount * current exchange rate

If there is no exchange rate, then 0 displays.