Purchasing¶

Overview¶

The Purchasing capability covers procurement analytics including vendor spend, purchase invoices, credit memos, and open orders for complete supply chain visibility.

Semantic Model Tables¶

Dimensions¶

Table	Description
Vendor	Vendor master — name, business posting group, country/region, payment terms, and vendor classification
Item	Shared with Sales and Projects — item number, description, category, posting groups, and gross/net weight
Currency	Currency master from BC — ISO code, description, and exchange rate attributes. Shared with Sales and Finance
Unit Of Measure	Unit of measure definitions — code and description for quantity standardization across transactions. Shared with Sales and Inventory

Facts¶

Each transaction type uses a dim/fact pair: the singular-name table provides transaction details; the plural-name table hosts the DAX measures.

Dim Table	Fact Table	Description
Purchase Invoice	Purchase Invoices	Posted purchase invoice lines — quantity, direct cost, line amount, and discount
Purchase Credit Memo	Purchase Credit Memos	Posted credit memo lines — return quantities and credit amounts
Purchase Order	Purchase Orders	Open purchase order lines — backlog quantities and amounts

The Purchasing table is a measure wrapper that provides combined invoice + credit totals.

Key Measures (11)¶

Category	Measures
Invoice	Number of Purchase Invoices, Purchase Invoice Amount, Purchase Quantity Invoiced
Credit	Number of Purchase Credits, Purchase Credit Amount, Purchase Quantity Credited
Total	Purchase Amount, Purchase Quantity, Purchase Line Discount, Purchase Cost, Purchase Amount % of Total

Purchase Order Measures (15)¶

Category	Measures
Order	Number of Purchase Orders, Purchase Quantity Ordered, Purchase Order Amount, Purchase Order Amount Incl. VAT, Purchase Order Line Discount, Purchase Order Cost
Backlog	Purchase Order Backlog Quantity, Purchase Order Backlog Amount Incl. VAT, Purchase Order Backlog Amount
Progress	Purchase Order Received Not Invoiced Quantity, Purchase Order Received Not Invoiced Amount, Purchase Order Received Not Invoiced Amount Incl. VAT, Purchase Order Quantity Received, Purchase Order Received %, Purchase Order Invoiced %

Use Cases¶

Vendor spend analysis — Total procurement by vendor, item category, and period
Purchase pipeline — Open purchase orders, expected deliveries, and backlog amounts
Vendor credit tracking — Credit memos and return patterns by vendor
Procurement trends — Cost changes and volume patterns over time
Multi-company consolidation — Compare purchasing across companies