Assessable Value on Stock Transfer Order:Process details:
- Go to Inventory and warehouse management > Periodic > Transfer order.
- Create a new stock transfer order.
- 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.
- Assessable value field populate based on Unit price * Quantity
- Click Set up menu button > Tax
- 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)
- Change the Assessable value.
- Excise amount will get re-calculated on the basis of changed Assessable value.
- 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.
- Sales and marketing > Common > Return orders > All Return orders
- Click Line details tab.
- 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.
- Sales and marketing > Common > Sales orders > All Sales orders
- Select Replacement order, Click edit button.
- Click Line details tab.
- Click Setup fast tab.
Process details
- 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.
- 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.
- 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.
Hotfix information
A supported hotfix is available from Microsoft. There is a "Hotfix download available" section at the top of this Knowledge Base article. If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, visit the following Microsoft website: You can also contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:
PartnersCustomersIn special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.