Aller au contenu principal

AR Invoice Transactions Historical

The AR Invoice Transactions Historical data model provides historical transaction-level visibility into customer receivables. It supports as-of-date analysis of invoices, payments, retainage, adjustments, balances, due amounts, and aging by customer, project, company, department, location, class, employee, and transaction type.

Benefits of This Data Model​

  • Review historical receivables: See which customer invoices were outstanding as of a selected reporting date.
  • Analyze historical aging: Review open balances across current and past-due aging buckets using due-date or GL-date aging.
  • Track payments and retainage: Analyze payments, adjustments, retained amounts, released amounts, and historical invoice balances.

Key Performance Indicators (KPIs)​

  • Invoice Amount: Total customer invoice amount.
  • Payment Amount: Payments applied to the invoice.
  • Retained Amount: Retainage held on the invoice.
  • Released Amount: Retainage released.
  • Retainage Balance: Outstanding retainage balance.
  • Total Invoice Balance: Total remaining invoice balance.
  • Adjustment Amount: Adjustments applied to the invoice.
  • Due Amount: Invoice amount currently due.
  • Current Amount: Open amount in the current aging bucket.
  • Current Amount by GL Date: Open amount in the current aging bucket when aging is based on GL/posting date.
  • 1-30 Days: Open amount aged 1-30 days.
  • 1-30 Days by GL Date: Open amount aged 1-30 days by GL/posting date.
  • 31-60 Days: Open amount aged 31-60 days.
  • 31-60 Days by GL Date: Open amount aged 31-60 days by GL/posting date.
  • 61-90 Days: Open amount aged 61-90 days.
  • 61-90 Days by GL Date: Open amount aged 61-90 days by GL/posting date.
  • 91+ Days: Open amount aged 91 days or more.
  • 91+ Days by GL Date: Open amount aged 91 days or more by GL/posting date.
  • Base Invoice Amount: Invoice amount in base currency.
  • Base Payment Amount: Payment amount in base currency.
  • Base Retained Amount: Retained amount in base currency.
  • Base Released Amount: Released retainage in base currency.
  • Base Retainage Balance: Retainage balance in base currency.
  • Base Total Invoice Balance: Total invoice balance in base currency.
  • Base Adjustment Amount: Adjustment amount in base currency.
  • Base Due Amount: Due amount in base currency.
  • Base Aging Amounts: Aging amounts expressed in base currency.

Available Visualizations​

View NameDescription
AR Detail Report (Historical Aging by Due Date)Provides historical AR detail aged using invoice due dates.
AR Detail Report (Historical Aging by Posted Date)Provides historical AR detail aged using GL/posting dates.