This shows you the differences between two versions of the page.
Link to this comparison view
adminhelp:quotesadministration:quote_2.0:quote_fields_and_calculations:calculation_order_for_quote_2.0:list_price [2018/06/01 09:04] mnikolic |
— (current) |
- | ====== List Price ====== | + | |
- | ^ Calculation ^ Description ^ Formula ^ | + | |
- | |**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 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| | + | |
- | |**Item NRC Net Price**|Calculates item NRC net price from item discount percent. |item.NetPrice = item.ListPrice * (1 - item.DiscountPercent / 100)| | + | |
- | |**Item NRC Extended Amount**|Calculates item NRC extended amount from item net price and quantity. |Item.ExtendedAmount = Item.NetPrice * Item.Quantity| | + | |
- | |**Product Type List Price**|Calculates NRX extended list price as a sum of all item extended list prices. |ListPrice = Sum(Item.ExtendedListPrice)| | + | |
- | |**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**|Calculates NRC discount amount from product type NRC net price. |ProductType.DiscountAmount = ProductType.ListPrice - ProductType.NetPrice| | + | |
- | |**Product Type NRC Discount Percent**|Calculates product type NRC discount percent from product type NRC discount amount. |ProductType.DiscountPercent = 100 * ProductType.DiscountAmount / ProductType.ListPrice| | + | |
- | |**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 NRC Net Price**|Calculates total NRC extended amount as a sum of all item extended amounts. |Totals.NetPrice = Sum(Item.ExtendedAmount)| | + | |
- | |**Total Amount**|Calculates total amount as a sum of all item MRC extended amounts. |Totals.Amount = Totals.NetPrice| | + | |
- | |**Total Product Discount Amount**|Calculates item total NRC extended amount from total net price. |Totals.ProductDiscountAmount = Totals.ListPrice - Totals.NetPrice| | + | |
- | |**Total Average Product Discount Percent**|Calculates item total NRC discount percent from total product discount amount. |Totals.AverageProductDiscountPercent = 100 * Totals.ProductDiscountAmount / Totals.ListPrice| | + | |
- | |**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**|Calculates NRC manufactures gross margin from product type net price. |ProductType.GrossMarginPercent = 100 * (ProductType.NetPrice - ProductType.Cost) / ProductType.NetPrice| | + | |
- | |**Total MRC Gross Margin Percent**|Calculates total MRC manufactures gross margin from MRC net price. |Totals.MrcGrossMarginPercent = 100 * (Totals.MrcNetPrice - Totals.MrcCost) / Totals.MrcNetPrice| | + | |