HI All,
I have a table in AX 2012 and it is just designed to store some data and not used anywhere in AX(i found the AOT and no reference of this table aywhere). Just a report is pulled from this table.
The fields in this table(TEST) are item type,item group,replace date, qty.
The table pk,clustered index is Surrogate Key and replacement index is (new index created on table with fields type,group and replace date which is als marked as Alternate key=Yes)
Problem is- when 2 different users(user id different) creates same record(item was replaced on same date) the system throws error that record already exist.
User A-TYpe(A). Group(N),Replace date-today, qty-1
UserB-Type(A),Group(N),Replace date-today, qty-1
I tried adding a new field as " Created by(properties of table-created by -Yes) in index. It allowed me to save the record with different user id. But when i was trying to add the field in index(created by) it gave me warning that adding field in key will affect the records)
Need to know if any implications will be there if i add "Created by" in the table index.
Also dont know why replacement key is marked as "Alternate key" by previous developers(new to AX)
Kindly reply.
