Skip to main content

AR Invoice Payments

The data model allows tracking of invoice and payment amounts in both home currency and transaction currency. It provides insights into the total invoiced amount, payments made, credit notes issued, and the remaining amount due in both currencies, enabling effective financial analysis and management. Two distinct views "AR Invoice vs Payment HC" and "AR Invoice vs Payment TC" offer comparisons of invoice and payment totals for different analytical purposes.

Benefits of This Data Model​

  • Enhanced Financial Analysis: The data model allows for detailed analysis of invoiced amounts, payments made, credit notes issued, and outstanding amounts in both home currency and transaction currency, providing a comprehensive view for financial analysis purposes.
  • Improved Currency Management: By tracking invoice and payment amounts in both home and transaction currencies, the data model facilitates efficient currency management and helps in assessing currency fluctuations' impact on the business.
  • Better Customer Insights: The inclusion of dimensions such as Customer ID, Customer Code, Customer Name, and Customer Group allows for a deeper understanding of customer behaviors, preferences, and financial interactions, aiding in targeted marketing strategies and customer relationship management.
  • Streamlined Sales Analysis: With dimensions like Sales Representative 1 Code, Sales Representative 1 Name, and Order Number, the data model enables sales performance tracking, identification of top-performing representatives, and evaluation of sales trends for better strategic decision-making.

Key Performance Indicators (KPIs)​

  • Home Currency Invoice Amount: The total amount of the invoice in the home currency of the company.
  • Home Currency Payment Amount: The total amount of payments made in the home currency to settle the invoice.
  • Home Currency Credit Note Amount: The total amount of credit notes issued in the home currency for adjustments on the invoice.
  • Home Currency Amount Due: The remaining amount due in the home currency after deducting payments and credit notes from the invoice amount.
  • Transaction Currency Invoice Amount: The total amount of the invoice in the currency of the transaction.
  • Transaction Currency Payment Amount: The total amount of payments made in the transaction currency to settle the invoice.
  • Transaction Currency Credit Note Amount: The total amount of credit notes issued in the transaction currency for adjustments on the invoice.
  • Transaction Currency Amount Due: The remaining amount due in the transaction currency after deducting payments and credit notes from the invoice amount.

Available Visualizations​

View Name**Description **
AR Invoice vs Payment HCCompares total amount of AR invoices vs payments for high-level analysis.
AR Invoice vs Payment TCCompares total count of AR invoices vs payments for trend analysis purposes.