ReleaseUpdateTransformDB40_LedgerTrx.validateLedgerTrans_AcctDim 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 |
ReleaseUpdateTransformDB40_LedgerTrx |
Method |
validateLedgerTrans_AcctDim |
Description |
Performs validation to ensure that the records in LedgerTrans table have valid values for the AccountNum and Dimension fields. |
Script Type |
Upgrade readiness scripts |
Microsoft Dynamics AX Source |
Microsoft Dynamics AX 4.0 |
Affected Modules and Tables
Affected Modules |
|---|
General ledger |
Affected Tables |
|---|
LedgerTrans |
|
Validation Issues | |
|---|---|
|
Validation Issues Description |
There may be a situation where the LedgerTrans table contains a record with an invalid value for the AccountNum or Dimension fields. The account and dimension must exist in the LedgerTable table in order for the upgrade to proceed. |
|
Checked Conditions |
Checks to ensure the values for the AccountNum and LedgerTrans fields in the LedgerTrans table. The Dimension field contains values found in the LedgerTable table. |
|
Mitigation/How-to-fix |
Modify the existing LedgerTrans record to hold a valid value for both the AccountNum and Dimension fields. These values must exist in the LedgerTable table. |