cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to use spreedsheet import/export feature to edit alternative BOMs ( MPMLink)

0 Kudos

Unable to use spreedsheet import/export feature to edit alternative BOMs ( MPMLink)

Create an alternative BOM:

1.1 Select any end item in state InWork and View Design 
1.2 Open it in Manufacturing Associative Part Structure Browser
1.3 RMB on the upstream object and select New Downstream Branch to create the view Manufacturing
1.4 In the top toolbar of the downstream view click New/Add > New Branch 
1.5 In the New Branch window insert the attribute BOM Type and Alternative BOM. The OOTB BOM Type options are: Testing, Costing e Production. 
1.5 Performing this process twice two alternative views are created 

Test :

Mounted a simple BOM in each : 
In the Structure1 Testing put comp1 with a Substitute 
In the Structure1 Costing put comp1 and comp2 without Substitute 
Both structures have the same Name and Number with different components. Each one has its own version number and iteration. 

Delete the Substitute of the View Testing using spreadsheet (it works fine) 

Issue :

1- Put a Substitute in comp1 in the view Costing and perform a check-out / check-in until the version 0.5 as the Testing is in 0.4. 
2- Export to spreadsheet
3- Change the Action to delete in the .xlsx file
4- Import from spreadsheet

Doesn't work, it only recognizes the version Testing and as no Substitute in this version, it throws an error when deleting. It doesn’t recognize the Costing.