Product documentation
In This Topic
    Show and edit total discount % and net price per unit on order lines
    In This Topic

    In standard Microsoft Dynamics 365 for Finance and Operations the following price and discounts fields related to the Dynamics 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