Skip to main content

AR Invoice

The AR Invoice data model provides detailed line-level visibility into customer invoices and receivable balances. It supports analysis of invoice amounts, payments, balances, retainage, aging, GL accounts, projects, departments, locations, and customer details in transaction, base, and reporting currencies.

Benefits of This Data Model​

  • Analyze invoice detail: Review the individual invoice lines and GL distributions behind receivable balances.
  • Monitor aging and retainage: Analyze current, overdue, retained, released, and outstanding amounts.
  • Support multidimensional AR analysis: Review receivables by customer, project, account, company, location, department, and related attributes.

Key Performance Indicators (KPIs)​

  • Transaction Currency: Currency used for the document transaction.
  • Transaction Amount: Document-line amount in transaction currency.
  • Transaction Paid Amount: Paid amount in transaction currency.
  • Transaction Due Amount: Due amount in transaction currency.
  • Transaction Overdue Amount: Overdue amount in transaction currency.
  • Transaction Current Amount: Current aging amount in transaction currency.
  • Transaction 1-30 Days: Amount aged 1-30 days in transaction currency.
  • Transaction 31-60 Days: Amount aged 31-60 days in transaction currency.
  • Transaction 61-90 Days: Amount aged 61-90 days in transaction currency.
  • Transaction 91+ Days: Amount aged 91 days or more in transaction currency.
  • Transaction Amount Retained: Retained amount in transaction currency.
  • Transaction Amount Released: Released retainage in transaction currency.
  • Transaction Amount Less Retainage: Transaction amount net of retainage.
  • Transaction Balance Excluding Retainage: Outstanding transaction balance excluding retainage.
  • Transaction Retainage Balance: Outstanding retainage in transaction currency.
  • Transaction Total Balance: Total outstanding transaction balance.
  • Base Currency: Base currency used for the document.
  • Base Amount: Document-line amount in base currency.
  • Base Paid Amount: Paid amount in base currency.
  • Base Due Amount: Due amount in base currency.
  • Base Overdue Amount: Overdue amount in base currency.
  • Base Current Amount: Current aging amount in base currency.
  • Base 1-30 Days: Amount aged 1-30 days in base currency.
  • Base 31-60 Days: Amount aged 31-60 days in base currency.
  • Base 61-90 Days: Amount aged 61-90 days in base currency.
  • Base 91+ Days: Amount aged 91 days or more in base currency.
  • Base Amount Retained: Retained amount in base currency.
  • Base Amount Released: Released retainage in base currency.
  • Base Amount Less Retainage: Base amount net of retainage.
  • Base Balance Excluding Retainage: Outstanding base balance excluding retainage.
  • Base Retainage Balance: Outstanding retainage in base currency.
  • Base Total Balance: Total outstanding balance in base currency.
  • Reporting Amount: Amount in reporting currency.
  • Reporting Paid Amount: Paid amount in reporting currency.
  • Reporting Due Amount: Due amount in reporting currency.
  • Reporting Overdue Amount: Overdue amount in reporting currency.
  • Reporting Current Amount: Current aging amount in reporting currency.
  • Reporting 1-30 Days: Amount aged 1-30 days in reporting currency.
  • Reporting 31-60 Days: Amount aged 31-60 days in reporting currency.
  • Reporting 61-90 Days: Amount aged 61-90 days in reporting currency.
  • Reporting 91+ Days: Amount aged 91 days or more in reporting currency.
  • Retainage Percentage: Retainage percentage applied to the document line.

Available Visualizations​

No predefined reports are listed for this data model in the CRE package.