ReleaseUpdateDB60_Cust.updateCustLedgerAccounts 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_Cust |
Method |
updateCustLedgerAccounts |
Description |
Updates CustInterest field of the CustLedgerAccounts table. Also transforms the old accounts or dimension field to the new account or dimension fields in Microsoft Dynamics AX 2012. |
Affected Modules and Tables
Affected Modules |
---|
Accounts receivable |
Affected Tables |
---|
CustLedgerAccounts |
Remarks
This upgrade is required in order to convert account or dimension data to the new accounts and dimension model for Microsoft Dynamics AX 2012.
Data Migration Section
From Table: CustLedgerAccounts |
To Table: CustLedgerAccounts |
---|---|
ClearingAccount |
ClearingLedgerDimension |
LiabilitiesForDiscountAccount |
LiabilitiesForDiscountLedgerDimension |
SumAccount |
SummaryLedgerDimension |
VATprepaymentsAccount |
VATPrepaymentsLedgerDimension |
WriteOffAccount |
WriteOffLedgerDimension |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
---|---|---|
CustLedgerAccounts |
ClearingLedgerDimension |
LedgerDimensionDefaultAccount |
CustLedgerAccounts |
LiabilitiesForDiscountLedgerDimension |
LedgerDimensionDefaultAccount |
CustLedgerAccounts |
SummaryLedgerDimension |
LedgerDimensionDefaultAccount |
CustLedgerAccounts |
VATPrepaymentsLedgerDimension |
LedgerDimensionDefaultAccount |
CustLedgerAccounts |
WriteOffLedgerDimension |
LedgerDimensionDefaultAccount |
Deleted Tables or Fields
Table |
Field |
---|---|
custLedgerAccounts |
DEL_InterestCode |
CustLedgerAccounts |
ClearingAccount |
CustLedgerAccounts |
LiabilitiesForDiscountAccount |
CustLedgerAccounts |
SumAccount |
CustLedgerAccounts |
VATPrepaymentsAccount |
CustLedgerAccounts |
WriteOffAccount |