A country-specific update for India is available to provide the functionality of Excise phase I feature in Microsoft Dynamics AX 2012 R2

Introduction

Title: Assessable Value on Stock Transfer Order

This article describes a country-specific update for India to provide the functionality to enter an Assessable Value on the Stock transfer order so that the excise duty can be calculated on the basis of Assessable Value in Microsoft Dynamics AX 2012 R2.

Computation of Excise duty on the basis of Assessable value in stock transfer order, if the basis of calculating the Excise is Assessable Value in the formula designer of the selected Item sales tax group.

• Assessable value field has been introduced in Stock transfer order lines which is equal to the Net Amount (Quantity * Unit price).

• Unit price initially populate on the basis of price type defined in Stock transfer order line and Price type method defined in Item master.

• Excise duty will be calculated on the basis of Assessable Value, if the basis of calculating the Excise is Assessable Value in the formula designer of the selected Item sales tax group. If the basis of calculating the Excise is not an Assessable Value in the formula designer of the selected Item sales tax group then the standard behavior of AX shall work i.e. Excise duty will calculate on Net Amount.

• User can check the Excise duty based on Assessable value.

• Assessable value field is editable, user can change the value if required, and Excise amount will get re-calculated on the basis of changed Assessable value.

Title: Excise Duty on Imported Goods

This article describes a country-specific update for India that is available to enhance Excise functionality wherein if the goods are imported in Microsoft Dynamics AX 2012 R2. Then excise duty calculated from the system should be able to adjust in Indian Currency item wise and also the assessable value can be entered in Indian currency.

Assessable value in Company Currency field has been added in Purchase Import Order line which will be initially populated with "Assessable value" in foreign currency multiplied by custom exchange rate.

Title: Customer Return of goods Register

This article describes a country-specific update for India that is available to maintain the separate register Annexure-58 for recording the goods returned from customers in Microsoft Dynamics AX 2012 R2.

"Annexure-58" a new register introduced under General Ledger > Inquiries > Tax > India posted tax > Excise > Annexure 58 for recording the Excisable goods that are returned from customers for repair, refining, reconditioning and then re-dispatched to Customer after repair, refining and reconditioning.

Title: RG DSA Register

This article describes a country-specific update for India that is available for the RG 23 A & C Part II Registers to be displayed in Summary of Total Tax amount in single voucher but user should able to abstract tax component details of transactions. User should also need to specify the Item as By Product and update the RG registers.

RG23A & RG23C Part II to be displayed in summary with total tax amount of tax components. User can view details of transaction tax component wise.
RG23A & RG23C Part I to be displayed in summary item wise, day wise details of transactions.

Scrap or loss of raw material are displayed separately in RG23A & RG23C Part I register.

Damage or expiry of Finished goods quantity to be updated in DSA register.

Title: Gate Entry Management

This article describes a country-specific update for India that is available to provide the facility to record gate entry for the goods entering/exiting from the organization's premises. Gate Entry helps in audit trail and to keep the record of the gate entries (Inward/Outward) of the physical goods through Purchase Order/Sales Order/Return Order/Transfer Orders.

The Gate Entry functionality covers keeping record of the Inward and outward gate entries of the physical goods from / to each site. The functionality is parameterized on the basis of checkbox "Enable gate management" in form (Inventory and warehouse management > Setup > inventory and warehouse management parameters). User can check this check – box to enable Gate Entry Management feature.

Title: Excise Invoice

This article describes a country-specific update for India that is available to generate Excise invoice by manufacturer and trader for sales ,transfer and return of goods in Microsoft Dynamics AX 2012 R2.

An option provide to generate an Excise invoice report for both Manufacturer and Trader whenever there is sales of excisable goods, transfer of excisable goods from one location to another or return of excisable goods to the vendor.

An option provide to print either warehouse address or company address in Excise invoice report for sales order, stock transfer order or purchase returned order.

An Excise invoice report consist all required details related to excise duty, sales tax, service tax, charges, date and time of removal of goods, registration number, address of the Central Excise Division, name of the consignee, description, classification, Packing slip along with Transporter details which gets populated when Gate entry is attached to the packing slip.

More information

Assessable Value on Stock Transfer Order:

Process details:

1. Go to Inventory and warehouse management > Periodic > Transfer order.

2. Create a new stock transfer order.

