Buyer supplier measures

Measure Measure source Calculation
Add On Charge Total PurchaseOrder
Average Lines per PO Calculation POLineCount / POCount
Average Monthly Return Value Calculation If year level, ReturnValue / 12, If month level, ReturnValue / NumberOfDays
Average Monthly Returns Calculation If year level, ReturnCount / 12, If month level, ReturnCount / NumberOfDays
Average PO Lines per Day Calculation POLineCount / NumberOfDays
Average POs per Day Calculation POCount / NumberOfDays
Average Quantity per PO Line Calculation Quantity / POLineCount
Average Receipt Lines per Receipt Header Calculation ReceiptLineCount / ReceiptHeaderCount
Average Receipts per PO Calculation POLinesReceived / POCount
Average Return Line Value per Vendor Calculation ReturnValue / ReturnValue (all vendors)
Average Return Quantity per Vendor Calculation ReturnQuantity / ReturnQuantity (all vendors)
Average Unit Cost per Purchase Calculation EnteredUnitCost / POLineCount
Average Value per PO Line Calculation ExtendedAmount / POLineCount
Buyer Messages Count PurchaseOrderLine when related record in PurchaseOrderBuyerMessage exists
Canceled Line Count PurchaseOrderLine when CancelQuantity = Quantity
Canceled Service Amount PurchaseOrderLine when ItemType.Service and ServiceCode.Amount <> 0 = ServiceCancelAmount
Cancel Quantity PurchaseOrderLine
Cost Message Count MatchInvoiceMessage MessageType.Cost
Distribution Amount PurchaseOrderLineDistribution ReportCurrencyAmount.FunctionalAmount.EnteredCurrencyAmount
Entered Unit Cost PurchaseOrderLine
Entered Unit Cost Per Stock UOM PurchaseOrderLine when EnteredBuyUOMMultiplier not =0 then EnteredUnitCost / EnteredBuyUOMMultiplier
PO Line Extended Amount PurchaseOrderLine
Extended Receipt Value PurchaseOrderLine ReceivedQuantity * EnteredUnitCost
Extended Rejected Value PurchaseOrderLine RejectedQuantity * EnteredUnitCost
Invoiced PO Line Count PurchaseOrderLine when InvoiceDetailExists
Invoice Message Count MatchInvoiceMessage
Item Message Count MatchInvoiceMessage MessageType.Item
Item Average Cost ItemLocation If CreateDimensionElement = Y, then Average Cost
Item Backordered Quantity ItemLocation If CreateDimensionElement = Y, then Backordered Quantity
Item Backordered Value ItemLocation If CreateDimensionElement = Y, then Backordered Value
Item On Order Quantity ItemLocation If CreateDimensionElement = Y, then On Order Quantity
Item On Order Value ItemLocation If CreateDimensionElement = Y, then On Order Value
Item Stock On Hand Quantity ItemLocation If CreateDimensionElement = Y, then Stock on Hand Quantity
Item Current Inventory Value ItemLocation If CreateDimensionElement = Y, then Current Inventory Value
Landed Unit Cost PurchaseOrderLine
Lines Not Shipped Complete PurchaseOrderLine when ReceivedQuantity < Quantity
Lines Shipped Complete PurchaseOrderLine when ReceivedQuantity = Quantity
Manual Buyer Message Count PurchaseOrderLine when related record in PurchaseOrderBuyerMessage exists and BuyerMessageType.Manual
Matched PO Line Count PurchaseOrderLine when MatchedQuantity >= (Quantity - CancelQuantity)
Matched Quantity PurchaseOrderLine
Matched Quantity In Stock UOM PurchaseOrderLine EnteredBuyUOMMultiplier * MatchedQuantity
No Receipt Message Count MatchInvoiceMessage MessageType.NoReceiptLine
Number of Days Calculation Numer of days in range
Off Catalog Line Count Calculation POLineCount where ItemType = 'S' + POLineCount where ItemType = 'X'
Off Catalog Quantity Calculation Quantity where ItemType = 'S' + Quantity where ItemType = 'X'
Off Catalog Value Calculation POLineValue where ItemType = 'S' + POLineValue where ItemType = 'X'
Off Contract Line Count Calculation POLineCount - OnContractLineCount
Off Contract Quantity Calculation Quantity - OnContractQuantity
Off Contract Value Calculation POLineValue - OnContractValue
On Catalog Line Count Calculation POLineCount where ItemType = 'I' + POLineCount where ItemType = 'N'
On Catalog Quantity Calculation Quantity where ItemType = 'I' + Quantity where ItemType = 'N'
On Catalog Value Calculation POLineValue where ItemType = 'I' + POLineValue where ItemType = 'N'
On Contract Line Count PurchaseOrderLine when ContractLine entered
On Contract Quantity PurchaseOrderLine when ContractLine entered then Quantity - CancelQuantity
On Contract Value PurchaseOrderLine when ContractLine entered then (Quantity - CancelQuantity) * EnteredUnitCost
On Order Quantity PurchaseOrderLine Quantity - CancelQuantity - ReceivedQuantity
OnOrderValue PurchaseOrderLine (Quantity - CancelQuantity - ReceivedQuantity) * EnteredUnitCost
Open Order Quantity PurchaseOrderLine Quantity when Closed.No
Open PO Count PurchaseOrder when not Closed.Yes
Open PO Line Count PurchaseOrderLine when Closed.No
Open Purchase Amount PurchaseOrderLine When ItemType.Service then (QuantityToProcess - MatchedQuantity) * ((EnteredBuyUOMMultiplier / VendorPriceUOMMultiplier) * EnteredUnitCost) else (QuantityToProcess * VendorBuyUnitCost) - MatchedAmount - ServiceCancelAmount + ChargebackAmount
Percent Delivered to Correct Location Calculation POLinesDeliveredToCorrectLocation / POLineCount
Percent Electronically Transmitted POs Calculation POs Transmitted Electronically / PO Line Count
Percent Inventory Lines Calculation POLineCount where ItemType ='I' / POLineCount
Percent Non Stock Lines Calculation POLineCount where ItemType ='N' / POLineCount
Percent Order Quantity Off Contract Calculation (Quantity - OnContractQuantity) / Quantity
Percent Order Quantity On Contract Calculation OnContractQuantity / Quantity
Percent Order Value Off Contract Calculation (POLineValue - OnContractValue) / POLineValue
Percent Order Value On Contract Calculation OnContractValue / POLineValue
Percent PO Lines Off Contract Calculation (POLineCount - OnContractLineCount) / POLineCount
Percent PO Lines On Contract Calculation OnContractLineCount / POLineCount
Percent PO Lines Over Received Calculation POLinesOverReceived / [IFXI_BS_Measures:'POLineCount
Percent PO Lines w Buyer Messages Calculation BuyerMessagesCount / POLineCount
Percent PO Lines w Cost Messages Calculation CostMessageCount / POLineCount
Percent PO Lines w Invoice Messages Calculation InvoiceMessageCount / POLineCount
Percent PO Lines w PO Cost Messages Calculation POCostMessageCount / POLineCount
Percent PO Lines w Qty Messages Calculation QuantityMessageCount / POLineCount
Percent PO Lines w Quantity Changes Calculation Nbr PO Quantity Changes / PO Line Count
Percent PO Lines w Unit Cost Changes Calculation Nbr PO Unit Cost Changes / PO Line Count
Percent PO Lines without Changes Calculation Nbr PO Lines Without Changes / PO Line Count
Percent POs Not Via EDI Calculation POs Not Issued EDI / PO Line Count
Percent POs Transmitted EDI Calculation POs Issued EDI / PO Count
Percent POs w Changes Calculation POs With Changes / PO Count
Percent Received On Time Calculation ReceivedOnTime / POLineCount
Percent Service Lines Calculation POLineCount where ItemType ='S' / POLineCount
Percent Shipped Complete Calculation LinesShippedComplete / POLineCount
Percent Special Lines Calculation POLineCount where ItemType ='X' / POLineCount
Percent Undamaged Calculation (ReceivedQuantity - RejectedQuantity) / ReceivedQuantity
Percent Without Messages Calculation (POLineCount - InvoiceMessageCount) / POLineCount
Percent Without Vendor Returns Calculation (POLineCount - ReturnLineCount) / POLineCount
PO Cost Message Count MatchInvoiceMessage MessageType.Cost and MatchMessageOrigin.PoCost
PO Count PurchaseOrder
PO Line Change Count PurchaseOrderLine QuantityChangeCount + UnitCostChangeCount
PO Line Count PurchaseOrderLine
PO Lines Delivered To CorrectLocation PurchaseOrderLine when PurchaseOrderLine.ShipToLocation = LocalReleasedPORecLineShipToLocation
PO Lines Over Received PurchaseOrderLine when ReceivedQuantity > Quantity
PO Lines Received PurchaseOrderLine when ReceivedQuantity <= Quantity and (ItemType.Inventoried or ItemType.NonStock or ItemType.Special)
PO Lines Unreceived PurchaseOrderLine when ReceivedQuantity = 0 and (ItemType.Inventoried or ItemType.NonStock or ItemType.Special)
POs Issued EDI PurchaseOrder when IssueMethod.EDI
POs Not Issued EDI PurchaseOrder when not IssueMethod.EDI
POs Transmitted Electronically PurchaseOrder when IssueMethod.EDI or IssueMethod.Email or IssueMethod.Fax or IssueMethod not entered
Quantity PurchaseOrderLine
Quantity Change Count PurchaseOrderLine When audit log is Update and Quantity
Quantity In Stock UOM PurchaseOrderLine EnteredBuyUOMMultiplier * Quantity
Quantity Message Count MatchInvoiceMessage MessageType.Quantity
Quantity Received On Time PurchaseOrderLine when ReceivingActivityDate <= EarlyDeliveryDate then ReceivedQuantity
Quantity Shipped Complete PurchaseOrderLine ReceivedQuantity = Quantity then Quantity
Receipt Header Count PurchaseOrder Count of receipt headers when LocalReleasedPORecLineTotalsDone is not true and related PurchaseOrderReceiptLine exists
Receipt Line Count PurchaseOrderLine Sum of receipt lines when LocalReleasedPORecLineTotalsDone is not true and related PurchaseOrderReceiptLine exists
Receipt Quantity PurchaseOrderLine Sum of PurchaseOrderReceiptLine.EnteredReceivedQuantity when LocalReleasedPORecLineTotalsDone is not true and related PurchaseOrderReceiptLine exists
Received Late PurchaseOrderLine when ReceivingActivityDate > EarlyDeliveryDate
Received On Time PurchaseOrderLine When ReceivingActivityDate <= EarlyDeliveryDate
Received Quantity PurchaseOrderLine
Receiving Buyer Message Count PurchaseOrderLine When related PurchaseOrderBuyerMessage exist and BuyerMessageType.Manual
Rejected Quantity PurchaseOrderLine
Return Cancel Quantity VendorReturnLine
Number Of Returns VendorReturn
Header Credit Received VendorReturn
Entered Unit of Measure Multiplier VendorReturnLine
Return Line Count VendorReturnLine
Return Line Extended Amount VendorReturnLine ReturnQuantity * UnitCost
Return Loss Cost VendorReturn ReturnValue - CreditReceive
Number of Items Returned VendorReturnLine
Return Quantity In Stock UOM Calculation
Return Unit Cost VendorReturnLine when EnteredUOMMultiplier<> 0 then UnitCost / EnteredUOMMultiplier
Return Unit Cost Per Stock UOM Calculation
Header Return Value VendorReturn
Service Cancel Amount PurchaseOrderLine
Total Order Amount PurchaseOrder
Total Product Amount PurchaseOrder
Total Taxable Amount PurchaseOrder
Total Tax Amount PurchaseOrder
Unit Cost Change Count PurchaseOrderLine When audit log is Update and EnteredUnitCost
UnMatched PO Line Count PurchaseOrderLine When MatchedQuantity < (Quantity - CancelQuantity)
UnMatched Quanity PurchaseOrderLine Quantity - MatchedQuantity - CancelQuantity, if > 0