Receivables

Overview

These tables describe Receivables metrics.

Financials - AR Adjustments

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Adjustment date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only posted adjustments are supported.

Metric	Metric Definition
Adjustments Amount	Shows the adjustments amount that is adjusted to the invoices, debit memos, chargebacks, onaccount credits, deposits, and guarantees.
Adjustments Count	Shows the adjustments count that is adjusted to the invoices, debit memos, chargebacks, onaccount credits, deposits, and guarantees.
Adjustments Distribution Amount	Shows the adjustments distribution amount.

Financials - AR Aging

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Transaction date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only posted transactions are supported.

Metric	Metric Definition
Activity Amount	Shows the activities amount of the specified accounts and can be aggregated by business unit, customer, customer account, and time.
Aging Amount - Invoice Date Basis	Shows the aging amount for the open invoices and unapplied receipts based on transaction date grouped by selected aging period.
Aging Amount - Schedule Date Basis	Shows the aging amount for the open invoices and unapplied receipts based on schedule date grouped by selected aging period.
Aging Count - Invoice Date Basis	Shows the aging count for the open invoices and unapplied receipts based on transaction date grouped by selected aging period.
Aging Count - Schedule Date Basis	Shows the aging count for the for the open invoices and unapplied receipts based on schedule date grouped by selected aging period.
Avg Invoice Days Current	This metric is computed as follows: total number of days before due date / current invoices count. This is based on schedule date.
Avg Invoice Days Outstanding	This metric is computed as follows: total number of days invoice outstanding / total outstanding invoices count. This is based on invoice date.
Avg Invoice Days overdue	This metric is computed as follows: total number of days invoice overdue / overdue invoices count. This is based on schedule date.
Closing Amount	Shows the ending balance of the specified accounts and can be aggregated by business unit, customer, customer account and, time.
Current Amount	Shows the invoices amount which are yet to cross the schedule due date.
Current Amount to Total Outstanding %	This metric is computed as follows: (current amount / total outstanding amount) * 100.
Current Count to Total Outstanding %	This metric is computed as follows: (current invoices count / total outstanding invoices count) * 100.
Current Invoices Count	Shows the invoices count which are yet to cross the schedule due date.
Opening Amount	Shows the opening balance of the specified accounts and can be aggregated by business unit, customer, customer account, and time.
Overdue Amount	Shows the invoices and unapplied receipts amount which has crossed the schedule due date.
Overdue Amount to Total Outstanding %	This metric is computed as follows: (overdue amount / total outstanding amount) * 100.
Overdue Count to Total Outstanding %	This metric is computed as follows: (overdue invoices count / total outstanding invoices count) * 100.
Overdue Invoices Count	Shows the invoices and unapplied receipts count which has crossed the schedule due date.
Risk Amount	Shows the receipt amount for which cash is not cleared or risk is not eliminated.
Total Outstanding Amount	Shows the outstanding amount which includes current and overdue invoices and receipts.
Total Outstanding Invoices Count	Shows the count of outstanding invoices and unapplied receipts.
Future Activity Amount	Shows the total activity amount that is accounted in future periods. This amount is available for analysis only in the current snapshot. This metric is exposed only if Receivables Aging (Preview) functional area is activated.
Original Amount	Shows the Transaction Amount for Transactions and the Receipt Amount for Unapplied Receipts.

Financials - AR Credit Memo Applications

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Credit Memo Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only posted credit memo applications are supported.

Metric	Metric Definition
Application Distribution Amount	Shows the credit memo application distribution amount.
Credit Memo Applications Amount	Shows the credit memo applications amount. This considers credit memos with application status as applied and activity. This amount is not available in non-primary ledgers.
Credit Memo Applications Count	Shows the credit memo applications count. This considers credit memos with application status as applied and activity.

Financials - AR Receipts and Applications

These metrics are used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder, and Document Currency (DC) fact folder in subject areas. Analytics currency and exchange rate type are configured during product implementation. Exchange rate date basis is receipt date for receipts and applications to convert to analytics currency. Metrics in these folders show amounts in their respective currencies. Currently only posted receipts and applications are supported.

