ReleaseUpdateDB60_Invent.allowNoDupInvtFsclLIFOJrnllTrnsAdjGrpIdx 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_Invent |
Method |
allowNoDupInvtFsclLIFOJrnllTrnsAdjGrpIdx |
Description |
Updates the GroupItemYearIdx index in the InventFiscalLIFOJournalTransAdj table not to allow for duplicate records. |
Affected Modules and Tables
Affected Modules |
---|
Inventory management |
Affected Tables |
---|
InventFiscalLIFOJournalTransAdj |
Remarks
The name of this method is truncated from allowNoDupInventFiscalLIFOJournalTransAdjGroupItemYearIdx. After updating the surrogate key InventFiscalLIFOGroup field with the value of the RecId field of the InventFiscalLIFOGroup table, the GroupItemYearIdx index is reset not to allow for duplicate records.