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