ReleaseUpdateDB60_Vend.updateVendLedgerAccounts 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	ReleaseUpdateDB60_Vend
Method	updateVendLedgerAccounts
Description	Transforms data from the old account and dimension fields to the new account and dimension fields in the VendLedgerAccounts table.

Affected Modules and Tables

Affected Modules
Accounts payable

Affected Tables
VendLedgerAccounts

Remarks

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

Data Migration Section

From Table: VendLedgerAccounts	To Table: VendLedgerAccounts
ClearingAccount	ClearingLedgerDimension
PurchLedgerAccount	PurchasingLedgerDimension
PurchLedgerOffsetAccount	PurchasingOffsetLedgerDimension
SumAccount	SummaryLedgerDimension
VATprepaymentsAccount	VATPrepaymentsLedgerDimension

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
VendLedgerAccounts	ClearingLedgerDimension	LedgerDimensionDefaultAccount
VendLedgerAccounts	PurchasingLedgerDimension	LedgerDimensionDefaultAccount
VendLedgerAccounts	PurchasingOffsetLedgerDimension	LedgerDimensionDefaultAccount
VendLedgerAccounts	SummaryLedgerDimension	LedgerDimensionDefaultAccount
VendLedgerAccounts	VATPrepaymentsLedgerDimension	LedgerDimensionDefaultAccount

Deleted Tables or Fields

Table	Field
VendLedgerAccounts	ClearingAccount
VendLedgerAccounts	PurchLedgerAccount
VendLedgerAccounts	PurchLedgerOffsetAccount
VendLedgerAccounts	SumAccount
VendLedgerAccounts	VATPrepaymentsAccount