AR Transactions

The data model includes measures such as total amount debited and credited in ledger and transaction currencies, amounts due, current balances, amounts paid, current outstanding balances, and outstanding amounts based on invoice and due dates within specified days ranges in both ledger and transaction currencies. It also incorporates the customer's credit limit and a formatted version of the credit limit. Views present data on AR invoice applications, current aging in ledger and transaction currencies, and detailed AR transaction information for financial reporting, cash flow monitoring, global operations, and international financial analysis.

Benefits of This Data Model

• Enhanced Financial Reporting: The data model allows for the generation of detailed financial reports by providing information on total amounts debited and credited, current balances, outstanding amounts, and invoice details in ledger and transaction currencies.
• Improved Cash Flow Monitoring: By incorporating measures such as current outstanding balances and amounts paid in both ledger and transaction currencies, the model enables better monitoring of cash flow for effective financial management.
• Global Operations Analysis: The model provides views on AR transaction information in both ledger and transaction currencies, facilitating analysis for global operations and international financial decision-making.
• Credit Limit Management: The inclusion of customer credit limit and a formatted version of the credit limit supports efficient monitoring and management of credit limits for customers, aiding in risk mitigation and financial stability.

Key Performance Indicators (KPIs)

• Ledger NEC_Currency Debit: Total amount debited in the ledger currency using the NEC currency.
• Transaction Currency Debit: Total amount debited in the transaction currency.
• Ledger NEC_Currency Credit: Total amount credited in the ledger currency using the NEC currency.
• Transaction Currency Credit: Total amount credited in the transaction currency.
• Ledger Currency Amount Due: Total amount due in the ledger currency.
• Transaction Currency Amount Due: Total amount due in the transaction currency.
• Ledger Currency Balance: Current balance in the ledger currency.
• Transaction Currency Balance: Current balance in the transaction currency.
• Ledger Currency Amount Paid: Total amount paid in the ledger currency.
• Transaction Currency Amount Paid: Total amount paid in the transaction currency.
• Ledger NEC_Currency Current Outstanding: Current outstanding amount in the ledger currency using the NEC currency.
• Transaction Currency Current Outstanding: Current outstanding amount in the transaction currency.
• Outstanding LC (by Inv. Date) @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: Outstanding amount in the ledger currency based on invoice date within the given days range.
• Outstanding TC (by Inv. Date) @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: Outstanding amount in the transaction currency based on invoice date within the given days range.
• Outstanding LC (by Due. Date) @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: Outstanding amount in the ledger currency based on due date within the given days range.
• Outstanding TC (by Due. Date) @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: Outstanding amount in the transaction currency based on due date within the given days range.
• Customer Credit Limit: The credit limit set for the customer.
• credLimFmt: Formatted version of the customer's credit limit.

Available Visualizations

View Name	Description
AR Invoice Application (Ledger Currency)	Displays invoice applications in ledger currency for financial reporting.
AR Current Aging (Ledger Currency)	Shows current outstanding receivables in ledger currency for monitoring cash flow.
AR Transaction Information	Provides detailed information on AR transactions for analysis and reconciliation.
AR Current Aging (Transaction Currency)	Illustrates current outstanding receivables in transaction currency for global operations.
AR Invoice Application (Transaction Currency)	Exhibits invoice applications in transaction currency for international financial analysis.