Configuration packages in Business Central are used to import data in bulk quantities. Almost every business needs to transfer a large amount of data to their systems either vendors, products or customers, etc. Through these packages import and export large amounts of data with ease. Search “Configuration Packages” from the role center page and open the related link.
With the “New” option, create a new package.
Specify an appropriate package name and code, then click on three dots in the Table ID field to select a suitable package for import or export.
When you click on three dots, a window appears containing a list of tables. Please select an appropriate table, in this blog, we are importing a package of vendors.
Select ok, to complete a selection. The table ID will appear in the main window with the no. of available fields.
Click on the no. of fields as highlighted in the above screenshot to see the available fields. The window appears with the list of fields, you can select the desired fields only if you need to import or export specific data. With the Clear included option all selections will remove and then you can manually check-marked the fields which you want to include.
Now come back to the main window and go to Excel >> Export to excel
The excel template is exported to the system. The file contains all the existing system data, add your data in the template and then import the sheet back by going into Excel >> Import to excel
Validate the package to check if there are errors in the data. If there are errors system will show them, see the error detail by clicking on the no. (1 in this case). Correct the error in the excel sheet and import it again, validate and then apply the package.
When you apply the package following message will appear. Similarly, import the data for different entities using configuration packages.
This blog covers the bulk import & export of data in Business Central. accsoft has years of experience in implementing Microsoft Dynamics ERPs and also providing support to clients. For further assistance and to make us your implementation partner reach us at info@localhost