Monday, December 30, 2013

Peformance issue while importing Bill Of Materials



In manufacturing companies you can have a lot of Bill Of Materials (BOM). When the Bill Of Materials are created for an integration to PLM or CAD systems or during data migration, the total of lines can be more than a million.

The problem is that the validation for the BOM lines will validate the structure of the BOM to check for circular references. Many times the check is specified on the most detailed level. When data is imported from a PLM or CAD system or for Data migration, the structure is checked and validated in the original application, so validation is not required in most of the cases. This check can be changed in the inventory parameters.

When you import the data into Microsoft Dynamics Ax, it can happen that the import will be slower and slower and slower.

















To keep performance switch the setting to none or to BOM, but don’t use line. Keep this in mind when you have trouble with the performance of the BOM lines.

Iace Technologies & Services..!!

No comments:

Post a Comment