Customer Average Payment Days
The data model includes measures such as Number Of Invoices, Transaction Currency Amount Total, By Due Date Amount Not Due, By Due Date Amount 61-90, By Invoice Date Amount Not Due, Average Days to Pay, Global Currency Amount Total, and corresponding values in reporting and global currencies. Customer-specific metrics, including Credit Limit and average payment days, are captured for analysis and monitoring purposes.
Benefits of This Data Model
- Improved Customer Payment Monitoring: The data model allows for tracking and analyzing customer-specific metrics such as Credit Limit and average payment days, enhancing the monitoring of customer payment behavior.
- Enhanced Financial Reporting: With measures like Transaction Currency Amount Total and Global Currency Amount Total, the data model provides accurate and comprehensive financial information in both transactional and global currencies for reporting purposes.
- Efficient Analysis of Payment Trends: By including measures like By Due Date Amount 61-90 and Average Days to Pay, the data model enables the analysis of payment trends over time, aiding in forecasting and decision-making processes.
- Streamlined Company Performance Evaluation: Utilizing dimensions like Company Code and Company Name, the data model facilitates evaluating and comparing the performance of different companies within the organization based on various financial metrics.
- Enhanced Data Integrity and Consistency: The inclusion of dimensions such as Day, Accounting Date, Due Date, and Payment Date ensures the integrity and consistency of the data model, providing a reliable foundation for accurate analysis and reporting.
Key Performance Indicators (KPIs)
- Number Of Invoices: The total count of invoices related to customer payments.
- Transaction Currency Amount Total: The total sum of transaction amounts in the customer's currency.
- By Due Date Amount Not Due: The amount due from the customer that is not yet past the due date.
- By Due Date Amount 61-90: The amount due from the customer that falls within the 61-90 days overdue range.
- By Invoice Date Amount Not Due: The amount due from the customer based on the invoice date that is not yet past the due date.
- Credit Limit: The credit limit assigned to the customer for payment purposes.
- Reporting Currency Amount Total: The total sum of transaction amounts converted to the reporting currency.
- By Due Date (Reporting Currency) Amount Not Due: The amount due from the customer in reporting currency that is not yet past the due date.
- By Due Date (Reporting Currency) Amount 61-90: The amount due from the customer in reporting currency that falls within the 61-90 days overdue range.
- By Invoice Date (Reporting Currency) Amount Not Due: The amount due from the customer in reporting currency based on the invoice date that is not yet past the due date.
- Reporting Currency Credit Limit: The credit limit assigned to the customer in reporting currency for payment purposes.
- Average Days to Pay: The average number of days taken by the customer to pay invoices.
- Global Currency Amount Total: The total sum of transaction amounts converted to global currency.
- By Due Date (Global) Amount Not Due: The amount due from the customer in global currency that is not yet past the due date.
- By Due Date (Global) Amount 61-90: The amount due from the customer in global currency that falls within the 61-90 days overdue range.
- By Invoice Date (Global) Amount Not Due: The amount due from the customer in global currency based on the invoice date that is not yet past the due date.
- Payments (Global) Credit Limit: The credit limit assigned to the customer in global currency for payment purposes.
Available Visualizations
| View Name | Description |
|---|---|
| Customer Average Payment Days Amounts | Displays average payment days amounts per customer for analysis. |
| Average Payment Days | Calculates the average payment days across all customers for monitoring. |