Sales Analysis: Accounts Payable

The "Vendor Sales Analysis" data object consolidates all sales-related metrics and transaction data from vendors to enable comprehensive business analysis. It aggregates information such as total sales, number of invoices, average sales per invoice and per year, and the duration of the business relationship. This analysis supports strategic decisions in supplier management, budget planning, and the evaluation of business partnerships through detailed sales analyses.

List

A comprehensive overview of all vendor data and sales metrics in tabular form. Includes master data, sales statistics, and invoice details for a complete vendor analysis.

Property	Description
Creditor Number	A unique identification number for the creditor, used to assign and manage suppliers and service providers in the system. This number allows for clear differentiation between various business partners during sales analysis.
Name	The name of the creditor for whom the sales report is being generated. This field uniquely identifies the business partner and enables the sales data to be assigned to the corresponding supplier or service provider.
Total Net Revenue [€]	Total net sales represent the sum of all sales for a vendor, excluding value-added tax. This figure serves as the basis for evaluating the business relationship and for tax-related analyses.
Outstanding gross [€]	Total gross amount of outstanding purchase invoices in euros
Number of invoices	Number of incoming invoices from this vendor
Average Revenue per Purchase [€]	Displays the average sales per purchase transaction for a vendor. This metric helps evaluate purchasing behavior and the business relationship by showing the ratio of total sales to the number of purchases.
Average Annual Revenue [€]	Shows a vendor's average annual revenue based on recorded transaction data. This figure is used to evaluate the business relationship and supports supplier evaluation and budget planning.
Date of First Invoice	The date on which the first invoice for this vendor was created. This field indicates the start of the business relationship and is used to track sales history chronologically.
Date of Last Invoice	Displays the date of the last invoice created for this vendor. This field helps provide an overview of invoicing activity and allows you to identify vendors that have been inactive for extended periods.
Street	The street address of the creditor's business location, which is used for sales analysis and correspondence. This information is part of the complete address details and is required for reports and the allocation of sales.
ZIP Code	The creditor's ZIP code, which is used for geographic classification and regional analysis of sales. It enables the analysis of business relationships by location and supports regional reporting.
City	The city indicates the creditor's geographic location and is used for regional analysis of sales and for assignment to sales territories.
Country	The vendor's country, which is used to geographically categorize and analyze sales distribution by country. This information enables country-specific analyses and reports for accounts payable.
Email	The creditor's email address for direct communication and the sending of documents such as invoices or payment confirmations. This contact information facilitates efficient electronic correspondence within the business relationship.
Number of recurring invoices	Displays the number of invoices that have been processed for this vendor as part of recurring invoices.
Number of Individual Invoices	Displays the total number of individual invoices recorded in the sales report for the respective vendor. This figure provides insight into the invoice volume and business activity with the corresponding supplier.
Sales Template	Shows the creditor's typical billing pattern over a specific period. "Regular (>=4 invoices in >=6 months)": At least 4 invoices spread over at least 6 months; "Regular (>=3 invoices, interval <90 days)": At least 3 invoices with an average interval of less than 90 days; "Regular (>=12 invoices)": Many invoices (regardless of the time period); "Occasional/One-time": Few invoices or long intervals
Average number of days between invoices	Displays the average number of days between consecutive invoices from a vendor. This metric helps analyze invoicing frequency and supports cash flow planning as well as the evaluation of the business relationship.
Number of months	Indicates the number of months between the first and last invoices
Revenue Type	Classifies revenue by business segment or revenue source. This classification enables a detailed analysis of revenue distribution and supports strategic business planning.
Number of direct debit payments	Displays the number of payments collected from vendors via direct debit. This metric enables the analysis of preferred payment methods and supports the evaluation of payment processing in sales analysis.
Number of payments via invoice	Displays the total number of sales invoiced by the respective vendor.
Primary Payment Method	The primary payment method used for transactions with this vendor. This information determines the preferred method of payment and is used for automated payment processing.
Direct Debit	Indicates whether the vendor uses direct debit as their preferred payment method. This information is used to automatically select the payment method for transactions.