Table Changes for Supply Chain Management

The following changes were implemented for Supply Chain Management.

  • Introduction of Order Type Field on Selected Tables

  • Introduction of a New Inventory Adjmt. Entry (Order) Table

  • Change Production Lead Time Field to Lead-Time Offset Field and Convert the Value to Date Formula in BOM Component Table

  • Delete Selected Tables and Fields Representing the Existing Sales BOM Feature

Introduction of Order Type Field on Selected Tables

Reason for change: To reduce the number of fields on the heavy-duty Entry tables and to promote one field to serve multiple source orders.

Upgrade rules:

  • Tables Item Ledger Entry, Item Journal Line, Capacity Ledger Entry, Value Entry and Cost Share Buffer have new fields: Order Type, Order No., and Order Line No..

  • Data from existing fields Prod. Order No., Transfer Order No., and Service Order No. are transferred to Order No. field, and Order Type is set to Production, Transfer and Service, respectively.

  • Data from existing field Prod. Order Line No. is transferred to Order Line No. field.

  • Existing fields Prod. Order No., Transfer Order No., Service Order No., and Prod. Order Line No. are deleted.

Changes to Table 83: Item Journal Line

The following changes are performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

Prod. Order No.

:= blank

TempItemJournalLine.Order Type :: Production

TempItemJournalLine.Order No. := Prod. Order No.

IF Prod. Order No.<> blank

Transfer Order No.

:= blank

TempItemJournalLine.Order Type :: Transfer

TempItemJournalLine.Order No. := Transfer Order No.

IF Transfer Order No.<> blank

Service Order No.

:= blank

TempItemJournalLine.Order Type:: Service

TempItemJournalLine.Order No. := Service Order No.

IF Service Order No.<> blank

Prod. Order Line No.

:= blank

TempItemJournalLine.Order Line No. :=Prod. Order Line No.

None.

The following changes are performed in Step 2 of the Data Upgrade:

Field Source of Value

Order Type

:= TempItemJournalLine.Order Type

Order No.

:= TempItemJournalLine.Order No.

Order Line No.

:= TempItemJournalLine.Order Line No.

Changes to Table 32: Item Ledger Entry

The following changes are performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

Prod. Order No.

:= blank

TempItemLedgerLine.Order Type :: Production

TempItemLedgerLine.Order No. := Prod. Order No.

IF Prod. Order No.<> blank

Transfer Order No.

:= blank

TempItemLedgerLine.Order Type :: Transfer

TempItemLedgerLine.Order No. := Transfer Order No.

IF Transfer Order No.<> blank

Service Order No.

:= blank

TempItemLedgerLine.Order Type:: Service

TempItemLedgerLine.Order No. := Service Order No.

IF Service Order No.<> blank

Prod. Order Line No.

:= blank

TempItemLedgerLine.Order Line No. :=Prod. Order Line No.

None.

The following changes are performed in Step 2 of the Data Upgrade:

Field Source of Value

Order Type

:= TempItemLedgerEntry.Order Type

Order No.

:= TempItemLedgerEntry.Order No.

Order Line No.

:= TempItemLedgerEntry.Order Line No.

Changes to Table 5832: Capacity Ledger Entry

The following changes are performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

"Prod. Order No."

:= blank

TempCapacityLedgerEntry."Order Type" :: Production

TempCapacityLedgerEntry."Order No." := "Prod. Order No."

IF "Prod. Order No."<> blank

"Prod. Order Line No."

:= blank

TempCapacityLedgerEntry."Order Line No." :="Prod. Order Line No."

None.

The following changes are performed in Step 2 of the Data Upgrade:

Field Source of Value

Order Type

:= TempCapacityLedgerEntry.Order Type

Order No.

:= TempCapacityLedgerEntry.Order No.

Order Line No.

:= TempCapacityLedgerEntry.Order Line No.

Changes to Table 5802: Value Entry

The following changes are performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

"Prod. Order No."

:= blank

TempValueEntry."Order Type" :: Production

TempValueEntry."Order No." := "Prod. Order No."

IF "Prod. Order No."<> blank

"Prod. Order Line No."

:= blank

TempValueEntry."Order Line No." :="Prod. Order Line No."

None.

The following changes are performed in Step 2 of the Data Upgrade:

Field Source of Value

Order Type

:= TempValueEntry.Order Type

Order No.

:= TempValueEntry.Order No.

Order Line No.

:= TempValueEntry.Order Line No.

Changes to Table 5848: Cost Share Buffer

The following changes are performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

"Prod. Order No."

:= blank

TempCostShareBuffer."Order Type" :: Production

TempCostShareBuffer."Order No." := "Prod. Order No."

IF "Prod. Order No."<> blank

"Prod. Order Line No."

:= blank

TempCostShareBuffer."Order Line No." :="Prod. Order Line No."

None.

The following changes are performed in Step 2 of the Data Upgrade:

Field Source of Value

Order Type

:= TempCostShareBuffer.Order Type

Order No.

:= TempCostShareBuffer.Order No.

Order Line No.

:= TempCostShareBuffer.Order Line No.

Introduction of a New Inventory Adjmt. Entry (Order) Table

Reason for change: A new Inventory Adjmt. Entry (Order) table is introduced to hold the data involved in cost adjustment of Released and Finished Production Orders (and, starting with Microsoft Dynamics NAV 2013 R2, posted Assembly Orders).

Upgrade rules:

  • Data from cost-related fields in Production Order Line table are moved to a new Inventory Adjmt. Entry (Order) table.

  • The following fields are deleted from the Production Order Line table:

    • "Cost is Adjusted"

    • "Allow Online Adjustment"

    • "Single-Level Material Cost"

    • "Single-Level Capacity Cost"

    • "Single-Level Subcontrd. Cost"

    • "Single-Level Cap. Ovhd Cost"

    • "Single-Level Mfg. Ovhd Cost"

    • "Completely Invoiced"

    • "Currency Factor"

Changes to Table 5406: Prod. Order Line

The following changes are performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

"Prod. Order No."

TempItemJournalLine."Order No." := "Prod. Order No."

TempInvtAdjmtEntryOrd."Order Type" :: Production

IF "Status" ::Released or Finished

"Line No."

TempInvtAdjmtEntryOrd."Order Line No." :="Line No."

IF "Status" ::Released or Finished

"Item No."

TempInvtAdjmtEntryOrd."Item No." := "Item No."

IF "Status" ::Released or Finished

"Routing No."

TempInvtAdjmtEntryOrd."Routing No." := "Routing No."

IF "Status" ::Released or Finished

"Routing Reference No."

TempInvtAdjmtEntryOrd."Routing Reference No." := "Routing Reference No."

IF "Status" ::Released or Finished

"Indirect Cost %"

TempInvtAdjmtEntryOrd."Indirect Cost %" := "Indirect Cost %"

IF "Status" ::Released or Finished

"Overhead Rate"

TempInvtAdjmtEntryOrd."Overhead Rate" := "Overhead Rate"

IF "Status" ::Released or Finished

"Cost is Adjusted"

:= FALSE

TempInvtAdjmtEntryOrd."Cost is Adjusted" := "Cost is Adjusted"

IF "Status" ::Released or Finished

"Allow Online Adjustment"

:= FALSE

TempInvtAdjmtEntryOrd."Allow Online Adjustment" := "Allow Online Adjustment"

IF "Status" ::Released or Finished

"Unit Cost"

TempInvtAdjmtEntryOrd."Unit Cost" := "Unit Cost"

IF "Status" ::Released or Finished

"Single-Level Material Cost"

:= blank

TempInvtAdjmtEntryOrd."Single-Level Material Cost" := "Single-Level Material Cost"

IF "Status" ::Released or Finished

"Single-Level Capacity Cost"

:= blank

TempInvtAdjmtEntryOrd."Single-Level Capacity Cost" := "Single-Level Capacity Cost"

IF "Status" ::Released or Finished

"Single-Level Subcontrd. Cost"

:= blank

TempInvtAdjmtEntryOrd."Single-Level Subcontrd. Cost" := "Single-Level Subcontrd. Cost"

IF "Status" ::Released or Finished

"Single-Level Cap. Ovhd Cost"

:= blank

TempInvtAdjmtEntryOrd."Single-Level Cap. Ovhd Cost" := "Single-Level Cap. Ovhd Cost"

TempInvtAdjmtEntryOrd."Direct Cost" := "Single-Level Material Cost" + "Single-Level Capacity Cost" + "Single-Level Subcontrd. Cost" + "Single-Level Cap. Ovhd Cost"

IF "Status" ::Released or Finished

"Single-Level Mfg. Ovhd Cost"

:= blank

TempInvtAdjmtEntryOrd."Single-Level Mfg. Ovhd Cost" := "Single-Level Mfg. Ovhd Cost"

TempInvtAdjmtEntryOrd."Indirect Cost" := "Single-Level Mfg. Ovhd Cost"

IF "Status" ::Released or Finished

"Completely Invoiced"

:= FALSE

TempInvtAdjmtEntryOrd."Completely Invoiced" := "Completely Invoiced"

IF "Status" ::Released or Finished

"Status"

TempInvtAdjmtEntryOrd."Is Finished" := True IF "Status" :: Finished

IF "Status" ::Released or Finished

"Currency Factor"

:= blank

IF "Status" ::Released or Finished

ACY Cost fields

TempInvtAdjmtEntryOrd."Direct Cost (ACY)"

TempInvtAdjmtEntryOrd."Indirect Cost (ACY)"

TempInvtAdjmtEntryOrd."Single-Lvl Material Cost (ACY)"

TempInvtAdjmtEntryOrd."Single-Lvl Capacity Cost (ACY)"

TempInvtAdjmtEntryOrd."Single-Lvl Subcontrd Cost(ACY)"

TempInvtAdjmtEntryOrd."Single-Lvl Mfg. Ovhd Cost(ACY)"

IF on the G/L Setup "Additional Reporting Currency" <>, THEN based on the value in "Amount Rounding Precision" for specific currency, the values for cost fields in ACY (see to the left) are calculated and rounded.

