AR Invoices sourced measures and KPIs

This table shows the AR Invoices measures that are sourced directly in Data Warehouse.

You can use different time series to analyze these measures. For the list of available time series measures, see Time.

Aggregations available are Avg, Max, Min, and Sum. For cases where this does not apply, the available aggregations are indicated in this table:

Measure Description
No. of AR Invoice Records

The total number of AR invoice records

Aggregation: Avg, Sum

Operational Metrics

Measure Description
Cumulative Interest Amt The cumulative interest amount in the division currency
VAT Amt The VAT amount in the division currency
Invc Amt – Transaction The invoice amount in the transaction currency
Invc Amt – Division The invoice amount in the division currency
Invc Amt – Third Curr The invoice amount in the third currency
Pmt Amt – Transaction The payment amount in the transaction currency
Pmt Amt – Division The payment amount in the division currency
Pmt Amt – Third Curr The payment amount in the third currency
No. of Pmts The number of payments made on an invoice
No. of Total Pmt The total number of payment journals of an invoice
No. of Pmt Reminders The number of payment reminders of an invoice
Pmt Reversal Amt – Transaction The payment reversal amount in the transaction currency
Pmt Reversal Amt – Division The payment reversal amount in the division currency
Pmt Reversal Amt – Third Curr The payment reversal amount in the third currency
No. of Pmt Reversals The number of payment reversals
Weighted Amt – Invc and Due – Division The invoice amount in the division currency multiplied by the number of days between the invoice date and the due date
Weighted Amt – Invc and Pmt – Division The payment amount in the division currency multiplied by the number of days between the invoice date and the final payment date
Weighted Amt – Due and Pmt – Division The payment amount in the division currency multiplied by the number of days between the due date and the final payment date
Days Diff – Due and Pmt The number of days between the due date and the final payment date
Days Diff – Invc and Due The number of days between the invoice date and the due date
Days Diff – Invc and Pmt The number of days between the invoice date and the final payment date
Total Days Diff – Invc and Pmt Total number of days between the invoice date and the payment dates
Days Diff – Invc and Recon The number of days between the invoice date and the internal reconciliation date
No. of Invcs The number of customer invoices
No. of Record Changes The number of times an invoice record was updated in M3

Credit Management

