Measures
This table shows the accounts receivable measures:
Measure | Mapping | Note |
---|---|---|
Accounts Receivable Count | Always 1 | (1) |
Advance Amount | If ACR Document Type = Advance Receipt or Assignment and the main document has document type Advance Receipt, then Amount. Else, 0. | (1) |
Advance or Unallocated Receipt Amount | If ACR Document Type = Advance Receipt or Unallocated Receipt, then Amount. Else, 0. | |
Advance or Unallocated Receipt Count | If ACR Document Type = Advance Receipt or Unallocated Receipt, then 1. Else, 0. | |
Amount | For invoice currency, tfacr200.amti. For transaction currency, tfacr200.amnt. Else, tfacr200.amth. |
(1) |
Anticipated Receipt Amount | If ACR Document Type = Anticipated Receipt, Advance Anticipated, or Unallocated Anticipated, then Amount. Else, 0. | (1) |
Anticipated Receipt Count | If ACR Document Type = Anticipated Receipt, Advance Anticipated, or Unallocated Anticipated, then 1. Else, 0. | |
Balance | Balance amount on Accounts Receivable. For invoice currency, tfacr200.balc. For transaction currency, tfacr200.balc. Else, tfacr200.balh. |
(1) |
Balance Advance | If ACR Document Type = Advance Receipt and the transaction is a main document, then Balance. Else, 0. | |
Balance Anticipated | Anticipated Balances on Accounts Receivable. For invoice Currency, tfacr200.bala. For transaction currency, tfacr200.bala. Else, tfacr200.bahc. |
(1) |
Balance Credit Note | If ACR Document Type = Credit Note and the transaction is a main document, then Balance. Else, 0. | (1) |
Balance Invoice | If ACR Document Type = Sales Invoice, then Balance. Else, 0. | (1) |
Balance Not Yet Due | Total Balance if Days Overdue Aging = 0, else 0. | |
Balance Total Open Entry | Balance + Balance Anticipated | (1) |
Balance Trade Note | If ACR Document Type = Trade Note and the transaction is a main document, then Balance. Else, 0. | (1) |
Balance Unallocated | If ACR Document Type = Unallocated Receipt and the transaction is a main document, then Balance. Else, 0. | (1) |
Bank Charge Amount | Handling charges by the bank for the Receipt or Settlement. For transaction currency, tfacr200.baco. For the home currencies, tfacr200.baca. Else, calculated. |
(1) |
Correction Count | If ACR Document Type = Correction, then 1. Else, 0. | (1) |
Credit Note Count | If ACR Document Type = Credit Note and the transaction is a main document, then 1. Else, 0. | (1) |
Days Overdue | If Open Entry and Current Date > Due Date, then Current Date – Due Date. Note
that this is calculated during processing of the Finance space, and not at report
rendering. Else, Clearing Date – Due Date. Main documents without a Due Date in LN have a Due Date of 31/12/9999 and Days Overdue of 0 in LN Analytics. |
|
Days Overdue Aging | Days Overdue. Main documents without a Due Date in LN have a Days Overdue Aging of 99999 in LN Analytics. | |
Discount Amount Taken | First Discount Taken + Second Discount Taken + Third Discount Taken. | (1) |
Disputed Amount |
Balance if Disputed, else 0. | |
Disputed Count |
1 if Disputed, 0 if not Disputed. | |
Due Amount Disputed |
Balance if Late and Disputed and no Advance or Unallocated Receipt. Else, 0. | |
Due Amount not Disputed |
Balance if Late and not Disputed and no Advance or Unallocated Receipt. Else, 0. | |
Estimated Collectable Amount |
Total Balance - Estimated Uncollectable Amount if Total Balance <> 0. Else, 0. | |
Estimated Uncollectable Amount |
Non-payment probability increases with age, the uncollectable amount is estimated
by assigning percentages to each age bucket and summing the estimated unpaid amounts
for each age bucket: Balance Not Yet Due * Estimate Percentage Not Yet Due + Overdue Bucket 1 * Estimate Percentage Bucket 1 + Overdue Bucket 2 * Estimate Percentage Bucket 2 + Overdue Bucket 3 * Estimate Percentage Bucket 3 + Overdue Bucket 4 * Estimate Percentage Bucket 4 + Overdue Bucket 5 * Estimate Percentage Bucket 5 + Overdue Bucket 6 * Estimate Percentage Bucket 6. |
(2) |
Estimated Uncollectable Ratio |
Estimated Uncollectable Amount / Total Balance | |
First Discount Amount Taken | Only for subdocuments (Receipt or Settlements). For invoice currency, -1*tfacr200.dc1i. For transaction currency, -1*tfacr200.dc1a. Else, -1*tfacr200.dc1h. For Main Documents, 0. |
(1) |
Late Count | If Invoice or Credit Note is completed after the Due Date, then 1. Else, 0. | (1) |
Late Payment Surcharge Actual Amount | Only for subdocuments (Receipt or Settlement). For invoice currency, tfacr200.lapi. For transaction currency, tfacr200.lapa. Else, tfacr200.laph. |
(1) |
Not Due Amount Disputed | Balance if not Late and Disputed and no Advance or Unallocated Receipt. Else, 0. | |
Not Due Amount not Disputed | Balance if not Late and not Disputed and no Advance or Unallocated Receipt. Else, 0. | |
Open Amount Ratio | Balance/Amount | |
Open Entries Count | If Main Document is open, then 1. Else, 0. | (1) |
Overdue Amount | Balance for main documents that are late or whose due date is empty. Else, 0.
Note that this is calculated during processing of the Finance space, and not at report rendering. |
|
Overdue Amount Aging | Total Balance for main documents that are late. Else, 0. Note that this is calculated during processing of the Finance space, and not at report rendering. |
|
Overdue Bucket 1 | Total Balance, if Days Overdue Aging > 0 and Days Overdue Aging <= OverdueBucket1. Else, 0. | 2 |
Overdue Bucket 2 | Total Balance, if Days Overdue Aging > OverdueBucket1 and Days Overdue Aging <= OverdueBucket2. Else, 0. | 2 |
Overdue Bucket 3 | Total Balance, if Days Overdue Aging > OverdueBucket2 and Days Overdue Aging <= OverdueBucket3. Else, 0. | 2 |
Overdue Bucket 4 | Total Balance, if Days Overdue Aging > OverdueBucket3 and Days Overdue Aging <= OverdueBucket4. Else, 0. | 2 |
Overdue Bucket 5 | Total Balance, if Days Overdue Aging > OverdueBucket4 and Days Overdue Aging <= OverdueBucket5. Else, 0. | 2 |
Overdue Bucket 6 | Total Balance, if Days Overdue Aging > OverdueBucket5 and Days Overdue Aging <= OverdueBucket6. Else, 0. | 2 |
Overdue Ratio | Overdue Amount Aging / Total Balance | |
Payment Difference Amount | Payment difference between the Accounts Receivable and the Receipt or
Settlement. For invoice currency, tfacr200.padi + tfacr200.amti when ACR Document Type = Payment Difference. For transaction currency, tfacr200.pada + tfacr200.amnt when ACR Document Type = Payment Difference. Else, tfacr200.padh + tfacr200.amth when ACR Document Type = Payment Difference. |
(1) |
Realized Currency Difference Amount | Realized Currency Differences due to exchange rate changes. For invoice currency, calculated. For transaction currency, 0. Else, tfacr200.cdam. |
(1) |
Receipt Amount | If ACR Document Types = Normal Receipt and Assignment (when the Receipt or Settlement is assigned to a Sales Invoice), then Amount. Else, 0. | (1) |
Receipt Count | If ACR Document Types = Normal Receipt, Assignment (when the Receipt or Settlement is assigned to a Sales Invoice), then 1. Else, 0. | |
Reminded Amount | Balance if Reminded. Else, 0. | |
Reminded Count | 1 if Reminded, 0 if not Reminded. | |
Sales Invoice Amount | Invoice amount based on ACR Document Types Sales Invoice, Correction, or Credit Note main document. | |
Sales Invoice Count | If ACR Document Types = Sales Invoice, then 1. Else, 0. | (1) |
Second Discount Amount Taken | Only for subdocuments (Receipt or Settlements). For invoice currency, -1*tfacr200.dc2i. For transaction currency, -1*tfacr200.dc2a. Else, -1*tfacr200.dc2h. For Main Documents, 0. |
(1) |
Settlement Amount | If ACR Document Type = Purchase Invoice, Trade Note, and Credit Note (when the Credit note is a subdocument), then Amount. Else, 0. | (1) |
Settlement Count | If ACR Document Types = Purchase Invoice, Trade Note and Credit Note (when the Credit Note is a subdocument), then 1, Else, 0. | (1) |
Tax Amount | For invoice currency, tfacr200.vati. For transaction currency, tfacr200.vata. Else, tfacr200.vath. |
(1) |
Third Discount Amount Taken | Only for subdocuments (Receipt or Settlements). For invoice currency, -1*tfacr200.dc3i. For transaction currency, -1*tfacr200.dc3a. Else, -1*tfacr200.dc3h. For Main Documents, 0. |
(1) |
Trade Note Amount | If ACR Document Type = Trade Note, then Amount. Else, 0. | (1) |
Trade Note Count | If ACR Document Type = Trade Note, then 1. Else, 0. | (1) |
Unallocated Amount | If ACR Document Types = Unallocated Receipt and Assignment (when the receipt or Settlement is assigned to an Unallocated Receipt), then Amount. Else, 0. | (1) |
Unrealized Currency Difference Amount | Unrealized currency difference due to exchange rate change. For invoice currency, calculated + tfacr200.amti when ACR Document Type = Currency Difference. For transaction currency, calculated + tfacr200.amnt when ACR Document Type = Currency Difference. Else, tfacr200.tore + tfacr200.amth when ACR Document Type = Currency Difference. |
(1) |
Written Off Count | 1 if Written Off, 0 if not Written Off. |
- (1) Amounts facts are semi-additive (SA): amounts are available in 7 currency types (IC,
LC, RC1, RC2, RFC, DWC, TC). Amounts in the invoice currency (IC) and transaction currency
(TC) can only be summed safely by filtering Accounts Receivables for a specific transaction
currency. Other amounts can be summed safely for a single company and for multiple companies
that have the same currency and financial period setup.Note: The amounts are only semi-additive when you filter on:
- The correct segment type records in the fact table. The fact table contains records
that belong to three different segment types: 10: Header, 20: Line, and 99: Not
Applicable. As end user you can report on header or line. When you report on Header.
ensure to include records of segment type 10: header and 99: Not Applicable. When
reporting on Line, include records of segment type 20: line and 99: Not Applicable. To
facilitate report and dashboard creation, these attributes have been added to the
Segment Type dimension:
- Segment Dashboard Filter
- Segment Header Filter
- Segment Line
- The Sublevel attributes of the Chart of Account and Dimension01 till Dimension12 dimensions when they are dragged into a report. Otherwise, amounts and counts from sublevel 0 accounts and their parent accounts are added together.
- The correct segment type records in the fact table. The fact table contains records
that belong to three different segment types: 10: Header, 20: Line, and 99: Not
Applicable. As end user you can report on header or line. When you report on Header.
ensure to include records of segment type 10: header and 99: Not Applicable. When
reporting on Line, include records of segment type 20: line and 99: Not Applicable. To
facilitate report and dashboard creation, these attributes have been added to the
Segment Type dimension:
- (2) Overdue Buckets 1 - 6 and estimate percentages can be configured.
The default 4 overdue buckets are 1-30, 31-60, 61-90, and 91-99999 days. By default, overdue buckets 5 and 6 are not used, but are available.
The overdue buckets can be changed in user variables LN_usr_ReportOverdueBucket1 - LN_usr_ReportOverdueBucket6.
The default estimate percentage for Not Yet Due is 1% and can be changed in the user variable LN_usr_ReportEstimatePercentageUncollectableReceivablesNotYetDue.
The default estimate percentages for the 4 overdue buckets are 5%, 10%, 25%, and 50%. Estimate percentages for overdue buckets 5 and 6 are also set at 50%, but not used in the default overdue buckets.
The estimate percentages for overdue buckets can be changed in user variables LN_usr_ReportEstimatePercentageUncollectableReceivablesBucket1 - LN_usr_ReportEstimatePercentageUncollectableReceivablesBucket6.
This table lists the aging buckets, default days, and default estimated uncollectable %:
Aging bucket Days Estimated Uncollectable % Not Yet Due <= 0 days 1% Overdue Bucket 1 1-30 days 5% Overdue Bucket 2 31-60 days 10% Overdue Bucket 3 61-90 days 25% Overdue Bucket 4 91-99999 days 50% Overdue Bucket 5 Unused 50% Overdue Bucket 6 Unused 50%