Table of Contents |
---|
1. Create Configuration Package
1.1 Click on the search button then enter Configuration Packages and then click the link to open the page
...
(4) No. of Database Records - the number of existing items recorded in system
2. Select fields for the package
Steps for select necessary fields for the package
...
User can click the link for review the selected fields.
3. Export package for fill up the import data
(1) Select Excel then
(2) Select Export to Excel
...
(2) DON'T change the table field name (i.e. column name) and the column sequence
4. Import package for add new record
Prepare the data for import
...
(5) No. of Package Records to be shows, user can click the link to preview the data
5. Error Handling
If error occurred, no, of error to be shows. In the case example in screen capture below, there have 11 error found.
...
User can click on the link to update the package record directly or update the Excel and import again.
6. Apply Data for update data into business central
6.1 Select “Functions” => “Apply Data”
7. Tables related to create item
To create item by use Configuration package, user may need to process the table below:
Table | Name | Description | Required/Optional |
---|---|---|---|
27 | Item | Item Information | Required |
5717 | Item Cross Reference | Item Bar Code or other item cross reference information | Optional |
5404 | Item Unit of Measure | Multiple units of the item, for example PC, Pack is use for the item unit *NOTE- if validation field is selected for Unit of Measure field, system will default add the item unit of measure for base unit. | Optional |