Differences

This shows you the differences between two versions of the page.

adminhelp:quotesadministration:quote_2.0:quote_fields_and_calculations:calculation_order_for_quote_2.0:quantity [2018/05/04 09:40]
mnikolic created
adminhelp:quotesadministration:quote_2.0:quote_fields_and_calculations:calculation_order_for_quote_2.0:quantity [2018/06/01 09:12] (current)
mnikolic
Line 1: Line 1:
 ====== Quantity ====== ====== Quantity ======
-  * Item ExtendedListPrice +^ Calculation ^ Description ^ Formula ^ 
-  * Item ExtendedAmount +|**Item NRC Extended List Price**|Calculates item NRC extended list price from item NRC list price and quantity. |Item.ExtendedListPrice = Item.ListPrice * Item.Quantity| 
-  * Item ExtendedCost +|**Item NRC Extended Amount**|Calculates item NRC extended amount from item net price and quantity. |Item.ExtendedAmount = Item.NetPrice * Item.Quantity| 
-  * Item DiscountAmount from DiscountPercent +|**Item NRC Extended Cost**|Calculates item NRC extended cost from item NRC cost and quantity. |Item.ExtendedCost = item.Cost * item.Quantity| 
-  * Product type Net Price +|**Item NRC Discount Amount (from NRC discount percent)**|Calculates item NRC discount amount from NRC discount percent. NRC discount amount also includes item quantity. |Item.DiscountAmount = Item.ListPrice * Item.Quantity * Item.DiscountPercent / 100| 
-  * Product type list price +|**Product Type NRC Net Price**|Calculates NRC net price as a sum of all item extended amounts. |NetPrice = Sum(Item.ExtendedAmount)| 
-  * Product type discount amount +|**Product Type List Price**|Calculates NRX extended list price as a sum of all item extended list prices. |ListPrice = Sum(Item.ExtendedListPrice)| 
-  * Product type discount percent +|**Product Type Discount Amount**|Calculates NRC discount amount from product type NRC net price. |ProductType.DiscountAmount = ProductType.ListPrice - ProductType.NetPrice| 
-  * Product type Cost +|**Product Type NRC Discount Percent**|Calculates product type NRC discount percent from product type NRC discount amount. |ProductType.DiscountPercent = 100 * ProductType.DiscountAmount / ProductType.ListPrice| 
-  * Product Model Price +|**Product Type NRC Cost**|Calculates NRC extended cost as a sum of all item NRC extended costs. |Cost = Sum(Item.ExtendedCost)| 
-  * Total ListPrice +|**Product Type Product Model Price**|Calculates product model price by multiplying quantity by product model price. |ProductType.ProductModelPrice = Sum(Item.Quantity * Item.ProductModelPrice)| 
-  * Total NetPrice +|**Total NRC List Price**|Calculates total NRC extended list price as a sum of all item extended list prices. |Totals.ListPrice = Sum(Item.ExtendedListPrice)| 
-  * Total Amount +|**Total NRC Net Price**|Calculates total NRC extended amount as a sum of all item extended amounts. |Totals.NetPrice = Sum(Item.ExtendedAmount)| 
-  * Item MrsExtendedListPrice +|**Total Amount**|Calculates total amount as a sum of all item MRC extended amounts. |Totals.Amount = Totals.NetPrice| 
-  * Item MrcExtendedAmount +|**Item MRC Extended List Price**|Calculates item MRC extended list price from item MRC list price and quantity. |Item.MrcExtendedListPrice = Item.MrcListPrice * Item.Quantity| 
-  * Item MrcExtendedCost +|**Item MRC Discount Percent (from MRC Extended Amount)**|Calculates item MRC discount percent from item MRC extended amount. |Item.MrcDiscountPercent = 100 - 100 * Item.MrcExtendedAmount / Item.MrcListPrice * Item.Quantity| 
-  * Product type Mrc Net Price +|**Item MRC Extended Cost**|Calculates item MRC extended cost from item MRC cost and quantity. |Item.MrcExtendedCost = Item.MrcCost * Item.Quantity| 
-  * Product type Mrc List Price +|**Product Type MRC Net Price**|Calculates MRC extended amount as a sum of all item MRC extended amounts. |ProductType.MrcNetPrice = Sum(Item.MRCExtendedAmount)| 
-  * Product type Mrc Discount Amount +|**Product Type MRC List Price**|Calculates product type MRC list price as a sum of all item MRC extended list prices. |ProductType.MrcListPrice = Sum(Item.MRCExtendedListPrice)| 
-  * Product type Mrc Discount Percent +|**Product Type MRC Discount Amount**|Calculates MRC discount amount from MRC net price. |ProductType.MrcDiscountAmount = ProductType.MrcListPrice - ProductType.MrcNetPrice| 
-  * Product type Mrc Cost +|**Product Type MRC Discount Percent**|Calculates product type MRC discount percent from product type MRC discount amount. |ProductType.MrcDiscountPercent = ProductType.MrcDiscountAmount / ProductType.MrcListPrice| 
-  * Total MrcListPrice +|**Product Type MRC Cost**|Calculates MRC extended cost as a sum of all item MRC extended costs. |ProductType.MrcCost = Sum(Item.MRCExtendedCost)| 
-  * Total MrcNetPrice +|**Total MRC List Price**|Calculates item total MRC extended list price as a sum of all item MRC extended list prices. |Totals.MrcListPrice = Sum(Item.MRCExtendedListPrice)| 
-  * Total MrcAmount +|**Total MRC Net Price**|Calculates item total MRC extended amount as a sum of all item MRC extended amounts. |Totals.MrcNetPrice = Sum(Item.MRCExtendedAmount)| 
-  * Total product discount amount +|**Total MRC Amount**|Calculates total MRC amount as a sum of all item MRC extended amounts. |Totals.MrcAmount = Totals.MrcNetPrice| 
-  * Average Product Discount Percent +|**Total Product Discount Amount**|Calculates item total NRC extended amount from total net price. |Totals.ProductDiscountAmount = Totals.ListPrice - Totals.NetPrice| 
-  Total mrc product discount amount +|**Total Average Product Discount Percent**|Calculates item total NRC discount percent from total product discount amount. |Totals.AverageProductDiscountPercent = 100 * Totals.ProductDiscountAmount / Totals.ListPrice| 
-  * Average Product Mrc Discount Percent +|**Total MRC Product Discount Amount**|Calculates item total MRC extended amount from total MRC net price. |Totals.MrcProductDiscountAmount =  Totals.MrcListPrice - Totals.MrcNetPrice| 
-  * Total Cost +|**Total Average MRC Product Discount Percent**|Calculates item total MRC discount percent from MRC product discount amount. |Totals.AverageMrcProductDiscountPercent = 100 * Totals.MrcProductDiscountAmount / Totals.MrcListPrice| 
-  * Item Gross Margin Percent +|**Total Cost**|Calculates item total NRC extended cost as a sum of all item extended costs. |Totals.Cost = Sum(Item.ExtendedCost)| 
-  * Total Product Model Price +|**Total MRC Cost**|Calculates total MRC extended cost as a sum of all item MRC extended costs. |Totals.MrcCost = Sum(Item.MRCExtendedCost)| 
-  * Item Mrc Gross Margin Percent +|**Item MRC Gross Margin Percent**|Calculates item MRC gross margin percent from item MRC extended amount and item MRC extended cost. |Item.MrcGrossMarginPercent = 100 * (Item.MrcExtendedAmount - Item.MrcExtendedCost) / MrcExtendedAmount| 
-  * Product Type Mrc Gross Margin Percent +|**Item NRC Gross Margin Percent**|Calculates item NRC gross margin percent from item NRC extended amount and item NRC extended cost. |Item.GrossMarginPercent = 100 * (Item.ExtendedAmount - Item.ExtendedCost) / Item.ExtendedAmount| 
-  Product Type Gross Margin Percent +|**Total Product Model Price**|Calculates total NRC product model price from item product model price and quantity. |Totals.ProductModelPrice = Sum(Item.Quantity * Item.ProductModelPrice)| 
-  Total Average Gross Margin Percent +|**Product Type Gross Margin Percent**| Calculates NRC manufactures gross margin from product type net price. |ProductType.GrossMarginPercent = 100 * (ProductType.NetPrice - ProductType.Cost) / ProductType.NetPrice| 
-  * Total Average Mrc Gross Margin Percent+|**Total Average Gross Margin Percent**|Calculates total average gross margin percent from total net price and total cost. |Totals.GrossMarginPercent = 100 * (Totals.NetPrice - Totals.Cost) / Totals.NetPrice| 
 +|**Product Type MRC Gross Margin Percent**|Calculates MRC manufactures gross margin from product MRC net price. |ProductType.MrcGrossMarginPercent = 100 * (ProductType.MrcNetPrice - ProductType.MrcCost) / ProductType.MrcNetPrice| 
 +|**Total Average MRC Gross Margin Percent**|Calculates total MRC manufactures gross margin from MRC net price. |Totals.MrcGrossMarginPercent = 100 * (Totals.MrcNetPrice - Totals.MrcCost) / Totals.MrcNetPrice|
You are here: CallidusCloud CPQ Online HelpAdmin Page HelpQuotes AdministrationQuote 2.0Managing CalculationsOrder of Calculations when Changing Quote Field ValuesQuantity