The following table shows the actions that are performed by the Step 1 data upgrade tool for Microsoft Dynamics NAV 2013 R2 when Kitting is upgraded to Assembly Management.
| Table | From Field Value=old | To Field Value=new | To Temporary Table | Conditions |
|---|---|---|---|---|
18 Customer | ||||
"Components on Sales Orders" | := blank | |||
"Components on Shipments" | := blank | |||
"Components on Invoices" | := blank | |||
27 Item | ||||
"Components on Sales Orders" | := blank | |||
"Components on Shipments" | := blank | |||
"Components on Invoices" | := blank | |||
"Components on Pick Tickets" | := blank | |||
“No | TempItem."Item No." := "No." | If "Kit BOM No." <> blank | ||
"Kit BOM No." | :=blank | TempItem."Assembly BOM" := "Kit BOM No." | If "Kit BOM No." <> blank | |
"Kit Disassembly BOM No." | := blank | TempItem."Disassembly BOM" := "Kit Disassembly BOM No." | If "Kit Disassembly BOM No." <> blank | |
"Automatic Build Kit BOM" | := false | TempItem."Automatic Build Kit BOM" := "Automatic Build Kit BOM" TempItem."Automatic Build Kit BOM" :=TRUE IF TempItem."Assembly BOM" <> blank AND InvtSetup."Automatic Build Kit BOM" <> blank | ||
"Roll-up Kit Pricing" | := blank(never) | |||
37 Sales Line | ||||
"Kit Item" | := false | |||
"Build Kit" | := false | Transfer all sales line fields to TempSalesLine table | If "Build Kit" :=TRUE | |
83 Item Journal Line | ||||
"Kitting" | := blank | |||
111 Sales Shipment Line | ||||
"Kit Item" | := false | |||
"Build Kit" | := false | |||
113 Sales Invoice Line | ||||
"Kit Item" | := false | |||
"Build Kit" | := false | |||
238 BOM Ledger Entry | ||||
"Kit Item No." | := blank | |||
311 Sales Setup | ||||
"Components on Sales Orders" | :=blank | |||
"Components on Shipments" | := blank | |||
"Components on Invoices" | := blank | |||
313 Inventory Setup | ||||
"Kit BOM Nos." | := blank | |||
"Automatic Build Kit BOM" | := false | |||
"Components on Pick Tickets" | :=blank | |||
5108 Sales Line Archive | ||||
"Kit Item" | := false | |||
"Build Kit" | := false | |||
5406 Production Order Line | ||||
"Kitting" | := blank | |||
5767 Whse Activity Line | ||||
"Kit Item No." | := blank | Transfer all fields in Warehouse Activity Line table to TempWhseActivityLine table | If "Kit Item No."<> blank | |
7321 Whse Shipment Line | ||||
"Build Kit" | := false | Transfer all fields in Warehouse Shipment Line table to TempWhseShptLine table | If "Kit Item No."<> blank | |
7326 Whse Worksheet Line | ||||
"Build Kit" | := false | |||
99000771 Production BOM Header | ||||
Delete record | If "Type" := Kitting | |||
99000772 Production BOM Line | ||||
Delete record | If Production BOM Header 's "Type" := Kitting | |||
TempBOMComp."Parent Item No." := TempItem."Item No." | If Production BOM Header's "Type" := Kitting AND TempItem."Assembly BOM" equals ProdBOMLine."Production BOM No." | |||
"No." | TempBOMComp."No." := ProdBOMLine."No." | as above | ||
"Line No." | TempBOMComp."Line No." := ProdBOMLine."Line No." | as above | ||
"Type":=Item | TempBOMComp.Type ::Item | as above | ||
"Type":=Blank | TempBOMComp.Type ::Blank | as above | ||
"Type":=Resource | TempBOMComp.Type :: Resource | as above | ||
"Type":=Setup Resource | TempBOMComp.Type ::Resource; TempBOMComp."Resource Usage Type" := Fixed | as above | ||
"Description" | TempBOMComp."Description | as above | ||
"Unit of Measure Code" | TempBOMComp."Unit of Measure Code" | as above | ||
"Quantity per" | TempBOMComp."Quantity per" | as above | ||
"Position" | TempBOMComp."Position" | as above | ||
"Position 2" | TempBOMComp."Position 2" | as above | ||
"Position 3" | TempBOMComp."Position 3" | as above | ||
"Production Lead Time" | TempBOMComp."Lead-Time Offset" | as above | ||
"Variant Code" | TempBOMComp."Variant Code" | as above |