In standard Microsoft Dynamics 365 for Finance and Operations the following price and discounts fields related to the Price and Margin Management solution are shown on an order line:
Field | Description | Remark |
Quantity | Order quantity | Both editable |
Unit |
Order unit from the released product |
Both editable |
Unit price |
Sales price per order unit of the released product or Price from sales trade agreement if found. Retail: Depending on retail discount parameter "Allow price adjustments to increase product price" prices from price adjustment are applied: No: the price from Price adjustment is price is applied when it's is lower than price from sales trade agreement or lower than base sales price of the released product when no sales trade agreement has been applied. Yes: the price from Price adjustment is applied instead of the price from the released product or sales trade agreement. Also on retail orders the price is already divided by the price qty. |
Non-retail: editable Retail: editable when Enable order price control is enabled AND Allow price adjust is activated on the released product. |
Discount |
Amount discount expressed in order unit per price quantity Non-retail: Discount amount from line discount sales trade agreement Retail: Total discount amount of all applied discounts |
Non-retail: editable Retail: non editable |
Discount percentage |
Non-retail: Total discount percentage from line discount sales trade agreement percentage 1 and 2 Retail: Not used |
Non-retail: editable Retail: non editable |
Price unit |
Non retail: Price quantity from the released product or applied trade agreement Retail: Always put to 1 by the system when calculating the retail prices and discounts |
Non-retail: editable Retail: non editable |
Multi line discount |
Amount discount expressed in order unit per price quantity Non retail: Discount amount from the multi line discount sales trade agreement Retail: not used |
Both editable |
Multi line discount percentage |
Non retail: Discount amount from the multi line discount sales trade agreement Retail: not used |
Both editable |
Manual discount amount |
Depending on the retail discount parameter "Manual line discount and system discount" the amount of discount compounded on top of will replace the system discounts |
Retail only |
Line amount |
Total net amount for the total quantity of the order line. When line amount is modified, unit price and all discount fields are cleared. The calculation formula between retail and non retail slightly different. |
Non retail: editable Retail: only editable when Enable order price control is not active. |
There is no field which represents the net price per unit per price quantity and there is also no field that shows the percentage of the total discount that is applied on the order line.
When you are negotiating a discount with the customer it is more easy to agree on a net price per unit or a total discount percentage instead.
To make it possible to enter a net price per unit or a total discount percentage the following modifications have been made to the sales order and quotation lines:
Field | Description | Remark |
Unit price |
For retail orders: the sales price is multiplied by the price quantity and the value is shown on the order line (instead of 1) |
Click here for more details |
Price unit |
This standard Microsoft Dynamics 365 for Finance and Operations has been renamed into Price quantity. |
Line + Multi line discount percentage |
Not visible on retail orders |
There is no parameter to activate this behavior. |
Multi line discount amount |
Not visible on retail orders |
There is no parameter to activate this behavior. |
Manual discount percentage |
We changed the behavior of this standard Microsoft Dynamics 365 for Finance and Operations field. This field is only visible when the retail discount parameter "Manual line discount and system discount" is set to compounded on top of system discounts. When you enter a value in this field the field "Manual discount amount" this field will be set to 0 and become non editable. You either give an additional percentage OR an additional amount of discount on top of the system discounts. On modify the fields "Discount", "Net price per unit", "Line amount", "Total discount percentage" are updated. |
Reason: when this parameter is set to replace the system discounts our new field total discount percentage will become editable and can be used to change the discount percentage for the order line. |
Manual discount amount
|
New field in which you can enter the discount amount (per order unit per price quantity) When you enter a value in this field and the retail discount parameter "Manual line discount and system discount" is set to compounded on top of system discounts, the field Manual discount percentage will become none editable. You either give an additional percentage OR an additional amount of discount on top of the system discounts. On modify the fields "Discount", "Net price per unit", "Line amount", "Total discount percentage" are updated. |
There is no parameter to activate this behavior. This field is only visible on retail orders. |
Net price per unit field |
New field which represents the value of the line amount divided by the sales quantity (per order unit per price quantity). When modified: Non retail: all discount percentages and multi line discount amounts will are cleared and the discount amount, total discount percentage and line amount are updated. Retail: discount amount and line amount are updated, the system discounts are deleted and the discount is marked as manual discounts. It is not possible to enter a net price per unit higher than the unit price as retail orders do not allow the discount to become negative. If retail discount parameter "Manual line discount and system discount" is set to compounded on top of system discounts it will not be possible to enter a net price per unit higher than the net price that's calculated based on the system discounts. As you compound you can only give additional discounts. |
There is no parameter to activate this feature. |
Total discount percentage |
A new field which represents the percentage total discount expressed against the unit price. ((Sales qty*ROUND(unit price/price qty);2) - line amount)/ (Sales qty*ROUND(unit price/price qty);2) When modified: Non-retail: discount amount and multi line discount percentage and amount are set to 0 and net price per unit, discount percentage, line amount and discount percentage are updated. Retail: the field manual discount will be disabled, discount amount and line amount are updated, the system discounts are deleted and the discount is marked as manual discount. |
For non-retail there is no parameter to activate this feature.
Retail: This field can only be modified when the retail discount parameter "Manual line discount and system discount" is set to replace the system discounts. |
Locked |
A new field which can be used to prevent recalculation of the prices and discounts. Price and discounts are recalculated when you modify the quantity or dimensions. On retail orders these order lines are also excluded from being recalculated when the function "Recalculate" on the order header is executed. These order lines will also be ignored when the system is determining quantity based discounts, threshold or mix and match discounts. |
Line