Pages

Tuesday, September 4, 2018

D365FO: Renaming the primary key through coding

Noted:  This content is based on Dynamics 365 for Finance and Operations version 8.0 Platform Update 15 



Scenario: 

Rename many customer names. 


Solution: 

If the table has many relations, it will take a long time to rename through the record information one by one.  We can use the table method renamePrimaryKey() in a batch class and run in batch mode.   


     CustTable custTable;
     ttsBegin;
     select firstOnly custTable
         where custTable.AccountNum == 'XXXX-WC-00002';
     if (custTable)
     {
         custTable.AccountNum = 'XXXX-WC-00001';
         custTable.renamePrimaryKey();
     }    
     ttsCommit;





1 comment: