Invoice Accuracy sourced measures and KPIs
This table shows the Invoice Accuracy measures that are sourced directly in Data Warehouse.
These measures can be analyzed by different time series. These time series are available:
- Month Ago
- Quarter Ago
- Quarter-To-date
- Trailing 12 Months
- Trailing 3 Months
- Year Ago
- Year-To-date
Most measures have Avg, Max, Min, and Sum aggregations. For cases where this does not apply, the available aggregations are indicated in this table:
| Measure | Description |
|---|---|
| Adjustment Amt | The amount of invoices from adjustment customer orders in the division currency |
| Adjustment Amt – For Curr | The amount of invoices from adjustment customer orders in the foreign currency |
| ARC Amt | The sum of adjustment, return, and corrective invoice amounts in the division currency |
| ARC Amt – For Curr | The sum of adjustment, return, and corrective invoice amounts in the foreign currency |
| Billback Amt | The amount of invoices with an accounting option equal to 15 in the division currency |
| Billback Amt – For Curr | The amount of invoices with an accounting option equal to 15 in the foreign currency |
| Bonus and Comm Amt | The amount of invoices from bonus and commission customer orders in the division currency |
| Bonus and Comm Amt – For Curr | The amount of invoices from bonus and commission customer orders in the foreign currency |
| Cash Disc Amt | The amount of invoices with an accounting option equal to 18 in the division currency |
| Cash Disc Amt – For Curr | The amount of invoices with an accounting option equal to 18 in the foreign currency |
| Corrected Invc Amt | The amount of invoices with an AR additional information number equal to 236 or 256 in the division currency |
| Corrected Invc Amt – For Curr | The amount of invoices with an AR additional information number equal to 236 or 256 in the foreign currency |
| Corrective Invc Amt | The amount of invoices with an AR additional information number equal to 235 or 255 in the division currency |
| Corrective Invc Amt – For Curr | The amount of invoices with an AR additional information number equal to 235 or 255 in the foreign currency |
| Cumulative Interest Amt | The cumulative interest amount in the division currency |
| Debit Note Amt | The amount of invoices with an accounting option equal to 16 in the division currency |
| Debit Note Amt – For Curr | The amount of invoices with an accounting option equal to 16 in the foreign currency |
| Invoice Amt | The invoice amount in the division currency |
| Invoice Amt – For Curr | The invoice amount in the foreign currency |
| Manual Amt | The amount of non-order invoices with an accounting option equal to 0 in the division currency |
| Manual Amt – For Curr | The amount of non-order invoices with an accounting option equal to 0 in the foreign currency |
| No. of Adj Invc | The number of invoices from adjustment customer orders
Aggregations: Avg, Sum |
| No. of ARC Invc | The total number of adjustment, return, and corrective invoices
Aggregations: Avg, Sum |
| No. of Billback Invc | The number of invoices with an accounting option equal to 15
Aggregations: Avg, Sum |
| No. of Bonus and Comm Invc | The number of invoices from bonus and commission customer orders
Aggregations: Avg, Sum |
| No. of Corrected Invc | The number of invoices with an AR additional information number equal
to 236 or 256 Aggregations: Avg, Sum |
| No. of Corrective Invc | The number of invoices with an AR additional information number equal
to 235 or 255 Aggregations: Avg, Sum |
| No. of Debit Note Invc | The number of invoices with an accounting option equal to
16 Aggregations: Avg, Sum |
| No. of Invc w/ Cash Disc | The number of invoices with an accounting option equal to
18 Aggregations: Avg, Sum |
| No. of Invc w/ Ded | The number of invoices that have payments with deductions
Aggregations: Avg, Sum |
| No. of Invc w/ Var | The number of invoices that have payments with an accounting option
not equal to 0 or 18 Aggregations: Avg, Sum |
| No. of Invc w/o Ded | The number of invoices that have payments without deductions
Aggregations: Avg, Sum |
| No. of Invc w/o Var | The number of invoices that have payments with an accounting option
equal to 0 or 18 only Aggregations: Avg, Sum |
| No. of Invoices | The number of invoices Aggregation: Sum |
| No. of Manual Invc | The amount of non-order invoices with an accounting option equal to 0
Aggregations: Avg, Sum |
| No. of Normal Order Invc | The number of invoices from normal customer orders Aggregations: Avg, Sum |
| No. of Payments | The number of payments made on an invoice Aggregations: Avg, Sum Aggregations: Avg, Sum |
| No. of Pmt Reminders | The number of payment reminders of an invoice Aggregations: Avg, Sum |
| No. of Pmt w/ Ded | The number of payments to invoices with deductions specified by an
accounting option greater than 0 Aggregations: Avg, Sum |
| No. of Pmt w/o Ded | The number of payments to invoices with deductions specified by an
accounting option equal to 0 Aggregations: Avg, Sum |
| No. of Return Invc | The number of invoices from return customer orders Aggregations: Avg, Sum |
| No. of Total Order Invc | The number of invoices that are coming from sales orders
Aggregations: Avg, Sum |
| No. of Write-Off Invc | The number of invoices with an accounting option greater than 19 Aggregations: Avg, Sum |
| Normal Order Amt | The amount of invoices from normal customer orders in the division currency |
| Normal Order Amt – For Curr | The amount of invoices from normal customer orders in the foreign currency |
| Pmt Tolerance Amt | The amount of invoices with an accounting option equal to 19 in the division currency |
| Pmt Tolerance Amt – For Curr | The amount of invoices with an accounting option equal to 19 in the foreign currency |
| Return Amt | The amount of invoices from return customer orders in the division currency |
| Return Amt – For Curr | The amount of invoices from return customer orders in the foreign currency |
| Total Order Amt | The total amount of invoices that are coming from customer orders and variances in the division currency |
| Total Order Amt – For Curr | The total amount of invoices that are coming from customer orders and variances in the foreign currency |
| Total Var Amt | The sum of debit note, billback, and write-off invoice amounts in the division currency |
| Total Var Amt – For Curr | The sum of debit note, billback, and write-off invoice amounts in the foreign currency |
| Write-Off Amt | The amount of invoices with an accounting option greater than 19 in the division currency |
| Write-Off Amt – For Curr | The amount of invoices with an accounting option greater than 19 in the foreign currency |