(IND) Define a formula to calculate customs duty [AX 2012]

Updated: November 15, 2012

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

You must define the formula to calculate customs duty for the item sales tax group.

The formula for customs tax codes are defined by using tax codes and miscellaneous charge codes. You must select the taxable basis for the calculation of customs duty for each tax code.

For example, suppose that you create a purchase order for items with a maximum retail price of INR 6,000. The taxable basis for the calculation of basic customs duty is the maximum retail price. The percentage of tax for each tax component is shown in the following table. The Price incl. tax check box in the Formula designer form is selected for the BCD, ACD, SUR, E-CESS, and SHE-CESS tax codes.

Tax code

Tax component

Percentage

Taxable basis

Calculation expression

Customs duty

BCD

BCD

10

Max. retail price

475.74(4757.37*10%)

ACD

ACD

10

Max. retail price

475.74 (4757.37*10%)

SUR

SUR

5

Max. retail price

+[BCD+ ACD]

285.45 (4757.37 +475.74+475.74 = (5708.85*5% = 285.45)

E-CESS

E-CESS

1

Excl. line amount

+[SUR]

2.85 (285.45*1%)

SHE-CESS

SHE-CESS

1

Excl. line amount

+[SUR]

2.85 (285.45*1%)

If the basis is maximum retail price, customs duty is calculated automatically using the following formula:

6000 = Basis + BCD + ACD + SUR +E-CESS + SHE-CESS

Basis = X

6000 = X + 0.10X + 0.10X + 0.06X + 0.0006X + 0.0006X

6000 = 1.2612X

X = 6000/1.2612

Price excluding tax = 4,757.37

E-CESS and SHE-CESS is calculated on the basis of the surcharge amount and the line amount is not considered in the calculation of customs duty.

NoteNote

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

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

    NoteNote

    For more information, see "Item sales tax groups (form)" in the Applications and Business Processes Help.

  2. Click Formula designer to set up a formula for taxes in the Formula designer form.

  3. Press CTRL+N on the Calculation tab to define the calculation expression for a specific customs tax code. The automatically generated priority ID for customs duty calculation is displayed in the ID field.

  4. Select the tax code to define the formula for in the Tax code field.

    NoteNote

    You cannot define a formula when you calculate customs duty using amount per unit.

  5. Select the basis to calculate tax from the following options in the Taxable basis field:

    • Line amount – Customs duty is calculated on the transaction line amount by using the calculation expression defined for the customs tax code.

    • Excl. line amount – Customs duty is calculated by using the calculation expression defined for the customs tax code.

    • Max. retail price – Customs duty is calculated on the maximum retail price of the item line by using the calculation expression defined for the customs tax code.

    • Assessable value – Customs duty is calculated on the assessable value calculated for an item by using the calculation expression defined for the customs tax code.

  6. Select the Price incl. tax check box if the taxable basis includes the tax amount.

    NoteNote

    This check box is selected automatically for custom tax codes with the maximum retail price as the taxable basis. You must select the Price incl. tax check box for the tax codes that have a taxable basis as excluding the line amount, and their customs duty calculation is dependent on the other tax codes with maximum retail price as taxable basis.

  7. Click the + button, button, * button, or / button to insert the calculation expression for the customs tax code in the Calculation expression field.

    NoteNote

    When the Price incl. tax check box is selected for a record, the calculation of tax that is based on the calculation expression should be in the reverse order.

  8. Use one of the following methods to add a custom tax code or a miscellaneous charge code to the Calculation expression field:

    • Click the Taxes tab or the Misc. charges code tab, right-click and select Add tax code or Add misc. charges code.

    • Double-click a code on the Taxes tab or Misc. charges code tab.

    • Move a code from the Taxes tab or Misc. charges code tab.

    NoteNote

    You must insert a calculation expression before each custom tax code.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: