How to: Calculate Excise Tax for Maximum Retail Price Using Sales Documents

You can calculate excise tax for Maximum Retail Price (MRP) using a sales order or a sales invoice. The following procedure describes how to calculate excise tax using a sales order, but the same steps also apply to using a sales invoice.

To calculate excise tax for maximum retail price using a sales order

1. In the Search box, enter Sales Orders, and then choose the related link.

2. On the Home tab, choose New.

3. On the General FastTab, fill in the fields as described in the following table.

   Field	Description
   No.	The sales order number.
   Sell-to Customer No.	The customer number for which the excise business posting group must be defined.
   Structure	The structure for the excise tax to be attached to the sales order. For more information, see Structure Header Table and How to: Set Up Tax or Charge Groups and Structures.
   External Document No.	The external document number that refers to the customer’s numbering system.

4. On the Lines FastTab, fill in the fields as described in the following table.

   Field	Description
   Type	Specify Item to indicate that the line contains an inventory item.
   No.	The item number for which the maximum retail price details are defined in the Item Card window or the Sales Prices window. For more information, see Item Card Window and Sales Prices Window
   Quantity	The number of units.
   Unit Price Excl. VAT	The direct unit cost of the item, excluding VAT. The amount entered here is automatically displayed in the Line Amount Excl. VAT field.

5. On the Shipping FastTab, in the Location Code field, select the location code for the customer.

6. On the Actions tab, in the Functions group, choose the Calculate Structure Values button.

7. To view the calculated excise tax amount, on the Navigate tab, in the Order group, choose Statistics. For more information, see Sales Order Statistics.

8. Choose the OK button.

9. On the Actions tab, in the Posting group, choose Post.

10. In the dialog box, select one of the following options:

    • Ship

    • Invoice

    • Ship and Invoice

11. Choose OK.

See Also

Tasks

How to: Set Up Excise Tax for Maximum Retail Price
How to: Calculate Excise Tax for Maximum Retail Price Using Transfer Orders

Concepts

VAT Overview
Assessable Value
Excise Tax Overview

Other Resources

Sales Header Table
Sales Line Table
Sales Order Window
Sales Invoice Header Table
Sales Invoice Line Table
Sales Order Statistics Window
Posting Sales Orders
Item Card Window
Sales Prices Window