Service Invoice Import Routine for Automobile industries in Sage 300

By | September 23, 2015

Generally the automobile industries are moving towards the implementation of ERP into their organization. In this blog we will see how the service invoices can directly create into Sage 300 from another system.
If a vehicle comes in a workshop for servicing, then after completion of the service, we make invoice for the total labor chargers & extra parts that the worker has applied to that vehicle. This is nothing but called as Service Invoice in automobile industries.
In case, if the industry already has the system for maintaining all those things then in this case we have created an import routine which will directly fetch the data from database, list out in UI control & after verifying all the data user can processed it for automatic creation of Invoices in Sage 300.
For achieving this we need to map the items from both the systems through optional fields, so that at the time of importing same item has to be present into the Sage 300 & customers as well. After mapping all those things we have to create SQL view which will fetch the data from both the database with linked sever connection.
Below will be the UI for import routine:
New Stuff: Non-Returnable Gate Pass
blog11
In this UI you will get the below controls:
•  Filter criteria for date selection & depends on that we will fetch the data from another systems database.
•  Location selection as this is mandatory field for creation of invoice in Sage 300. This finder will show you all the locations from your company database in Sage 300.
•  This Grid will show you all the header level data from your database of another system.
•  Popup will display after clicking on a particular row & it will contain all the detail level data from your database of another system.
•  Once you have done with the data verification, you need to click Import button. This will start the process of importing into Sage 300 with the showing data in grid.
After completion of import process you will get the successful message into message box or else if there will be any error in importing, you will get those error in error log file. The path of error log which we have to set in configuration file.
Advantages:
-As this is direct database to database importing of data, you will save your time of import & export data through some files like excel etc.
Also Read:
1.Database To Database Integration in SAGE 300 ERP
2.How Deposit date in AR receipt entry plays important role in Bank Reconciliation
3.Generic Import-Export Macros for Sage 300 ERP
4.Table Does Not Exist Error while importing data into Sage 300 ERP
5.Import and Export feature in Style Maintenance screen of GreyMatrix for Sage 300 ERP