In Business Central, the product group has been removed from the item card and is now part of the item category. The transfer from a system with a product group to Business Central can be configured in the mapping. Let’s take a look at the finished configuration and then at the transfer and the result.
Mapping of table 5722 Item Category
The main group of the Item Category table in Business Central is formed from the Item Category table of the previous system (Indentation=0)
Mapping of table 5723 Product Group
The subgroup of the Item Category table in Business Central is formed from the Product Group table of the source system (Indentation=1)
Transfer of content
DataMigratePro -t deletedata -s 5722
DataMigratePro -t putdata -s 5722 -i "EXEC Migration.dbo.[ExportTable] @TableNo=5722" --automapping 5722
DataMigratePro -t putdata -s 5722 -i "EXEC Migration.dbo.[ExportTable] @TableNo=5723" --automapping 5723In line 1, the previous contents of the Item Category table in Business Central are first removed. The main groups are then inserted in line 2 and the subgroups in line 3.
Result from CRONUS AG sample data
