Skip to main content

Purchase Transactions

The data model tracks supplier credit limits, transaction details including values, allocations, discounts, and balances, as well as overdue amounts categorized by different ranges of days. Views include breakdowns of outstanding balances by age brackets, real-time current transactions, opening balance invoices, invoices, credit notes, payments, and receipts. The model enables comprehensive monitoring and analysis of supplier transactions, credit limits, and overdue payments.

Benefits of This Data Model​

  • Enhanced Supplier Monitoring: The data model enables comprehensive monitoring of supplier transactions, credit limits, overdue amounts, and outstanding balances categorized by different age brackets.
  • Real-time Transaction Insights: Users can access real-time data on current purchase transactions through the "Current Transactions" view, facilitating timely decision-making.
  • Improved Financial Analysis: By providing views such as "Opening Balance Invoices," "Invoices," "Credit Notes," "Payments," and "Receipts," the model enhances financial analysis capabilities for tracking transaction values, discounts, allocations, and balances.
  • Detailed Supplier Analysis: The inclusion of multiple dimensions such as "Supplier Country," "Supplier City," and various "Supplier Analysis Codes" allows for in-depth analysis and segmentation of suppliers based on different criteria.
  • Efficient Payment Management: With measures for "Transaction Balance," "Overdue Total," and specific overdue days categories, the data model supports efficient management of payments and helps in identifying and addressing overdue amounts in a timely manner.

Key Performance Indicators (KPIs)​

  • Supplier 80% Credit Limit: The credit limit of the supplier set to 80% of the total credit limit.
  • Supplier Credit Limit: The total credit limit assigned to the supplier.
  • Transaction Value: The total value of the transaction.
  • Transaction Tax Value: The value of tax associated with the transaction.
  • Transaction Discount Value: The amount of discount applied to the transaction.
  • Transaction Allocated Value: The amount allocated from the transaction.
  • Transaction Balance: The remaining balance on the transaction.
  • Current Amount: The current amount of the transaction.
  • Overdue Total: The total amount that is overdue.
  • Overdue @@S200UK_APBUCKET01MIN-@@S200UK_APBUCKET01MAX Days: The total amount that is overdue within a specific range of days.
  • Overdue @@S200UK_APBUCKET02MIN-@@S200UK_APBUCKET02MAX Days: The total amount that is overdue within a different range of days.
  • Overdue @@S200UK_APBUCKET03MIN-@@S200UK_APBUCKET03MAX Days: The total amount that is overdue within another range of days.
  • Overdue @@S200UK_APBUCKET04+ Days: The total amount that is overdue for more than a specific number of days.

Available Visualizations​

View NameDescription
Balance by Age BracketProvides a breakdown of outstanding balances by different age brackets.
Current TransactionsDisplays real-time data on current purchase transactions.
Opening Balance InvoicesShows invoices that were open at the beginning of the specified period.
InvoicesLists all invoices generated for purchase transactions.
Credit NotesDetails all credit notes issued for adjustments in purchase transactions.
PaymentsSummarizes all payments made against the purchase transactions.
ReceiptsShows records of receipts received from customers for completed transactions.