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.
Here, click on Enable auto syncing of E-Invoicing and enter the duration for auto sync.
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.
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.
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.
To view the imported sequence details, go to the E-Invoice menu, and select Imported Log under ERP/SAP Integration.
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.
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.