ReleaseUpdateDB60_Prod.updateWrkCtrTable Upgrade Script [AX 2012]

Updated: July 22, 2010

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

Class

ReleaseUpdateDB60_Prod

Method

updateWrkCtrTable

Description

Transforms data from the AccountNumber and Dimension fields to the LedgerDimension and DefaultDimension fields, respectively, in the WrkCtrTable table.

Affected Modules

Production

Affected Tables

WrkCtrTable

This upgrade is required in order to convert account and dimension data to the new accounts and dimension model for Microsoft Dynamics AX 2012.

From Table: WrkCtrTable

To Table: WrkCtrTable

AccountWIPIssue

WIPIssueLedgerDimension

AccountWIPValuation

WIPValuationLedgerDimension

AccountWrkCtrIssueOffset

ResourceIssueOffsetLedgerDimension

AccountWrkCtrIssue

ResourceIssueLedgerDimension

Dimension

DefaultDimension

Table

Field

Extended Data Type

-or- Base Enum

WrkCtrTable

WIPIssueLedgerDimension

LedgerDimensionAccount

WrkCtrTable

WIPValuationLedgerDimension

LedgerDimensionAccount

WrkCtrTable

ResourceIssueOffsetLedgerDimension

LedgerDimensionAccount

WrkCtrTable

ResourceIssueLedgerDimension

LedgerDimensionAccount

WrkCtrTable

DefaultDimension

DimensionDefault

Table

Field

WrkCtrTable

AccountWIPIssue

WrkCtrTable

AccountWIPValuation

WrkCtrTable

AccountWrkCtrIssueOffset

WrkCtrTable

AccountWrkCtrIssue

WrkCtrTable

Dimension


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: