Aller au contenu principal

Balance âgée des tiers courrante

The data model encompasses various currency-specific measures for due amounts, current amounts, and overdue totals in transaction currency, reporting currency, ledger currency, and global currency. Age bucket ranges further delineate overdue amounts within specific timeframes for each currency. Views like AP Current Aging and AR Current Aging offer aging analysis based on the currency of transactions or ledger accounts, providing comprehensive insights into accounts payable and accounts receivable performance across different currencies.

Benefits of This Data Model​

  • Improved Financial Analysis: The data model allows for detailed analysis of due amounts, current amounts, and overdue totals across different currencies, providing valuable insights into financial performance.
  • Enhanced Decision Making: By segmenting overdue amounts based on age bucket ranges for each currency, stakeholders can make data-driven decisions to better manage accounts payable and accounts receivable.
  • Comprehensive Reporting Capabilities: With dimensions like Company Code, Partner Type, Transaction Currency, and Ledger Currency, the data model offers a wide range of reporting options to track financial metrics accurately.
  • Increased Visibility Across Currencies: The inclusion of measures in transaction currency, reporting currency, ledger currency, and global currency enables a holistic view of accounts payable and accounts receivable performance in various currency contexts.

Key Performance Indicators (KPIs)​

  • Transaction Currency Due Amount: The total amount of money due in the transaction currency.
  • Transaction Currency Current Amount: The total current amount of money in the transaction currency.
  • Transaction Currency Overdue Total: The total overdue amount of money in the transaction currency.
  • Overdue TC @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: The total overdue amount in the transaction currency within the specified age bucket range.
  • Overdue TC @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: The total overdue amount in the transaction currency within the specified age bucket range.
  • Overdue TC @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: The total overdue amount in the transaction currency within the specified age bucket range.
  • Overdue TC @@AGEBUCKET04+ Days: The total overdue amount in the transaction currency beyond the specified age bucket range.
  • Reporting Currency Due Amount: The total amount of money due in the reporting currency.
  • Reporting Currency Current Amount: The total current amount of money in the reporting currency.
  • Reporting Currency Overdue Total: The total overdue amount of money in the reporting currency.
  • Overdue Reporting Currency @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: The total overdue amount in the reporting currency within the specified age bucket range.
  • Overdue Reporting Currency @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: The total overdue amount in the reporting currency within the specified age bucket range.
  • Overdue Reporting Currency @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: The total overdue amount in the reporting currency within the specified age bucket range.
  • Overdue Reporting Currency @@AGEBUCKET04+ Days: The total overdue amount in the reporting currency beyond the specified age bucket range.
  • Ledger Currency Due Amount: The total amount of money due in the ledger currency.
  • Ledger Currency Current Amount: The total current amount of money in the ledger currency.
  • Ledger Currency Overdue Total: The total overdue amount of money in the ledger currency.
  • Overdue LC @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: The total overdue amount in the ledger currency within the specified age bucket range.
  • Overdue LC @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: The total overdue amount in the ledger currency within the specified age bucket range.
  • Overdue LC @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: The total overdue amount in the ledger currency within the specified age bucket range.
  • Overdue LC @@AGEBUCKET04+ Days: The total overdue amount in the ledger currency beyond the specified age bucket range.
  • Global Currency Due Amount: The total amount of money due in the global currency.
  • Global Currency Current Amount: The total current amount of money in the global currency.
  • Global Currency Overdue Total: The total overdue amount of money in the global currency.
  • Overdue GC @@AGEBUCKET01_MIN-@@AGEBUCKET01_MAX Days: The total overdue amount in the global currency within the specified age bucket range.
  • Overdue GC @@AGEBUCKET02_MIN-@@AGEBUCKET02_MAX Days: The total overdue amount in the global currency within the specified age bucket range.
  • Overdue GC @@AGEBUCKET03_MIN-@@AGEBUCKET03_MAX Days: The total overdue amount in the global currency within the specified age bucket range.
  • Overdue GC @@AGEBUCKET04+ Days: The total overdue amount in the global currency beyond the specified age bucket range.

Available Visualisations​

View NameDescription
Balance âgée des fournisseurs (devise tran)Displays aging analysis for AR in the currency of individual transactions.
Balance âgée des fournisseurs (devise réf)Provides aging analysis for AP in the currency of the ledger accounts.
Balance âgée des fournisseurs (devise global)Provides aging analysis for AP in the organization's global currency.
Balance âgée des clients (devise tran)Shows aging analysis for AP in the currency of individual transactions.
Balance âgée des clients (devise réf)Gives aging analysis for AR in the organization's global currency.
Balance âgée des clients (devise global)Displays aging analysis for AR in the currency of the ledger accounts.