Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

TableNameDescriptionRequired/Optional
27ItemItem InformationRequired
5717Item Cross ReferenceItem Bar Code or other item cross reference informationOptional
5404Item 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