Skip to main content

AR Posted Transactions

The data model includes measures such as Home Currency Invoice Amount, Home Currency Amount Due, Home Currency Current Amount, Home Currency Amount Overdue, Reporting Currency Invoice Amount, Reporting Currency Amount Due, Reporting Currency Current Amount, Reporting Currency Amount Overdue, Overdue Aging HC within specified ranges, and Transaction Currency Invoice Amount. Views like Transaction Listing and Top 5 Customer Amount Due provide additional context for analysis and follow-up on outstanding payment balances.

Benefits of This Data Model​

  • Improved visibility: By analyzing measures such as Home Currency Amount Due and Reporting Currency Amount Overdue across dimensions like Customer Number and Transaction Date, users can gain a clearer view of outstanding payment balances and identify trends over time.
  • Enhanced decision-making: With access to detailed measures like Overdue Aging HC within specified ranges and views like Top 5 Customer Amount Due, stakeholders can make data-driven decisions to prioritize follow-up actions on overdue invoices effectively.
  • Better customer management: Leveraging dimensions such as Customer Name and Customer Group Code alongside measures like Home Currency Current Amount can help in categorizing and managing customer accounts based on outstanding amounts, leading to improved customer engagement and collection strategies.

Key Performance Indicators (KPIs)​

  • Home Currency Invoice Amount: Total amount of all posted transactions in home currency that have been invoiced.
  • Home Currency Amount Due: Total amount of all posted transactions in home currency that are currently due.
  • Home Currency Current Amount: Total amount of all posted transactions in home currency that are current.
  • Home Currency Amount Overdue: Total amount of all posted transactions in home currency that are overdue.
  • Reporting Currency Invoice Amount: Total amount of all posted transactions in reporting currency that have been invoiced.
  • Reporting Currency Amount Due: Total amount of all posted transactions in reporting currency that are currently due.
  • Reporting Currency Current Amount: Total amount of all posted transactions in reporting currency that are current.
  • Reporting Currency Amount Overdue: Total amount of all posted transactions in reporting currency that are overdue.
  • Overdue Aging HC @@ARBUCKET01_MIN-@@ARBUCKET01_MAX Days: Amount of all posted transactions in home currency overdue within the specified aging bucket range.
  • Overdue Aging HC @@ARBUCKET02_MIN-@@ARBUCKET02_MAX Days: Amount of all posted transactions in home currency overdue within the specified aging bucket range.
  • Overdue Aging HC @@ARBUCKET03_MIN-@@ARBUCKET03_MAX Days: Amount of all posted transactions in home currency overdue within the specified aging bucket range.
  • Overdue Aging HC @@ARBUCKET04_MIN-@@ARBUCKET04_MAX Days: Amount of all posted transactions in home currency overdue within the specified aging bucket range.
  • Overdue Aging HC @@ARBUCKET05+ Days: Amount of all posted transactions in home currency that are significantly overdue.
  • Transaction Currency Invoice Amount: Total amount of all posted transactions in transaction currency that have been invoiced.

Available Visualizations​

View NameDescription
Transaction ListingDisplays all posted transactions for analysis and reconciliation purposes.
Top 5 Customer Amount DueIdentifies the top 5 customers with outstanding payment balances for priority follow-up.