ReleaseUpdateTransformDB50_Asset.assetTableValidate_WorkerContactName Upgrade Script

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

Class

ReleaseUpdateTransformDB50_Asset

Method

assetTableValidate_WorkerContactName

Description

Validates a string value in the ContactName field in the AssetTable table and verifies whether it is actually a valid user in the system.

Script Type

Upgrade readiness scripts

Microsoft Dynamics AX Source

Microsoft Dynamics AX 4.0

Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules

Fixed Asset

Affected Tables

AssetTable

Shadow_AssetTable

Validation Issues

Validation Issues Description

Validates the ContactName field in the AssetTable table.

Checked Conditions

The ContactName value needs to be a valid user from the SysCompanyUserInfo table.

Mitigation/How-to-fix

The invalid user ID needs to be corrected by a user.