3. Enter From warehouse, To warehouse, Item, Quantity, Unit price, Excise type, Excise record type, sales tax group, Item sales tax group and other required details.

4. Assessable value field populate based on Unit price * Quantity

5. Click Set up menu button > Tax

6. Excise duty will be calculated on the basis of Assessable Value (if basis of calculating the Excise is Assessable Value in the formula designer of the selected Item sales tax group)

7. Change the Assessable value.

8. Excise amount will get re-calculated on the basis of changed Assessable value.

9. Post shipment and receipt.

Excise Duty on Imported Goods:

Customs Exchange rate defined in Exchange rate master (General ledger > Setup > Currency > Exchange rate type) and attached in Ledger form (General ledger > set up > Ledger).

Create a Purchase import Order with foreign vendor. Go to Account payable > Common > Purchase order > All Purchase orderSelect foreign vendor, mark import order checkbox true.Enter item, Quantity, site, warehouse, Excise, Custom and other required details.Assessable value in foreign currency in Purchase import order line which is being calculated basis the purchase price of the goods and by adding up landing charges, insurance if any etc.Assessable value in Company Currency populated with "Assessable value" in foreign currency multiplied by custom exchange rate.

User can change the Assessable value. With change in the Assessable value in Company Currency, AV in foreign currency will also change accordingly both Assessable value and Assessable value in accounting currency are in sync.Confirm Purchase order.Create invoice registration and Generate Bill of entry.

Bill of entry is a declaration of information of Imported or exported goods prepared by the customs clerk. Importer pay the custom duty to the Custom Department based on the Bill of Entry given by the Department. The Bill of Entry states the custom classification number, country of origin, description, quantity, CIF value of goods and the estimated amount of duty to be paid.

"Actual sales tax amounts in Customs Currency" field provided on the Adjustment tab of "Bill of Entry" form (Click Tax in the bill of entry form. Click Adjustment tab and adjust duty item wise) which is an editable field. User can view and adjust the duties for each Item.

After generation of Bill of entry user can’t change Assessable value and Assessable value in Accounting currency at Product receipt and invoice stage.Post Product receipt and invoice.Assessable value in Company currency field has been added under Excise register inquiry form.(General ledger > Inquiries > tax > India posted tax > Excise > Excise register)

Customer Return of goods Register:

Annexure 58 Register will be generated based on following conditions.

• Excise Type as Manufacturer.

• Return Disposition Code with Action as Replace and Credit.

Annexure 58 consist the following information:

Customer ECC number, Customer name, Customer address, Manufacturing unit name, Manufacturing unit address, Manufacturing unit ECC number, Sales return order date, Sales return order number, Sales invoice date, Sales invoice number, Returned item, Returned quantity, Purpose of return, Return action, Used CENVAT credit on returned goods, Re-dispatched quantity, Reversed CENVAT credit.

Return Reason Code field is provided in General fast tab under Line details tab in Sales Return Order line. Return Reason code field is already available in sales return order header and when user will enter the return reason code at header level the same will flow on return order lines. User can then change the return reason code on line based on the requirements.

1. Sales and marketing > Common > Return orders > All Return orders

2. Click Line details tab.

3. Click General fast tab.

At the time of re-dispatching the goods to the customer through Replacement order, Return Action text field is provided in Setup fast tab under Line details tab in Sales Order line.

1. Sales and marketing > Common > Sales orders > All Sales orders

2. Select Replacement order, Click edit button.

3. Click Line details tab.

4. Click Setup fast tab.

Process details

1. Create and Post sales order.
   
   Go to sales and marketing > Common > Sales orders > All sales orders
   
   Enter Item, Quantity, site, warehouse, Excise type as Manufacturer and other required details.
   
   Post packing slip and invoice of sales order.
   

2. Create and post Sales return order.
   
   Go to sales and marketing > Common > Return orders > All Return orders
   
   Click general tab and enter Return reason code.
   
   Fetch above created sales order.
   
   Click Line details tab.
   
   Click General fast tab. Return reason code flow from header to line. User can change based on requirement.
   
   Registered sales return order with Disposition Action type as replace and credit.
   
   Create return line menu button and create replacement order.
   
   Post Packing slip and invoice of return order.
   
   Open Annexure 58 register (General Ledger > Inquiries > Tax > India posted tax > Excise > Annexure 58).
   
   Records will appear based on posted return order details.
   

3. Create and post Replacement order.
   
   Go to sales and marketing > Common > Sales orders > All Sales orders
   
   Select Replacement order, Click edit button.
   
   Click Line details tab.
   
   Click Setup fast tab.
   
   Enter Return action text.
   
   Enter Excise related Details.
   
   Post Packing slip and invoice of replacement order.
   
   Open Annexure 58 register (General Ledger > Inquiries > Tax > India posted tax > Excise > Annexure 58).
   
   Records will appear based on posted Replacement order details.

Note: Sales Credit Note transaction will not be recorded in Annexure-58. It is suggested to use Sales Return Order to record the transaction in Annexure-58.

RG DSA Register:
Transfer of finished goods with zero % duty "without payment of duty" to be updated in DSA register.

1. Excise Register inquiry (General ledger > Inquiries > tax > India posted tax > Excise > Excise register) for RG23A & RG23C Part II will be displayed with fixed columns summarized with total tax amount of tax components in single voucher. User can view total tax amount of posted transaction voucher wise under summary fast tab. User can view details of tax component for voucher on detail fast tab.


2. The Excise Register inquiry (General ledger > Inquiries > tax > India posted tax > Excise > Excise register) for RG23A & RG23C Part I will be displayed with fixed columns summarized with item wise , day wise and source wise. User can view summary of transaction that are posted with same item and on same day under summary fast tab. User can view details of transaction for each item and day on detail fast tab.

3. Scrap check box has been provided in Sales order line details tab under Tax information fast tab. Is Scrap field has been provided in available list under Excise register inquiry form. If user sale raw material or capital goods as scrap through sales order then through Excise register inquiry user can identify the transaction as Scrap of Raw material or capital goods Quantity.

4. Disposal type field introduced with options None / Loss / Scrap / Damage / Expiry in Tax Information tab in Movement Journal. Disposal type field has been provided in available list under Excise register inquiry form. The transactions related to Scrap / Loss of Raw material are shown separately in RG23A & RG23C Part I register. The transactions related to Damage / Expiry of Finished goods quantity should update in DSA register.

5. DSA register update the quantity with the removal of goods in case of transfer of finished goods with zero % duty with "without payment of duty" field check box as true. New field "Without payment of Duty" will be added in the DSA register inquiry form and available list for user selection. The user needs to identify the FG item in the Stock transfer order lines & Export orders. The user needs to select an "Item sales tax code" which is marked ‘Exempt’ for calculating ‘Zero’ Excise duty and In the Tax information fast tab ,mark DSA as True.

DSA Register should be updated with Nil entry when there is no production on a particular day. On Updating excise registers under Production Control module, Nil entry should be updated in the DSA registers. It is assumed that DSA batch job shall be run daily. A new field is introduced on the batch job as DSA for date and the system will update the DSA with the production orders which are Report as Finished.

Gate Entry Management:

Site wise number sequence is maintained for Inward and Outward Gate entry document in form (Inventory and warehouse management > setup > Inventory breakdown > Sites). For each site, multiple gates can be defined for entry & exit of physical goods.

Inward Gate entry list form and outward Gate Entry List form is provided to list respective inward & outward gate entries.

Inward Gate Entry is done by choosing "Reference Document Type" as Purchase Order / Sales Return Order / Transfer in / Sub-Contract return / RGP return / others. Physical goods coming in are selected from respective lines of Purchase Orders or Sales Return Order or Transfer Orders using Copy functionality. Reference Document Type Others is used to receive goods of miscellaneous nature where source documents are not available.

Outward Gate Entry is done by choosing "Reference Document Type" as Purchase Return Order / Sales Order / Transfer out / Sub-Contract / RGP / Others. Physical goods going out are selected from respective lines of Purchase Return Order or Sales Order or Transfer Order using Copy Document Functionality. Reference Document Type Others is used to send goods of miscellaneous nature where source documents are not available.

Product Receipts / Packing Slips / Transfer Shipments/ Transfer Receipts lines are linked with respective Inward or Outward Gate entry lines.

Gate Entry documents capture details of transporter, vehicle number, challan number, driver name, LR/RR no & date, employee responsible for receiving/dispatching goods, RGP number, etc.

