(IND) Transfer opening balance in excise registers using tax journals [AX 2012]

Updated: February 4, 2014

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

Create a tax journal to complete the following tasks:

  • Transfer the opening balance of the excise components to the ledger accounts.

  • Post the adjustment entries, such as correction or modification of the excise recoverable amounts or payable amounts, between the tax components.

Refer to the following table for the form name and locators to transfer the excise balance in the RG registers.



Form name and locator

Journal entries

RG register

To transfer the excise balance in the RG registers (By Value).

Adjustment transaction

General journal form (Using the Tax journal)

Click General ledger > Journals > General journal. Click Lines, and then click Functions> Create tax journal.

Account type – Ledger (Debit)

Offset account type – Ledger (Credit)

To transfer the excise-balance in the RG register Part I or Daily Stock Accounting (DSA) register (Quantity-wise)

Movement journal form

Click Inventory management > Journals > Item transactions > Movement. Click Lines.



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

  1. Click General ledger > Journals > General journal.

  2. Select a journal and click the Lines button.

  3. Click Functions > Create tax journal.

  4. Select the Excise in the Tax type field.

  5. Select the tax ledger posting group for excise in the Tax ledger posting group field.

  6. Select the excise registration number in the Registration number field.

  7. Enter the date the opening balance amounts are posted on in the To date field.

  8. Press CTRL+N to create a new line.

  9. Select the excise tax component that the opening balance amount must be transferred to in the Tax component field.

  10. Select the ledger account that the opening balance amount is posted from in the Account field. If you enter a negative amount, the tax amount is deducted from the ledger account you specify in this field. If you enter a positive amount, the tax amount is added to the ledger account.

  11. Enter the opening-balance amount in the Amount field. Enter a negative value for the credit type amount and a positive value for the debit type amount.

  12. Select the tax code that the excise tax component is attached to in the Tax code field.

  13. Click the Transfer button to transfer the tax journal line to the Journal voucher form.

  14. View or modify the tax code selected in the Create tax journal form, which is displayed in the Sales tax code field on the General tab for the journal voucher line.

  15. Select the ledger account that the opening balance transaction is posted to in the Offset account field.

  16. Click the Tax information tab and select the excise record that the opening balance amount is updated to in the Excise record type field.

  17. Validate and post the journal. The excise register is updated with the journal details and the tax component amount.

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