AP Transactions

The data model includes views for Supplier Payments in both Ledger and Transaction currencies, AP Current Aging in Ledger and Transaction currencies, and detailed AP Transaction Information. It encompasses measures for total amounts due, paid, outstanding, debit and credit totals in various currencies, current balances, outstanding amounts grouped by invoice and due dates within specific age buckets, and supplier credit limits, aiding in payables analysis and reporting.

Benefits of This Data Model

• Enhanced Payables Analysis: The data model provides detailed information on supplier payments in both ledger and transaction currencies, enabling deeper analysis of payables data.
• Improved Reporting Accuracy: By including measures for total amounts due, paid, outstanding, debit and credit totals in various currencies, the data model ensures more accurate and comprehensive reporting of accounts payable information.
• Efficient Aging Status Tracking: With views for AP Current Aging in both ledger and transaction currencies, the data model allows for efficient tracking of aging status and overdue payments within specific age buckets.
• Supplier Credit Limit Monitoring: The inclusion of measures for supplier credit limits enables monitoring and analysis of credit limits with respect to outstanding amounts, providing insights into credit risk management.
• Multi-Currency Support: Having measures for balances, amounts due, and amounts paid in different currencies facilitates multi-currency support in analyzing and managing payables across diverse regions or markets.

Key Performance Indicators (KPIs)

• Ledger Currency Amount Due: Total amount due in the ledger currency.
• Ledger Currency Amount Paid: Total amount paid in the ledger currency.
• Balance: Current balance amount.
• Outstanding LC (by Inv. Date) @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: Outstanding ledger currency amount grouped by invoice date within a specific age bucket range.
• Outstanding LC (by Inv. Date) @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: Outstanding ledger currency amount grouped by invoice date within a specific age bucket range.
• Outstanding LC (by Inv. Date) @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: Outstanding ledger currency amount grouped by invoice date within a specific age bucket range.
• Outstanding LC (by Inv. Date) @@AGEBUCKET04_LAST+ Days: Outstanding ledger currency amount grouped by invoice date in the last age bucket range.
• Outstanding LC (by Due. Date) @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: Outstanding ledger currency amount grouped by due date within a specific age bucket range.
• Outstanding LC (by Due. Date) @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: Outstanding ledger currency amount grouped by due date within a specific age bucket range.
• Outstanding LC (by Due. Date) @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: Outstanding ledger currency amount grouped by due date within a specific age bucket range.
• Outstanding LC (by Due. Date) @@AGEBUCKET04_LAST+ Days: Outstanding ledger currency amount grouped by due date in the last age bucket range.
• Ledger NEC_Currency Debit: Total debit amount in the ledger's non-employee cost currency.
• Ledger NEC_Currency Credit: Total credit amount in the ledger's non-employee cost currency.
• Ledger NEC_Currency Current Outstanding: Current outstanding amount in the ledger's non-employee cost currency.
• Supplier Credit Limit: Credit limit allocated to the supplier.
• CredLimFmt: Credit limit formatted.
• Transaction Currency Debit: Total debit amount in the transaction currency.
• Transaction Currency Credit: Total credit amount in the transaction currency.
• Transaction Currency Amount Due: Total amount due in the transaction currency.
• Transaction Currency Balance: Current balance amount in the transaction currency.
• Transaction Currency Amount Paid: Total amount paid in the transaction currency.
• Transaction Currency Current Outstanding: Current outstanding amount in the transaction currency.
• Outstanding TC (by Inv. Date) @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: Outstanding transaction currency amount grouped by invoice date within a specific age bucket range.
• Outstanding TC (by Inv. Date) @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: Outstanding transaction currency amount grouped by invoice date within a specific age bucket range.
• Outstanding TC (by Inv. Date) @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: Outstanding transaction currency amount grouped by invoice date within a specific age bucket range.
• Outstanding TC (by Inv. Date) @@AGEBUCKET04_LAST+ Days: Outstanding transaction currency amount grouped by invoice date in the last age bucket range.
• Outstanding TC (by Due Date) @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: Outstanding transaction currency amount grouped by due date within a specific age bucket range.
• Outstanding TC (by Due Date) @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: Outstanding transaction currency amount grouped by due date within a specific age bucket range.
• Outstanding TC (by Due Date) @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: Outstanding transaction currency amount grouped by due date within a specific age bucket range.
• Outstanding TC (by Due Date) @@AGEBUCKET04_LAST+ Days: Outstanding transaction currency amount grouped by due date in the last age bucket range.

Available Visualizations

View Name	Description
Supplier Payments (Ledger Currency)	Provides a summary of payments made to suppliers in the ledger currency.
AP Current Aging (Ledger Currency)	Displays the current aging status of accounts payable in the ledger currency.
AP Transaction Information	Offers detailed information on accounts payable transactions for analysis and reporting.
AP Current Aging (Transaction Currency)	Shows the current aging status of accounts payable in the transaction currency.
Supplier Payments (Transaction Currency)	Summarizes payments made to suppliers in the transaction currency for analysis.