AR Reports

The data model includes measures such as Customer Credit Limit, Transaction Amount, Transaction Paid Amount, and various aging period categories. Views like AR Aging Report in both base and transaction currencies offer insights on outstanding receivables. Another view, Customer Credit vs Credit Limit, aids in assessing credit risk through comparing customer credit balance with set limits. Reporting amounts are also available in specific currencies for detailed reporting.

Benefits of This Data Model

• Enhanced Credit Risk Assessment: The comparison of customer credit balances with set credit limits in the "Customer Credit vs Credit Limit" view allows for a more accurate evaluation of credit risk, aiding in proactive risk management strategies.
• Holistic Receivables Analysis: Through views like "AR Aging Report" in both base and transaction currencies, a comprehensive analysis of outstanding receivables aged by time periods can be conducted, providing insights for better decision-making.
• Detailed Currency-Specific Reporting: Availability of reporting amounts in specific currencies allows for in-depth reporting, catering to the needs of global operations and analysis in different regions.

Key Performance Indicators (KPIs)

• Customer Credit Limit: The maximum amount of credit extended to a customer by the business.
• Transaction Amount: The total amount of a transaction.
• Transaction Paid Amount: The amount of the transaction that has been paid by the customer.
• Transaction Due Amount: The amount of the transaction that is still outstanding and due for payment.
• Transaction Current Amount: The current amount of the transaction that is due for immediate payment.
• Transaction 1-30 Days: The amount of the transaction that is due within 1-30 days.
• Transaction 31-60 Days: The amount of the transaction that is due within 31-60 days.
• Transaction 61-90 Days: The amount of the transaction that is due within 61-90 days.
• Transaction 91+ Days: The amount of the transaction that is due more than 90 days ago.
• Reporting Amount (You Reporting Currency): The reported total amount in a specific currency.
• Reporting Paid Amount (You Reporting Currency): The reported amount paid in a specific currency.
• Reporting Due Amount (You Reporting Currency): The reported amount that is still due for payment in a specific currency.
• Reporting Current Amount (You Reporting Currency): The currently due reported amount in a specific currency.
• Reporting 1-30 Days (You Reporting Currency): The reported amount that is due within 1-30 days in a specific currency.
• Reporting 31-60 Days (You Reporting Currency): The reported amount that is due within 31-60 days in a specific currency.
• Reporting 61-90 Days (You Reporting Currency): The reported amount that is due within 61-90 days in a specific currency.
• Reporting 91+ Days (You Reporting Currency): The reported amount that is due more than 90 days ago in a specific currency.
• Base Amount: The base total amount.
• Base Paid Amount: The base amount that has been paid.
• Base Due Amount: The base amount that is still due for payment.
• Base Current Amount: The current amount due in the base currency.
• Base 1-30 Days: The base amount that is due within 1-30 days.
• Base 31-60 Days: The base amount that is due within 31-60 days.
• Base 61-90 Days: The base amount that is due within 61-90 days.
• Base 91+ Days: The base amount that is due more than 90 days ago.

Available Visualizations

View Name	Description
AR Aging Report (Base Currency)	Displays outstanding receivables aged by time periods in base currency.
Customer Credit vs Credit Limit	Compares customer credit balance against set credit limit for monitoring credit risks.
AR Aging Report (Transaction Currency)	Shows aged receivables by time periods in transactional currencies for global insights.