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 |