Hello everyone. In this post, we will see the process of integrating the database with Saral GST for automating the process of E-Invoice generation.

Database Integration or DB integration is a customized process in Saral GST where the details required for E-Invoicing will be automatically taken from the database of accounting software and is uploaded to the website.

After uploading, the validated file will auto downloaded to the defined path from where the PDF copy of the signed invoice can be generated.

Before going for integration settings in Saral GST, ensure that:

  • The database of your accounting software is synchronized with the Saral GST database.
  • The database that can be integrated are MSSQL, Oracle, PostgreSQL

Note: This customized is done by Relyon Customer Support. Please contact us for more integration.

To start the integration process

Go to the E-Invoice menu and select Settings under ERP/SAP Integration.

1.Database Integration-e-invoice integration

Here, click on Enable auto syncing of E-Invoicing and enter the duration for auto sync.

2.Database Integration-enable autosync

Next, select SQL DB Data Integration. For settings, enter the DB instance name, login credentials for DB, and DB Name from where the E-Invoicing details have to be fetched.

3.Database Integration-data integration

After entering the details, save and the synchronization process will begin. The last sync time stamp will be shown at the left bottom of the window.

After upload, the downloaded JSON file will be made available in the defined path. To view and print the downloaded invoices, go to View/Upload under E-Invoice.

4.Database Integration- view e-invoice

Here, select the date range and all the invoices uploaded will be displayed. To print the E-Invoice, click on Print and the PDF copy of the E-Invoice will be generated.

5.Database Integration- print e-invoice

To view the imported sequence details, go to the E-Invoice menu, and select Imported Log under ERP/SAP Integration.

6.Database Integration-imported log

Here, one can see the synchronization log w.r.t invoices imported, Invoices which failed to be imported, Uploaded invoices, and invoices that failed to be uploaded.

7.Database Integration-synchronization log

In case of failure, the error message will be displayed. This can be rectified in the accounting software for proper upload.

This completes Database Integration in Saral GST for E-Invoicing.

Refer to our blogs: