delete duplicate in axapta .If there is duplicate record in table then use this job to delete duplicate. If two name like sks and sks then one will be delete and one will remain. static void deleteduplicate(Args _args) { Set fieldSet = new set(Types::Integer); // create dictindex from the unique index DictIndex dictIndex = new DictIndex( tablenum(_RegistrationDetails), indexnum(_RegistrationDetails, Index1)); ; // these are the fields from the index // add them to a set fieldSet.add(fieldnum(_RegistrationDetails, _RegistrationNo)); // fieldSet.add(fieldnum(YourTable, YourTableFieldId2)); // set allow duplicates ReleaseUpdateDB::indexAllowDup(dictIndex); // delete duplicate records ReleaseUpdateDB::deleteDuplicatesUsingIds(tablenum(_RegistrationDetails), 0, fieldSet); // reenable index ReleaseUpdateDB::indexAllowNoDup(dictIndex); info("done"); }
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .