Welcome to Marg Care - Marg ERP 9+

Home > Margerp > Ease Of Gst Adoption > How to Update HSN Code in All Items through Excel in Marg ERP Software ?

How to Update HSN Code in All Items through Excel in Marg ERP Software ?

17599

Ans.1

Introduction to Update HSN code in Multiple items in Marg ERP Software

Process to Export Item List with their HSN code in Marg ERP Software

Process to Import Item List with their Updated HSN code in Marg ERP Software

Introduction to Update HSN code in Multiple items in Marg ERP Software

  • In Marg ERP Software, the user can update the HSN Code in multiple items through Excel at a single point of time. This option allows the user to import multiple data at once without creating any method. It saves time as there is no need to update the HSN Code for each separate item in the software.

Process to Export Item List with their HSN code in Marg ERP Software

  • Go to Masters > Ease of GST > Item GST%/HSN/SAC/Rates Updation.   

  • In 'Stock Status' option, the user will select 'Whole.

  • Click on 'Accept' button.

  • Press 'F10' key.

  • The user will select 'Export' option.

  • The user will select the path where they want to save the file and press 'Enter' key.

After following the above steps, the user can view that the item list will be saved with their HSN codes in Marg ERP Software.

  • Now the user can update the HSN code in the exported Excel as per the requirement.

  • Suppose we have updated all HSN codes in items.

Process to Import Item List with their Updated HSN code in Marg ERP Software

  • Go to Masters > Ease of GST > Item GST%/HSN/SAC/Rates Updation.   

  • Click on 'Accept' button.

  • Press 'F10' key.

  • The user will select 'Import' option.

  • Click on 'Ok' button.

  • The user will select the location where the exported Excel sheet of the item master has been saved and click on 'Select' button.

  • Now, the selected path will be automatically picked by the software beside the 'Import' field and press 'Enter' key.

  • Now, the user can view the file in Importing.

After following the above steps, the user can view that the data has been properly imported with their updated HSN codes in Marg ERP Software.

Ans.2

The user can also update HSN in All Items by following the below steps:

a. Go to Reports > Management Reports > Utilities > Multi Editing > Tax% & HSN/SAC.

Note: The user will Press 'Spacebar' key or Plus '+' key to select a particular Company or Press Asterisk '*' key to select all companies. 

b. Press 'Enter' key on the selected Tax Rate.

c. Now, the user can change the SGST / CGST / HSN Code as per the requirement.

d. Press 'Esc' key.

e. In 'Save Both / Sale / Purchase / Exit', the user will select whether the changes needs to save in previous Sale and Purchase Bill or not and press 'Enter' key.


Submit Feedback