Metric	Metric Definition
Credit Card Chargeback Amount	Shows the credit card chargeback amount.
Credit Card Refund Amount	Shows the credit card refund amount.
Receipt Distribution Amount	Shows the receipt and application distribution amount.
Receipt Refund Amount	Shows the receipt refund amount.
Receipt to Receipt Application Amount	Shows the receipt to receipt application amount.
Receipt Write-Off Amount	Shows the receipt write-off amount.
Avg Receipts Amount	This metric is computed as follows: receipts amount / receipts count.
Discounts Taken Amount	Shows the total discount amount that was taken.
Discounts Taken of Applied Receipts %	This metric is computed as follows: (discounts taken amount / receipts applications amount) * 100.
Earned Discounts Amount	Shows the total earned discount amount that was taken.
Earned Discounts of Total Discount %	This metric is computed as follows: (earned discounts amount / discounts taken amount) * 100.
Exchange Gain or Loss Amount	Shows the exchange gain or loss amount incurred at the time of receipt.
On account Amount	Shows the receipt amount applied to on account activity when customer is found.
Other Receipt Application Amount	Shows receipt amount that is applied to prepayment, claim investigations activities.
Receipts Amount	Shows the receipts amount from the customers.
Receipts Applications Amount	Shows receipt amount from the customers that are applied against outstanding invoices.
Receipts Transaction Count	Shows the distinct count of receipt numbers.
Unapplied Receipts Amount	Shows receipt amount from the customers that are unapplied against outstanding invoices.
Unearned Discounts Amount	Shows the total unearned discount amount that was taken.
Unearned Discounts of Total Discount %	This metric is computed as follows: (unearned discounts amount / discounts taken amount) * 100.
Unidentified Amount	Shows the unidentified receipts transaction amount.

Financials - AR Revenue

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Transaction date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metric	Metric Definition
Distribution Amount	Shows the distribution amount.
Freight Amount	Shows the freight distribution amount.
Line Amount	Shows the transaction line amount. This amount is not available in non-primary ledgers.
Long Term Deferred Revenue	Shows the deferred or unearned revenue distribution amount that will be recognized after 365 days from current system date.
Revenue Amount	Shows the revenue distribution amount that is recognized.
Short Term Deferred Revenue	Shows the deferred or unearned revenue distribution amount that will be recognized within 365 days from current system date.
Tax Amount	Shows the tax distribution amount.
Transaction Amount	Shows the transaction header amount. This amount is not available in non-primary ledgers.
Unbilled Receivable Amount	Shows the unbilled receivable amount.
Unearned Revenue Amount	Shows the unearned revenue distribution amount that is yet to be recognized.
Quantity Billed	Shows the quantity that is billed.

Financials - AR Transactions

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Transaction date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only posted transactions are supported.

Metric	Metric Definition
Avg Credit Memos Amount	This metric is computed as follows: credit memos amount / credit memos count.
Avg Debit Memos Amount	This metric is computed as follows: debit memos amount / debit memos count.
Avg Invoices Amount	This metric is computed as follows: invoices amount / invoices count.
Credit Memos Amount	Shows the invoice amount for the credit memo transaction type.
Credit Memos Count	Shows the invoices count for credit memo transaction type.
Debit Memos Amount	Shows the invoice amount for the debit memo transaction type.
Debit Memos Count	Shows the invoices count for debit memo transaction type.
Invoices Amount	Shows the invoice amount which includes chargeback, deposits, guarantee, invoices invoice types and excludes the credit memo and debit memo transaction type.
Invoices Count	Shows the invoices count which includes chargeback, deposits, guarantee, invoices invoice types and excludes the credit memo and debit memo transaction type.
Total Transactions Amount	Shows the sum of invoice amount, debit memos amount and credit memos amount.
Total Transactions Count	Shows the distinct count of invoice numbers.
Remaining Amount	Shows the remaining amount for the payment schedule.
Avg Overdue Days	Shows the overdue days calculated as Current Date - Transaction Due Date.