Accounts payable periodical analysis fact

Accounts Payable Periodical Analysis is used to analyze how much money is owed by you to your suppliers in a specified period. The fact contains invoices vouched for payment, and the AP sub ledger if it has outstanding amounts that have not been paid.

These calculation rules are used:


Name	Calculation Rule
Month End	Month End is the last date of a month. All measures in the view should be calculated for each month end date. This means if a voucher or an adjustment occurred before the date, it will be included in the calculation; otherwise it will be excluded.
Payment Amount	`If aptrxp.type is one of P, 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` `or else choose aptrxp.due_date`
Age	This is the time span between specified date and 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.