(IND) Post invoice transactions for excisable goods using a Purchase subscription [AX 2012]

Updated: November 8, 2012

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


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

The invoice for excisable goods transaction is posted using Subscription as the purchase type.

For example, a subscription order is created for 100 quantities for an item. The unit price is INR 90 and the Maximum Retail Price (MRP) is INR 100. The line amount is INR 9,000. The excise record that is selected on the Tax information tab is RG23A. The claim percentage for RG23A is set as 50 percent in the Claim percentage form. An abatement of 40 percent is defined in the Item sales tax group form. The MRP is INR 6,000 after availing the abatement.

An invoice journal is created in the invoice register. The credit amount in the journal line is 9000, and the maximum retail price of the item is 6000. The excise record type that is selected is RG23C. The claim percentage for CENVAT is set as 50% in the Claim percentage form.

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

Tax code

Taxable basis

Calculation expression


Max. retail price


Max. retail price


Max. retail price

+[BED]+ [AED]


Excl. line amount


SHE- cess

Excl. line amount


The Price incl. tax check box is selected for all the tax components in the Formula designer form. The excise rate percentage for BED is 10%, AED is 10%, SED is 5%, E-Cess is 1% and SHE cess is 1%. The journal line is validated and posted.

According to this example, excise is calculated in the Invoice register journal as follows:

BED = (4,757.37 * 10%) = 475.74

AED = (4,757.37 * 10%) = 475.74

SED = (5,708.85 * 5 / 100) = 285.44; (4,757.37 + 475.74 + 475.74 =5,708.85)

E-cess = (285.44*1%) = 2.85

SHE-cess = (285.44 * 1%) = 2.85

Max. retail price = Tax basis + Excise = 4,757.37 + 1242.63 = 6000


The tax basis and the taxes are calculated automatically by the Microsoft Dynamics AX application based on the formula designer.

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

An excise duty of INR 1,242.63 is calculated. When the purchase order is posted, the recoverable accounts of the tax components are debited with the 50 percent of the related excise taxes, and the RG23A deferred accounts of the tax components are debited with the remaining 50 percent of the related excise taxes. The RG23A Part I register is updated with the quantity and the RG23A Part II register is updated with the excise tax amount.

  1. Click Accounts payable > Common > Purchase orders > All purchase orders.

  2. Press CTRL+N to create a new purchase order.

  3. Select Subscription in the Purchase type field.

  4. The procedure for invoicing a purchase subscription is similar to invoicing a purchase order.


    For more information, see "Post a purchase order" in the Applications and Business Processes Help.

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