Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Amy Axness]

I am trying to update a custom field in the InventTable in AX 2012 R2 CU6 using the Excel Add In and I am getting the following error message. 

Cannot create a record in Items – storage dimension groups (EcoResStorageDimensionGroupItem). Item number: 2300CW2, ST-WH-LOC. The record already exists. Document Generic document could not be updated. Error details: Cannot create a record in Items – storage dimension groups (EcoResStorageDimensionGroupItem). Item number: 2300CW2, ST-WH-LOC. The record already exists.

The process I used was – Add Data -> Add Tables -> InventTable.  The item number and product.product number fields are mandatory, then I added the UPC Code (our custom field).  I clicked refresh to retrieve the values in AX.  Then I updated the UPC Codes for the ones that were missing and clicked publish.

Has anyone else run into this?  I am not trying to create an item, just update it.  Any suggestions?

——————————
Amy Axness
Controller
J&D Manufacturing
Eau Claire WI
——————————

[Scott Morley]

Amy,
I ran into this about a year ago. The issue is with the AXInventTable class. When an update happens it calls an insert of the DimensionGroupItem without checking if an existing record is there first. Below is the code I used to fix it. I did some testing of it, but the customer was hesitant to change the dimension code so it was never implemented, so I can’t share long term effects. 

In Classes -> AXInventTable -> write I added two IF statements to skip the Dimension group write if it exists: 

// storage dimension group is optional; only write if it is set
if ( axEcoResStorageDimensionGroupItem.parmStorageDimensionGroup() != 0
&& axEcoResStorageDimensionGroupItem.parmItemId())
{
//S Morley – if default dimension exists, the write will fail. Validate the record does not exist first
if (!EcoResStorageDimensionGroupItem::findByItem(axEcoResStorageDimensionGroupItem.parmItemDataAreaId(), axEcoResStorageDimensionGroupItem.parmItemId()).RecId)
axEcoResStorageDimensionGroupItem.write();
}

// tracking dimension group is optional; only write if it is set
if ( axEcoResTrackingDimensionGroupItem.parmTrackingDimensionGroup() != 0
&& axEcoResTrackingDimensionGroupItem.parmItemId())
{
//S Morley – if default dimension exists, the write will fail. Validate the record does not exist first
if (!EcoResTrackingDimensionGroupItem::findByItem(axEcoResTrackingDimensionGroupItem.parmItemDataAreaId(), axEcoResTrackingDimensionGroupItem.parmItemId()).RecId)
axEcoResTrackingDimensionGroupItem.write();
}

——————————
Scott Morley
Principal Application Architect
OneNeck IT Solutions
Bend OR
——————————
——————————————-

[Colby Gallagher]

I’ve run into this before a few times.  Your storage and / or tracking dimension groups are defined at the product level in addition to the released product level.  You only need them at the released product level unless for some reason you want to force all companies in your instance of AX to have the same storage / tracking dims for a given product. Delete the storage / tracking dimensions at the product level and you will be able to update InventTable via the add-in.    You can do the delete in either the client or via the add-in.   

Reminder, do this in a sandbox or on one Product # first please.

——————————
Colby Gallagher
Manufacturing Systems Consultant
Agility Business Solutions
Brecksville OH
——————————
——————————————-