Measure Description
Overdue Weighted Amt – Invc and Pmt – Transaction The total payment amount in the transaction currency multiplied by the number of days between the invoice and payment dates
Overdue Weighted Amt – Invc and Pmt – Division The total payment amount in the division currency multiplied by the number of days between the invoice and payment dates
Overdue Weighted Amt – Invc and Pmt – Third Curr The total payment amount in the third currency multiplied by the number of days between the invoice and payment dates
Overdue Weighted Amt – Due and Pmt – Transaction The amount paid past the due date in the transaction currency multiplied by the number of days between the due date and the payment dates
Overdue Weighted Amt – Due and Pmt – Division The amount paid past the due date in the division currency multiplied by the number of days between the due date and the payment dates
Overdue Weighted Amt – Due and Pmt – Third Curr The amount paid past the due date in the third currency multiplied by the number of days between the due date and the payment dates
Overdue Weighted Amt – Adj Due and Pmt – Transaction The amount paid past the adjusted due date in the transaction currency multiplied by the number of days between the adjusted due date and the payment dates
Overdue Weighted Amt – Adj Due and Pmt – Division The amount paid past the adjusted due date in the division currency multiplied by the number of days between the adjusted due date and the payment dates
Overdue Weighted Amt – Adj Due and Pmt – Third Curr The amount paid past the adjusted due date in the third currency multiplied by the number of days between the adjusted due date and the payment dates
Overdue Weighted Amt – Follow-up and Pmt – Transaction The amount paid past the follow-up date in the transaction currency multiplied by the number of days between the follow-up date and the payment dates
Overdue Weighted Amt – Follow-up and Pmt – Division The amount paid past the follow-up date in the division currency multiplied by the number of days between the follow-up date and the payment dates
Overdue Weighted Amt – Follow-up and Pmt – Third Curr The amount paid past the follow-up date in the third currency multiplied by the number of days between the follow-up date and the payment dates
Overdue Weighted Amt – Adj Follow-up and Pmt – Transaction The amount paid past the adjusted follow-up date in the transaction currency multiplied by the number of days between the adjusted follow-up date and the payment dates
Overdue Weighted Amt – Adj Follow-up and Pmt – Division The amount paid past the adjusted follow-up date in the division currency multiplied by the number of days between the adjusted follow-up date and the payment dates
Overdue Weighted Amt – Adj Follow-up and Pmt – Third Curr The amount paid past the adjusted follow-up date in the third currency multiplied by the number of days between the adjusted follow-up date and the payment dates
Amt Paid Past Due Date – Transaction The total amount paid past the due date in the transaction currency
Amt Paid Past Due Date – Division The total amount paid past the due date in the division currency
Amt Paid Past Due Date – Third Curr The total amount paid past the due date in the third currency
Pmts Past Due Date Number of payments made after the due date
Amt Paid Past Adj Due Date – Transaction The total amount paid past the due date including the defined credit limit 4 of a customer in the transaction currency
Amt Paid Past Adj Due Date – Division The total amount paid past the due date including the defined credit limit 4 of a customer in the division currency
Amt Paid Past Adj Due Date – Third Curr The total amount paid past the due date including the defined credit limit 4 of a customer in the third currency
Pmts Past Adj Due Date Number of payments made after the allowed number of days past the due date
Amt Paid Past Follow-up – Transaction The total amount paid past the follow-up date in the transaction currency
Amt Paid Past Follow-up – Division The total amount paid past the follow-up date in the division currency
Amt Paid Past Follow-up – Third Curr The total amount paid past the follow-up date in the third currency
Pmts Past Follow-up Date Number of payments made after the follow-up date
Amt Paid Past Adj Follow-up – Transaction The total amount paid past the follow-up date including the defined credit limit 4 of a customer in the transaction currency
Amt Paid Past Adj Follow-up – Division The total amount paid past the follow-up date including the defined credit limit 4 of a customer in the division currency
Amt Paid Past Adj Follow-up – Third Curr The total amount paid past the follow-up date including the defined credit limit 4 of a customer in the third currency
Pmts Past Adj Follow-up Date Number of payments made after the allowed number of days past the follow-up date

Invoice Accuracy

