How to generate json file in bulk for E way bill Generation in Marg Software?

What's New

Welcome to - Marg ERP 9+

Home > Margerp > E Way Bill > How to generate json file in bulk for E way bill Generation in Marg Software?

How to generate json file in bulk for E way bill Generation in Marg Software?

2587

Ans.1

Bulk E-Way Bill Generation with JSON File in Marg ERP

Overview of E-Way Bill Generation with JSON file

Process of E-Way Bill Generation with JSON file & Uploading on Portal

OVERVIEW OF E-WAY BILL GENERATION WITH JSON FILE

For generating bulk E-Way bill with Marg ERP, the process requires a business to upload multiple E-way bills at one shot on the E-Way bill portal.

Process Of E-Way Bill Generation With Json File & Uploading On Portal

Process of Exporting Single Bill to JSON File

In order to export a single bill to JSON File, the user will go to Sales Book once the bill is being generated>>Press F3 function key

Fig. 1.1 View of Sales Book Window in Marg ERP Software

Fig. 1.2 View of Sales Book Window in Marg ERP Software

Here, 2 options will appear i.e.:

E-way Bill Generation (Customers)

E-way Bill Consolidated (Transporters)

E-Way Bill Generation: When the customer generates E-Way bill and gives it to the transporter then in that case the user will select E-Way bill Generation.

Process of E-Way bill Generation in Marg ERP Software

Firstly, select E-Way bill Generation>>Fill the E-Way Bill Details i.e. From Place, From Pin code, Transport Mode, Distance Level, Transporter ID/GSTIN.

If the customer is generating E-Way bill then enter GSTIN here & if the transporter is generating E-way bill then enter Transporter ID here.

Note: If the customer is generating E-Way bill and if own vehicle is being used so it is not mandatory to mention Transporter ID here. But if the customer is transporting through a transporter then the transporter ID is required to be mentioned here once it is taken from the Transporter.

Then mention the transporter Vehicle number, Transporter Document number and Transporter Document Date>>Click on “OK”.

Fig. 1.3 Entering the E-Way Bill Details in Marg ERP Software

Once the details has been filled then it shows that E-Way file has got exported on this location (as shown below)

Fig. 1.4 View of E-Way Bill File Path in Marg ERP Software

Next is Format i.e. 2 options are in format: JSON and Excel.

JSON: If the user select JSON option then directly JSON file will get prepared. Then go to the export folder and the user can view that the JSON file has been generated.

Fig. 1.5 Process of E-Way Bill Generation in Marg ERP Software

Fig. 1.6 View of Exported JSON File in Marg ERP Folder

Excel: If the user selects “Excel” then a file will get exported to excel.

The benefit of exporting the file to excel is that the user can easily verify the excel file first and then prepare JSON file according to it.

Now, the user can view that the E-Way bill has been generated.

Fig. 1.7 Process of E-Way Bill Generation in Marg ERP Software

Go to the export folder in Marg ERP Folder>>the user can view that the excel file has been generated>>Open the Excel File.

Fig. 1.8 View of Exported Excel File in Marg ERP Folder

The user can view the details of all the selected items. The user can then verify these details and also fill these details like GSTIN or Transporter ID, Legal Name, Address, Place, State and Pin code.

Fig. 1.9 Entering the Details in Excel File

Once the details are being verified then simply click on “Validate button”>>Then a message will be shown “Data Validated Successfully”>>Now, “Prepare JSON” button will get activated.

Fig. 1.10 View of Message (Data Validated Successfully) in Excel File

Click on “Prepare JSON button and it will display location on which the JSON file has got created.

Fig. 1.11 View of Message (JSON File Created) in Excel File

If the user will visit this particular location then can view that the JSON file has been generated.

Fig. 1.12 View of Generated JSON File in Marg ERP Folder

So, in this way the user can generate E-Way bill through E-Way Bill Generation option.

E-Way Bill Consolidated: When the transporter generates E-Way bill then in that case the user will select E-Way bill Consolidated option.

Fig. 1.13 View of E-Way Bill Consolidated Option in Marg ERP Folder

Process of E-Way bill Consolidated in Marg ERP Software

The user requires to mention the E-Way bill no. on the bill. For that go to sales book>>Select the bill which is required to be exported to JSON>>Press Enter

Fig. 1.10 Selecting the Sale Bill in Marg ERP Folder

Click on “Detail” and then “Modify”.

Fig. 1.11 Process to Modify the Sale Bill in Marg ERP Folder

Fig. 1.12 Process to Modify the Sale Bill in Marg ERP Folder

Now, enter that E-Way Bill no. herewhich has been generated on the E-Way Bill portal over & then save it.

Then press F11 function key>>Select E-Way Bill Consolidated option

Fig. 1.14 View of E-Way Bill Consolidated Option in Marg ERP Folder

Fig. 1.15 Selecting E-Way Bill Consolidated Option in Marg ERP Folder

Now, the transporter will fill the details under “E-Way Bill Details” window>>Then click on “OK”.

Fig. 1.15 Entering the Transporter Details in E-Way Bill Details Window

Then select the type of format i.e. JSON or Excel.

If the user will select JSON then JSON file will be generated directly.

Fig. 1.16 Selecting the Format Type in E-Way Bill Details Window

For example, the user selects “Excel”.

Fig. 1.17 View of E-Way Bill Consolidated Exported in Marg ERP Software

The user will go to the export folder and can view that the file has been exported.

Fig. 1.18 View of Exported Excel File in Marg ERP Folder

As the user will open it then the details can be viewed here. The user can then verify these details and also fill these details like GSTIN, Name, Place and Pin Code.

Fig. 1.19 Entering the Details in Excel File

Fig. 1.20 View of Message (Data Validated Successfully) in Excel File

Click on “Prepare JSON button and it will display location on which the JSON file has got created.

Fig. 1.21 View of Message (JSON File Created) in Excel File

Fig. 1.22 View of JSON File Created in Marg ERP Folder

So in this way the user has seen the process of exporting a single bill to JSON.

Process of Exporting Multiple Bills to JSON File

Go to Daily Reports menu>>Daily Working>>Dispatch Summary.

Fig. 1.23 Menu View to Dispatch Summary Option in Marg ERP Software

Specify the dates i.e. from which date till which date the user required to export the bills>> Then click on “Accept”.

Fig. 1.24 View of Dispatch Summary Option in Marg ERP Software

Select Multiple Bills>>Press F7 function key and the user canview that both E-Way Bill Generation and E-Way Bill Consolidated options are displayed.

Fig. 1.25 Pressing F7 Function key in Marg ERP Software

Fig. 1.26 View of E-Way Bill Window in Marg ERP Software

Now according to the requirement the user will select an option for example let’s select “E-Way Bill Generation”>>Fill E-Way Bill details and >>Then click on “Ok”.