(IND) Post sales transactions with multiple taxes and charges

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

Note

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

You can post a purchase transaction or sales transactions with multiple taxes and charges. Indirect taxes, such as sales tax, service tax, VAT, and customs are levied, along with excise for a particular transaction.

The following are examples of combinations of multiple taxes:

  • Excise + VAT

  • Excise + Sales tax

The combination of the multiple taxes that are levied is in accordance with the Indian legal requirement. However, in Microsoft Dynamics AX, you can post multiple taxes with all combinations.

Example

The following is an example of a sales transaction when multiple taxes, excise, and VAT are levied.

A sales order line is created for an item. Two taxes, excise and VAT, are levied on the item. The sales order line amount is INR 10,000. Miscellaneous charge code is set up for freight for INR 1000 with the account combination of Ledger (Debit) – Ledger (Credit) in the Misc. charges code form, and attached to the sales order line. The record type selected on the Tax information tab is RG23A.

The formula for the calculation of excise is defined in the Formula designer form as shown in the following table.

Tax code/component

Taxable basis

Calculation expression

BED

Assessable value

AED

Assessable value

+[BED]

SED

Assessable value

+[BED]

E-Cess

Excl. line amount

+[SED]

SHE-cess

Excl. line amount

+[SED]

VAT

Line amount

+[BED]+ [AED] + [SED] + [E-cess] + [SHE cess]

The excise rate percentage for BED is 10 percent, AED is 5 percent, SED is 2 percent, E-Cess is 1 percent, SHE-cess is 1 percent, and VAT is 4 percent. The sales order is posted.

According to the example, the following types of excise and VAT are calculated.

Net amount + Miscellaneous charges = Assessable value

10,000 + 1000 = 11,000.00

BED = (11,000 * 10%) = 1100.00

AED = [(11,000 + 1100) * 5%] = 605.00

SED = [(11,000 + 1100) * 2%] = 242.00

E-cess = (242.00 * 1%) = 2.42

SHE-cess = (242.00 * 1%) = 2.42

VAT = [(10,000 + 1100 + 605 + 242 + 2.42 + 2.42) * 4%] = INR 478.07

The amount origin and the tax amounts calculated are displayed in the Temporary sales tax transactions form.

When the sales order is posted, the payable accounts of the tax components are credited with the related excise taxes and the VAT payable account is credited with the VAT amount. The RG23A Part I register is updated.

See also

(IND) Formula designer (form)

(IND) Temporary sales tax transactions (modified form)