In Microsoft Dynamics AX 2012 is a standard functionality to rename Primary Key. It renames primary key in master table and all allowed corresponding tables.
User perspective
To change primary key in Dynamics AX 2012 you need to select record, right click on it and select Record info. In Record information form click Rename button, write new ID and click OK. System will ask if you are sure to rename from old to new ID – click Yes. After that system will try to change that key and if there will be no issues it will do it.
Developer perspective
To include table in automated key change it needs to be directly related. This means it has to have:
Relations
- In AOT on table in Relations node needs to be added relation to master table on primary key.
- Relation must have property Validate set to Yes.
EDT
- EDT used needs to have relation or reference to primary key on master table.
- Table must use the same or extended EDT like primary key in master table.
- Field need to have property IgnoreEDTRelation set to No.
To include additional not directly related table you need to overwrite renamePrimaryKey method. Below is example code for that in ProjTable – to make it shorter I removed standard code from that method:
server void renamePrimaryKey(boolean psaIncluedeSubProjects = true)
{
ProjTable originalRecord;
VendInvoiceInfoLine_Project vendInvoiceInfoLine_Project_group;
VendInvoiceInfoLine_Project vendInvoiceInfoLine_Project;
ttsBegin;
originalRecord = this.orig();
while select crossCompany vendInvoiceInfoLine_Project_group
group by DataAreaId
where vendInvoiceInfoLine_Project_group.ProjDataAreaId == this.dataAreaId
&& vendInvoiceInfoLine_Project_group.ProjId == originalRecord.ProjId
{
changeCompany(vendInvoiceInfoLine_Project_group.dataAreaId)
{
update_recordSet vendInvoiceInfoLine_Project
setting ProjId = this.ProjId
where vendInvoiceInfoLine_Project_group.ProjDataAreaId == this.dataAreaId
&& vendInvoiceInfoLine_Project_group.ProjId == originalRecord.ProjId;
}
}
super();
DimensionStorage::syncRenamedValue(this, originalRecord);
ttsCommit;
}
If the specific table is used in dimensions then it is really important to also update them. We can do this calling method DimensionStorage::syncRenamedValue(this, originalRecord).
