Skip to main content

Invoices

The data model encompasses views such as Top 5 Sales Person, Invoices, and Invoices (Satin Demo) with measures like Act Comm Amt, Calc Comm Amt, Comm Base, Unit Cost, Unit Price, Unit Price Ovrd, Ext Amt, Freight Amt, Qty Shipped, and Trade Disc Amt. It allows for analyzing sales performance, commission calculations, pricing strategies, shipment quantities, extended amounts, and trade discounts across various invoice transactions, including those related to satin demo products.

Benefits of This Data Model​

  • Enhanced Sales Performance Analysis: The data model enables detailed analysis of sales performance by providing insights into individual salesperson revenue, invoice transactions, extended amounts, and trade discounts.

  • Improved Commission Calculations: With measures such as Act Comm Amt, Calc Comm Amt, and Comm Base, the data model facilitates accurate commission calculations based on various parameters like invoice amounts and salesperson performance.

  • Effective Pricing Strategy Evaluation: By incorporating Unit Price, Unit Price Ovrd, and Ext Amt measures, the data model allows for the evaluation of pricing strategies and their impacts on revenue generation and profitability.

  • Detailed Shipment Quantities Analysis: The model's inclusion of measures like Qty Shipped and Freight Amt enables in-depth analysis of shipment quantities and associated freight costs, aiding in optimizing logistics and supply chain processes.

  • Comprehensive Trade Discounts Examination: The data model provides the capability to analyze trade discount amounts through measures like Trade Disc Amt, helping businesses understand the impact of discounts on overall revenue and profitability.

Key Performance Indicators (KPIs)​

  • Act Comm Amt: Actual commission amount paid for the invoice.
  • Calc Comm Amt: Calculated commission amount based on the predefined commission rate.
  • Comm Base: Base amount used to calculate the commission.
  • Unit Cost: Cost per unit of the product.
  • Unit Price: Selling price per unit without any additional discounts or overrides.
  • Unit Price Ovrd: Overridden selling price per unit.
  • Ext Amt: Extended amount calculated by multiplying the quantity shipped by the unit price.
  • Freight Amt: Amount charged for freight or shipping.
  • Qty Shipped: Quantity of products shipped in the invoice.
  • Trade Disc Amt: Amount of trade discount applied to the invoice total.

Available Visualizations​

View NameDescription
Top 5 Sales PersonHighlights the top 5 salespersons by revenue.
InvoicesProvides overview of all invoice transactions.
Invoices (Satin Demo)Specific view for transactions with satin demo.