Category: update_recordset

AX – D365FO – How to count affected/updated rows in a Update_recordset statement

Posted on by Marco Saad

How to know how many rows have been updated in a Update_recordset statement? It's simple, you can just use rowCount() method of the table after the update statement like shown below update_recordset inventTable setting XXXCommercialGroupId = comunanzaXXX.SubGroupId join comXXX where inventTable.ItemId == comXXX.comunanzaCode && comXXX.SubGroupId != ''; info(strFmt("Copy Items from comXXX Subgroup Id to InventTable … Continue reading AX – D365FO – How to count affected/updated rows in a Update_recordset statement →

AX – D365FO – Using update_recordset with CrossCompany statement

Posted on by Marco Saad

If you have tried to use Update_recordset with CrossCompany option you'll probably have faced this error : "Cannot update multiple records in yourTable(yourTable).Cross company update_recordset operation should skip database logging." The reason is because you have to disable database logging before to proceed To solve this issue you must use these methods : yourTable.skipDataMethods(true); yourTable.skipDatabaseLog(true); … Continue reading AX – D365FO – Using update_recordset with CrossCompany statement →