Excise Price Calculation in Sales Order

Excise Duty Management  •  Article  •  4/29/2023  •  4 min

  1. Select the Search icon , enter Sales Orders, and then choose the related link.
    The Sales Orders page opens.

  2. Choose New.
    The Sales Order page opens.

  3. Enter the customer detail in the Customer No. field under the General FastTab.

  4. On the Lines FastTab, enter the Item and Quantity.

  5. Select the Location Code.

  6. On the Lines FastTab, go to Line > Related Information > Applied Sales Price and Discount.
    The Applied Sales Price and Discount page for the Sales Order opens.
    The Excise FastTab shows you the related information depending on the setup subject to excise and domestic/non-domestic trade.

    • Subject to Excise: The possible values for the field are Yes, No or <Blank> on the sales line.
    • Domestic Trade: This field value is either turned on/off based on the below table values.
    • Discount Based on Price Incl. Excise: This field value is either turned on/off based on the Excise Duty Setup.
    • Price Including Excise: This field value is either turned on/off based on the settings on the Price Includes Excise toggle on the Sales Price List or Sales Unit Price Incl. Excise toggle on the Excise Duty Setup.
    • New Price Including Excise: This field value is either turned on/off based on the situation (domestic and non-domestic) and the value of Subject to Excise.

    Domestic Trade

    Subject to Excise New Price
    No Excludes Excise
    Yes Includes Excise
    <Blank> Includes Excise

    Non-Domestic Trade

    Subject to Excise License New Price
    No Customer/Vendor has License Excludes Excise
    No Customs Tax Partner has License Includes Excise
    <Blank> Customer/Vendor has License Excludes Excise
    <Blank> Customs Tax Partner has License Includes Excise
    Yes Includes Excise
    • Start Price: The price selected from a price list or item and used based on the values in the Price Including Excise field with the options Price Including Excise or Price Excluding Excise.
    • Excise Amount: The value of the Trade Excise Amount of the Excise Line, based on the currency code of the Excise Version used for the trade excise amount calculation.
    • Price Including Excise: A calculated value, depending on the above parameters.
    • Price Excluding Excise: A calculated value, depending on the above parameters.
    • Discount Base Price: A calculated value, based on the value of Discount Based on Price including Excise and the Price Including or Excluding Excise.
    • Discount Amount based on Base Price: A calculated value, depending on the Discount Based Price.
    • New Price: A calculated value, depending on the above parameters and rounded based on the settings in the Excise Duty Setup.
    • New Net Price: A calculated value.
    • New Discount % based on New Price: A calculated value.


    The handling of the price and discount works the same with purchase documents also. Except when the starting price is taken from the item card (Last Direct Cost field) as there is no purchase price list available. Thus, this price follows the value of the New Price including Excise. It specifies

    • If the New Price including Excise results in the price including excise, then the last direct cost is also inclusive of excise.
    • If the New Price including Excise results in the price excluding excise, then the last direct cost is also exclusive of excise.