Values Assigned for New Table 5896: Inventory Adjmt. Entry (Order)

The following values are assigned in Step 2 of the Data Upgrade:

Field Source of Value

"Order Type"

:= TempInvtAdjmtEntryOrd."Order Type"

"Order No."

:= TempItemJournalLine."Order No."

"Order Line No."

:= TempInvtAdjmtEntryOrd."Order Line No."

"Item No."

:= TempInvtAdjmtEntryOrd."Item No."

"Routing No."

:= TempInvtAdjmtEntryOrd."Routing No."

"Routing Reference No."

:= TempInvtAdjmtEntryOrd."Routing Reference No."

"Indirect Cost %"

:= TempInvtAdjmtEntryOrd."Indirect Cost %"

"Overhead Rate"

:= TempInvtAdjmtEntryOrd."Overhead Rate"

"Cost is Adjusted"

:= TempInvtAdjmtEntryOrd."Cost is Adjusted"

"Allow Online Adjustment"

:= TempInvtAdjmtEntryOrd."Allow Online Adjustment"

"Unit Cost"

:= TempInvtAdjmtEntryOrd."Unit Cost"

"Direct Cost"

:= TempInvtAdjmtEntryOrd."Direct Cost"

"Indirect Cost"

:= TempInvtAdjmtEntryOrd."Indirect Cost"

"Single-Level Material Cost"

:= TempInvtAdjmtEntryOrd."Single-Level Material Cost"

"Single-Level Capacity Cost"

:= TempInvtAdjmtEntryOrd."Single-Level Capacity Cost"

"Single-Level Subcontrd. Cost"

:= TempInvtAdjmtEntryOrd."Single-Level Subcontrd. Cost"

"Single-Level Cap. Ovhd Cost"

:= TempInvtAdjmtEntryOrd."Single-Level Cap. Ovhd Cost"

"Single-Level Mfg. Ovhd Cost"

:= TempInvtAdjmtEntryOrd."Single-Level Mfg. Ovhd Cost"

"Completely Invoiced"

:= TempInvtAdjmtEntryOrd."Completely Invoiced"

"Is Finished"

:= TempInvtAdjmtEntryOrd."Is Finished"

"Direct Cost (ACY)"

:= TempInvtAdjmtEntryOrd."Direct Cost (ACY)"

"Indirect Cost (ACY)"

:= TempInvtAdjmtEntryOrd."Indirect Cost (ACY)"

"Single-Lvl Material Cost (ACY)"

:= TempInvtAdjmtEntryOrd."Single-Lvl Material Cost (ACY)"

"Single-Lvl Capacity Cost (ACY)"

:= TempInvtAdjmtEntryOrd."Single-Lvl Capacity Cost (ACY)"

"Single-Lvl Subcontrd Cost(ACY)"

:= TempInvtAdjmtEntryOrd."Single-Lvl Subcontrd Cost(ACY)"

"Single-Lvl Mfg. Ovhd Cost(ACY)"

:= TempInvtAdjmtEntryOrd."Single-Lvl Mfg. Ovhd Cost(ACY)"

Change Production Lead Time Field to Lead-Time Offset Field and Convert the Value to Date Formula in BOM Component Table

Reason for change: To align terminology with the new Assembly Management feature.

Upgrade rule: Data from existing Production Lead Time field are moved to a new Lead-Time Offset field and changed from number to date formula (with "day" as a default period).

Changes to Table 90: BOM Component

The following change is performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

"Production Lead Time"

:= blank

TempBOMComp."Production Lead Time" :="Production Lead Time"

None.

The following change is performed in Step 2 of the Data Upgrade:

Field Source of value

"Lead-Time Offset"

:= TempBOMComp."Production Lead Time"

Add "D" to the period value.

Delete Selected Tables and Fields Representing the Existing Sales BOM Feature

Reason for change: Sales BOM feature is replaced by Assembly Management and is no longer supported in Microsoft Dynamics NAV 2013 R2.

Upgrade rules:

  • The following tables are deleted:

    • "BOM Journal Line"

    • "BOM Journal Template"

    • "BOM Journal Batch"

  • Data in fields "Inbound BOM Bin Code" and "Outbound BOM Bin Code" in Location table are deleted.

  • Data in fields "BOM Journal" and "Compress BOM Ledger" in Source Code Setup table are deleted.

  • Data in the BOM Ledger Entry and BOM Register tables are not deleted.

Changes to Table 88: BOM Journal Template

The following change is performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

All fields

:= blank

None.

Changes to Table 234: BOM Journal Batch

The following change is performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

All fields

:= blank

None.

Changes to Table 14: Location

The following change is performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

"Inbound BOM Bin Code"

:= blank

None.

"Outbound BOM Bin Code"

:= blank

None.

Changes to Table 242: Source Code Setup

The following changes are performed in Step 1 of the Data Upgrade:

Old Field Set To Data Moved To Conditions

"BOM Journal"

:= blank

None.

"Compress BOM Ledger"

:= blank

None.