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 


Rename many customer names. 


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;
     select firstOnly custTable
         where custTable.AccountNum == 'XXXX-WC-00002';
     if (custTable)
         custTable.AccountNum = 'XXXX-WC-00001';

1 comment: