AP/AR Historical Aging

The data model captures various measures related to accounts payable and accounts receivable aging across different currencies, including transaction, reporting, ledger, and global currency. It provides detailed information on the total due, current, overdue, and not yet due amounts in each currency, along with specific aging bucket ranges for overdue amounts in transaction, reporting, ledger, and global currencies. The model allows for comprehensive analysis and monitoring of payables and receivables in multiple currency perspectives.

Benefits of This Data Model

• Enhanced Analytical Capabilities: The data model allows for comprehensive analysis and monitoring of payables and receivables in multiple currency perspectives, enabling better decision-making based on detailed information on total due, current, overdue, and not yet due amounts in each currency.
• Improved Financial Oversight: By capturing various measures related to accounts payable and accounts receivable aging, the data model enhances financial oversight by providing insights into aging trends across different currencies in transaction, reporting, ledger, and global perspectives.
• Efficient Monitoring of Partner Accounts: With dimensions such as Partner Code, Partner Name, and Partner Type, the data model facilitates efficient monitoring of partner accounts, enabling businesses to track and manage credit limits, overdue amounts, and due dates effectively.
• Streamlined Reporting Process: The availability of dimensions like Company Code, Site Code, Account Code, and Document Number in the data model simplifies the reporting process by providing structured data for generating detailed reports on transaction currency, ledger currency, and global currency aging.

Key Performance Indicators (KPIs)

• Transaction Currency Due Amount: The total amount due in the transaction currency.
• Transaction Currency Current Amount: The total current amount in the transaction currency.
• Transaction Currency Overdue Total: The total overdue amount in the transaction currency.
• Transaction Currency Not Due Total: The total amount not yet due in the transaction currency.
• Overdue TC @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: The total amount that is overdue for the specified aging bucket range in the transaction currency.
• Overdue TC @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: The total amount that is overdue for the specified aging bucket range in the transaction currency.
• Overdue TC @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: The total amount that is overdue for the specified aging bucket range in the transaction currency.
• Overdue TC @@AGEBUCKET04+ Days: The total amount that is overdue for the specified aging bucket range in the transaction currency.
• Reporting Currency Due Amount: The total amount due in the reporting currency.
• Reporting Currency Current Amount: The total current amount in the reporting currency.
• Reporting Currency Overdue Total: The total overdue amount in the reporting currency.
• Reporting Currency Not Due Total: The total amount not yet due in the reporting currency.
• Overdue Reporting Currency @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: The total amount that is overdue for the specified aging bucket range in the reporting currency.
• Overdue Reporting Currency @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: The total amount that is overdue for the specified aging bucket range in the reporting currency.
• Overdue Reporting Currency @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: The total amount that is overdue for the specified aging bucket range in the reporting currency.
• Overdue Reporting Currency @@AGEBUCKET04+ Days: The total amount that is overdue for the specified aging bucket range in the reporting currency.
• Ledger Currency Due Amount: The total amount due in the ledger currency.
• Ledger Currency Current Amount: The total current amount in the ledger currency.
• Ledger Currency Overdue Total: The total overdue amount in the ledger currency.
• Ledger Currency Not Due Total: The total amount not yet due in the ledger currency.
• Overdue LC @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: The total amount that is overdue for the specified aging bucket range in the ledger currency.
• Overdue LC @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: The total amount that is overdue for the specified aging bucket range in the ledger currency.
• Overdue LC @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: The total amount that is overdue for the specified aging bucket range in the ledger currency.
• Overdue LC @@AGEBUCKET04+ Days: The total amount that is overdue for the specified aging bucket range in the ledger currency.
• Global Currency Due Amount: The total amount due in the global currency.
• Global Currency Current Amount: The total current amount in the global currency.
• Global Currency Overdue Total: The total overdue amount in the global currency.
• Global Currency Not Due Total: The total amount not yet due in the global currency.
• Overdue GC @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: The total amount that is overdue for the specified aging bucket range in the global currency.
• Overdue GC @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: The total amount that is overdue for the specified aging bucket range in the global currency.
• Overdue GC @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: The total amount that is overdue for the specified aging bucket range in the global currency.
• Overdue GC @@AGEBUCKET04+ Days: The total amount that is overdue for the specified aging bucket range in the global currency.

Available Visualisations

View Name	Description
AP Historical Aging Transaction Currency	Provides insights on the aging of Accounts Payable in transaction currency.
AP Historical Aging Ledger Currency	Offers insights on the aging of Accounts Payable in ledger currency.
AP Historical Aging Global Currency	Provides insights on the aging of Accounts Payable in global currency.
AR Historical Aging Transaction Currency	Offers insights on the aging of Accounts Receivable in transaction currency.
AR Historical Aging Ledger Currency	Provides insights on the aging of Accounts Receivable in ledger currency.
AR Historical Aging Global Currency	Offers insights on the aging of Accounts Receivable in global currency.