Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |