Welcome to Marg Care - Marg ERP 9+

Home > Margerp > Ease Of Gst Adoption > How to Export All Item in Excel Format in Marg Software?

How to Export All Item in Excel Format in Marg Software?

11030

Ans.1

With the help of Marg Software user can easily export the list of items along with the HSN/SAC codes, Tax rate and all the necessary details of the item.

This option help user to export all the items created in the software at once so that user can easily make the changes in it and can import in the software.

In order to know the process, follow the given steps:

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

  • An 'Item GST%/HSN/SAC/Rates Updation' window will appear. In 'Stock Status', the user will select 'Whole'.
  • Then click on 'Accept'.

  • Then an 'Item wise HSN/SAC Master' window will appear then press 'F10' key on it.

  • A 'Bill' window will appear.
  • Select 'Export'  to export item list then press 'Enter' key on it.

  • Now the user can view the path of the report where the exported excel will get saved and it can also be edited (If needed).
  • Then press 'Enter' key.

After following the above steps, the item list will get saved exported in Excel format in the software.

Ans.2

1. Go to Masters > Ease of GST > Item GST%/HSN/SAC/RATES Updation. 

2. An 'Item GST%/HSN/SAC/RATES Updation' window will appear.

3. Click on 'Accept' tab.

4. An 'Item wise HSN/SAC Master' window will appear. Press 'Alt+P' key.

5. In the next window the user will click on 'View/Print/Excel' as per the requirement.

Ans.3
|

1. Go to Masters Rate & Discount Master Price List > All Items.

2. The 'General Price List' window will appear in which the user will press 'Alt+P' key on it.

3. A 'Price List' window will appear. Select 'Price List User Defined'.

4. A 'Print Price List' window will appear.

5. In 'Print copies', the user will enter how many copies of the price user needs to print. Suppose mentioned '1'.

7. Select other filters according to the requirement. Press 'Ctrl+W' key.

8. In the next window the user will click on the 'Excel' tab.


Submit Feedback