How to update data through Excel Add-In

Finance and Operations/AX Developer Forum
1

Hi,

A new field in inventtable is added. I tried to update the new field data through excel add-in but the records did not get published by throwing an error message that the items already exist rather than updating the existing record.

Item number Product.Product number Kit
21SM0156 21SM0156 1
21SM0169 21SM0169 1
BC28515 BC28515 3
BC29053 BC29053 3
BC30376 BC30376 1
BC34076 BC34076 3
Item number Error Messages
21SM0156 Cannot create a record in Item table (RetailInventTable). Item number: 21SM0156. The record already exists. Document Generic document could not be created. Error details: Cannot create a record in Item table (RetailInventTable). Item number: 21SM0156. The record already exists.

Is excel add-in only for insertion and not for updating existing record?

Is there a way to update the new field data ? There are 1800 records to be updated.

Thanks,

2

Yes …you can update the table records using Excel add-in…

Please refer this link…

If it throws the error like “record already exists”… Check all the related tables

3

I tried but did not work out. Also I am not able to do debugging from excel add-in. So not sure from where the validation is initiated.

can some one guide me how to do debugging from excel add-ins?

When excel add-in tries to publish, could someone explain which AOT object will be initiated and where should the breakpoint must be set to initiate the debugging?

Thanks,