ReleaseUpdateDB60_Invent.allowDupTaxInventVATCommodityCode_INItem Upgrade Script

  • Article

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

Class

ReleaseUpdateDB60_Invent

Method

allowDupTaxInventVATCommodityCode_INItem

Description

Updates the ItemLogisticAddressStateIdx index in the TaxInventVATCommodityCode_IN table to allow duplicate records.

Affected Modules and Tables

Affected Modules

Inventory management

Affected Tables

TAXINVENTVATCOMMODITYCODE_IN

Remarks

The StateId field is replaced with the new LogisticsAddressStateId global address field in the unique ItemLogisticAddressStateIdx index. Initially this field contains no value. So the index is set to allow duplicates before the field is updated with the value of the RecId field of the TaxInventVATCommodityCode_IN table.