(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.