(IND) Set up item excise tax groups

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

You can attach a tax code that is created for excise to an item tax group. You also can indicate how the excise tax must be calculated for each item.

Note

This topic has not been fully updated for Microsoft Dynamics AX 2012 R2.

  1. Click General ledger > Setup > Sales tax > Item sales tax groups..

  2. Type a short code or identification for the item tax group in the Item sales tax group field and the name of the item tax group in the Description field.

  3. Click the Setup tab and select the excise tax code in the Sales tax code field.

  4. Enter other required information, as needed.

  5. Select the Load on inventory check box to indicate that the excise tax amount must be loaded on inventory.

  6. Specify the percentage of tax amount that must be loaded on inventory in the Load on inventory % field.

  7. Click Formula designer to open the Formula designer form, where you can create or update the formulas for the calculation of excise.

Refer to the following examples for defining the calculation expression for excise components.

Example 1

Tax code field

Taxable basis field

Calculation expression field

BED

Line amount

AED

Excl. line amount

+[BED]

Example 2

Tax code field

Taxable basis field

Calculation expression field

BED

Max. retail price

AED

Max. retail price

SED

Max. retail price

+[BED]+ [AED]

E-Cess

Excl. line amount

+[SED]

SHE cess

Excl. line amount

+[SED]

See also

(IND) Formula designer (form)

(IND) Item sales tax groups (modified form)

(IND) Setting up excise tax groups and item tax groups