| UoM on order line is same as | Formula to calculate excise duty amount on line |
|---|---|
| Duty UoM | Duty rate x Quantity on order line |
| Base unit |
The duty conversion factor is set on the Excise duty tab in the Stock items (IN202500) window. |
| Sales unit or other UoM |
The conversion factor from the UoM on the line to the item’s base unit is set in the unit conversion table on the General settings tab in the Stock items (IN202500) window. Depending on the operator set there, the formula contains multiplication or division by this conversion factor. |
| Window | Action |
|---|---|
| Duty types (EF204000) | Click |
| Duty groups (EF205000) |
|
| Duty rates (EF207000) |
|
| Duty items (EF208000) |
|
| Column | Description |
|---|---|
| Duty type | The duty type ID. |
| Duty type description | The duty type description. |
| Element | Description |
|---|---|
| Duty type | A two-letter code. The duty type is the ID for the duty type, usually the foundation (e.g. product type) of the duty. |
| Duty group | The division into different duty groups within the individual duty type is a division of different rates within the same duty. |
| Duty group description | A description of the Duty group. |
| Unit | The unit of measure for the Duty group, e.g. litre, kg. |
| Calculation rule | Use these alternatives to select the rule to calculate the Excise duty for the Duty type. Alternatives:
Currently, only alcohol uses the Multiple factors calculation rule. Example Factor 1 can be Piece. Conversion factor can be 20 kg/piece. Example Factor 2 can be Volum% (used for selling alcohol). |
| Column name | Description |
|---|---|
| Start date | The date when the duty will start to take effect. |
| Duty rate | The fee rate. |
| Customer class | Customer class for the duty rate (optional). |
| Deduction % | The deduction in per cent. |
| Max. amount | The maximum amount that the tax can calculate. |
| Tax free | This check mark indicates when used that the types of goods are not taxed. |
| Column name | Description |
|---|---|
| Fee additional code | An additional code for the fee. |
| Additional code description | A description of the Fee additional code. |
| Type |
|
| Factor | Factor alternatives:
Note
If you receive returns from a combination of customers, some subject to excise duty and some not subject to excise duty, you must enter return Type 0 and Type -1.
|
| Column | Description |
|---|---|
| Duty type | The duty type ID. |
| Duty type description | The duty type description. |
| Duty group | The duty group ID. |
| Duty group description | The duty group description. |
| Item ID | The ID of the item. |
| Description | The description of the item. |
| Element | Description |
|---|---|
| Excise duty factor | The excise duty factor, which is 0 for sales and returns excluded from excise duty. |
| Period | The month you want to display the sales and returns for. |
| Column | Description |
|---|---|
| Excise duty type | The excise duty type ID. |
| Excise duty type description | The excise duty type description. |
| Excise duty group | The excise duty group ID. |
| Excise duty group description | The excise duty group description. |
| Sum excise duty quantities | The sum of all the item’s quantities that have this type/group combination, expressed in the duty UoM. |
| Excise duty UoM | The duty rate unit of measure used when calculating the duty. |
| Invoice customer location | The customer’s invoiced location ID. |
| Invoice customer location postcode | The postcode for the invoiced customer location. |
| Invoice customer location city | The city for the invoiced customer location. |
| Excise duty factor | The excise duty factor, which is 0 for sales and returns excluded from excise duty. |
| Sale/return | The transaction type of the quantities on the line, which can be one of the following:
|
| Element | Description |
|---|---|
| Excise duty factor | The excise duty factor, which can be one of the following options:
|
| Period | The month you want to display the sales and returns for. |
| Column | Description |
|---|---|
| Excise duty type | The excise duty type ID. |
| Excise duty type description | The excise duty type description. |
| Excise duty group | The excise duty group ID. |
| Excise duty group description | The excise duty group description. |
| Sum excise duty quantities | The sum of all the item’s quantities that have this type/group combination, expressed in the duty UoM. |
| Excise duty UoM | The duty rate unit of measure used when calculating the duty. |
| Sum excise duty amounts | The sum of all the excise duty amounts for this type/group combination. |
| Excise duty factor | The factor indicates whether the excise duty amount is to be paid or to be reimbursed. It can be one of the following options:
|