Have someone ever done an import scenario with routing already hard-coded/inserted into the import mapping? The spreadsheet as data source only contains finished items and components. What I try to achieve here is having a workaround to assign a routing (that has set of standard operations) into a bill. My issue particularly is with multiple operation numbers that need to be inserted. I can only insert one operation with my scenario.
The spreadsheet has data FG1 (finished item) needs Comp1 and Comp2 (material) - split into 2 lines in the spreadsheet.
When imported: the BOM will have operation 10, 20, 30 (already inserted in the import mapping)and the above component are placed under operation 10.