ReleaseUpdateDB60_Ledger.allowNoDupLedgerOpeningTable_ESShMnAc Upgrade Script

  • Article

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

Class

ReleaseUpdateDB60_Ledger

Method

allowNoDupLedgerOpeningTable_ESShMnAc

Description

Updates the ShMnAcctIdx index in the LedgerOpeningTable_ES table not to allow for duplicate records.

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

LedgerOpeningTable_ES

Remarks

After updating the MainAccount surrogate key field with the value of the record ID field of the LedgerOpeningTable_ES table, the ShMnAcctIdx index is reset not to allow for duplicate records.