ReleaseUpdateDB60_Asset.updateLtAssetPackingSlip Upgrade Script

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Class

ReleaseUpdateDB60_Asset

Method

updateLtAssetPackingSlip

Description

This method updates the LtAssetPackingSlip and LtAssetPackingSlipLine tables.

Affected Modules and Tables

Affected Modules

Fixed Asset

Affected Tables

LtAssetPackingSlip

LtAssetPackingSlipLine

Remarks

Updates the LtAssetPackingSlip surrogate key column based on the LtAssetPackingSlip table in the LtAssetPackingSlipLine table. Updates the LtAssetPackingSlipLine table by migrating the value of the responsible from and location from values from the LtAssetPackingSlip table as the information was moved from the header record to the line record. The DEL_DepartmentFrom and DEL_DepartmentTo columns are marked for deletion, however, they are not migrated. The reason is that the column is a different entity between Ax 2009 and Ax 2012, and during the update it is not possible to determine the intent of the column.

Data Migration Section

From Table: LTAssetPackingSlip

To Table: LTAssetPackingSlipLine

DEL_ResponsibleFrom

ResponsibleFromId

DEL_AssetLocationIdFrom

AssetLocationIdFrom

Deleted Tables or Fields

Table

Field

LTAssetPackingSlip

DEL_DepartmentFrom

LTAssetPackingSlip

DEL_DepartmentTo