Assembly Management: Data Upgrade Step 1
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 |