AR Invoices sourced measures and KPIs
This table shows the AR Invoices measures that are sourced directly in Data Warehouse.
These measures can be analyzed by different time series. 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 |