Measure Description
Manual Amt – Transaction The amount of non-order invoices with an accounting option equal to 0 in the transaction currency
Manual Amt – Division The amount of non-order invoices with an accounting option equal to 0 in the division currency
Manual Amt – Third Curr The amount of non-order invoices with an accounting option equal to 0 in the third currency
No. of Manual Invc The amount of non-order invoices with an accounting option equal to 0
Normal Order Amt – Transaction The invoiced amount from normal customer orders in the transaction currency
Normal Order Amt – Division The invoiced amount from normal customer orders in the division currency
Normal Order Amt – Third Curr The invoiced amount from normal customer orders in the third currency
No. of Normal Order Invc The number of invoices from normal customer orders
Total Order Amt – Transaction The total invoiced amount from customer orders and variances in the transaction currency
Total Order Amt – Division The total invoiced amount from customer orders and variances in the division currency
Total Order Amt – Third Curr The total invoiced amount from customer orders and variances in the third currency
No. of Total Order Invc The number of invoices that are coming from sales orders
Total Var Amt – Transaction The sum of debit note, billback, and write-off invoice amounts in the transaction currency
Total Var Amt – Division The sum of debit note, billback, and write-off invoice amounts in the division currency
Total Var Amt – Third Curr The sum of debit note, billback, and write-off invoice amounts in the third currency
No. of Invc w/ Var The number of invoices that have payments with an accounting option equal to 15, 16 or between 20 and 99
No. of Invc w/o Var The number of invoices that have payments with an accounting option not equal to 15, 16 or between 20 and 99
Corrected Invc Amt – Transaction The amount of invoices with an AR additional information number equal to 236 or 256 in the transaction currency
Corrected Invc Amt – Division The amount of invoices with an AR additional information number equal to 236 or 256 in the division currency
Corrected Invc Amt – Third Curr The amount of invoices with an AR additional information number equal to 236 or 256 in the third currency
No. of Corrected Invc The number of invoices with an AR additional information number equal to 236 or 256
Corrective Invc Amt – Transaction The amount of invoices with an AR additional information number equal to 235 or 255 in the transaction currency
Corrective Invc Amt – Division The amount of invoices with an AR additional information number equal to 235 or 255 in the division currency
Corrective Invc Amt – Third Curr The amount of invoices with an AR additional information number equal to 235 or 255 in the third currency
No. of Corrective Invc The number of invoices with an AR additional information number equal to 235 or 255
Write-Off Amt – Transaction The amount of invoices with an accounting option greater than 19 and below 99 in the transaction currency
Write-Off Amt – Division The amount of invoices with an accounting option greater than 19 and below 99 in the division currency
Write-Off Amt – Third Curr The amount of invoices with an accounting option greater than 19 and below 99 in the third currency
No. of Write-Off Invc The number of invoices with an accounting option greater than 19 and below 99
Curr Deviation Amt – Transaction The amount of invoices with an accounting option equal to 99 in the transaction currency
Curr Deviation Amt – Division The amount of invoices with an accounting option equal to 99 in the division currency
Curr Deviation Amt – Third Curr The amount of invoices with an accounting option equal to 99 in the third currency
No. of Curr Deviation Invc The number of invoices with an accounting option equal to 99
Total Write-Off Amt – Transaction The sum of write-off and currency deviation invoice amounts in the transaction currency
Total Write-Off Amt – Division The sum of write-off and currency deviation invoice amounts in the division currency
Total Write-Off Amt – Third Curr The sum of write-off and currency deviation invoice amounts in the third currency
Total Write-Off Invc The number of invoices with an accounting option greater than 19 and below 100
Billback Amt – Transaction The amount of invoices with an accounting option equal to 15 in the transaction currency
Billback Amt – Division The amount of invoices with an accounting option equal to 15 in the division currency
Billback Amt – Third Curr The amount of invoices with an accounting option equal to 15 in the third currency
No. of Billback Invc The number of invoices with an accounting option equal to 15
Debit Note Amt – Transaction The amount of invoices with an accounting option equal to 16 in the transaction currency
Debit Note Amt – Division The amount of invoices with an accounting option equal to 16 in the division currency
Debit Note Amt – Third Curr The amount of invoices with an accounting option equal to 16 in the third currency
No. of Debit Note Invc The number of invoices with an accounting option equal to 16
No. of Invc w/ Ded The number of invoices that have payments with deductions specified by accounting option not equal to 0
No. of Invc w/o Ded The number of invoices that have payments without deductions specified by accounting option equal to 0
Pmt Tolerance Amt – Transaction The amount of invoices with an accounting option equal to 19 in the transaction currency
Pmt Tolerance Amt – Division The amount of invoices with an accounting option equal to 19 in the division currency
Pmt Tolerance Amt – Third Curr The amount of invoices with an accounting option equal to 19 in the third currency
No. of Invc w/ Payment Tolerance The number of invoices with an accounting option equal to 19
Cash Disc Amt – Transaction The amount of invoices with an accounting option equal to 18 in the transaction currency
Cash Disc Amt – Division The amount of invoices with an accounting option equal to 18 in the division currency
Cash Disc Amt – Third Curr The amount of invoices with an accounting option equal to 18 in the third currency
No. of Invc w/ Cash Disc The number of invoices with an accounting option equal to 18
No. of Pmt w/ Ded The number of payments to invoices with deductions specified by an accounting option greater than 0
No. of Pmt w/o Ded The number of payments to invoices without deductions specified by an accounting option equal to 0