Each Gate Entry has stages of Vehicle Entry, Measurement, Tare Check and Vehicle Exit. Relevant Action Buttons "Confirm Vehicle Entry", "Confirm Measurement", "Confirm Tare Check" and "Confirm vehicle Exit" marks completion of respective stage. Measurement checkbox on Gate entry header can be un-checked for skipping Measurement & Tare Check stages.

After confirm action button is clicked, user will not be able to edit the information of previous stage.

User can cancel or delete the document at any stage if document has not been linked with any product receipt or packing slip or transfer shipment or transfer receipt. User will also not be allowed to cancel or delete gate entry if outward gate entry lines for "Reference document type" as "Sub-contract" or RGP have been linked with respective inward gate entry document with "Reference Document Type" as "Sub-Contract return" or "RGP return".

During vehicle entry stage, user can enter Transporter & other miscellaneous details on header while challan Qty can be edited in gate entry lines. During measurement stage, Measurement quantity can be entered by integrating with Weigh Bridge. During "Tare Check" stage, "Tare Qty" can be filled with empty vehicle weight using Weigh Bridge. Vehicle Exit stage is used to record that vehicle has exit the premises.

Gate pass can be printed at any stage for inward as well as outward gate entry from respective documents.

Excise Invoice:

For Trader Excise Invoice, Excise Invoice shall be printed with the Vendor Details along with the above mentioned information.

New field Excise invoice number provided under Number sequence fast tab on Warehouse master (Inventory and warehouse management > setup > Inventory breakdown > Warehouse) Excise invoice number sequence will be governed from the warehouse selected on the Sales Order, Transfer Order, and Purchase Return Order.

Excise reporting code field introduced (General Ledger > Setup > Sales Tax > India > Tax Reporting code) for identifying Excise Duty in words and Excise CESS in words amount in Excise Invoice. In this form user can define the reporting codes as Excise Invoice. Click Aggregate Category tab in which the user can group the excise duty and accordingly Amount in words for the duty and cess shall be printed on the Report. Excise sales invoice:
Go to Account Receivable > Common > Sales orders > All sales orders
Enter Item, Quantity, Site, Warehouse, Excise information and other required details.
Post packing slip.
Click invoice, in invoice form under print options section mark Excise invoice check box = true and select print address = warehouse / company address. User can choose the option based on which address is required to be printed on excise invoice (selected print address will be print on Excise invoice report).

Warehouse address will be picked from the warehouse selected on the first line of sales Invoice. In case there are multiple lines in sales invoice with multiple warehouses, then primary warehouse address will be printed on excise invoice of the warehouse which is selected on the first line of sales invoice.

If user select company address then company primary address will be printed on the report.
User can also print report after posting sales invoice.
Click Invoice tab > Invoice button on the Journals form.
Click Overview tab >> Preview/ Print > Select Excise invoice.
Excise invoice report will generate.
Excise stock transfer report:
While posting shipment from Transfer Order, Excise Invoice will be generated.
Go to Inventory and warehouse management > Periodic > Transfer orders
Enter From warehouse, To warehouse, Item, Quantity, Excise information and other required details.
Click posting > Ship transfer order
User can Print excise invoice report at the time of shipment, Print excise Invoice checkbox provided on the shipment form under overview tab.
Click OK. Excise report will generate.
User can also print excise report after posting of shipment.
Click Print > Excise invoice (Excise Invoice option under Print button will be enabled only after transfer shipment is posted)
Purchase return invoice report:
Go to Account payable > Common > Purchase orders > All Purchase orders
Enter Item, Quantity, Site, Warehouse, Excise information and other required details.
Click invoice, in invoice form click post > print settings under print settings mark Excise invoice check box = true and select print address = warehouse / company address. User can choose the option based on which address is required to be printed on excise invoice (selected print address will be print on Excise invoice report).

Warehouse address will be picked from the warehouse selected on the first line of sales Invoice. In case there are multiple lines in sales invoice with multiple warehouses, then primary warehouse address will be printed on excise invoice of the warehouse which is selected on the first line of sales invoice.

If user select company address then company primary address will be print on the report.
User can also print report after posting purchase return invoice.
Click Invoice tab > Invoice button on the Journals form.
Click Overview tab >> Preview/ Print > Select Excise invoice.
Excise invoice report will generate.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.