X++ Job to duplicate Table records in Multiple companies/ legal entities.
During development in AX some times there comes the requirement to Duplicate records of a specific Table in Multiple Companies (if the table is not shared), this requirement also occurs during Data Upgrade from AX 4.0 / 2009 to AX 2012 in the multi site activation scenario when we are requitred to remove some tables from table collection (specified during readiness step) and once the table is removed from table collection , it is required to duplicate its data in all those companies / entities which were the part of that particular table collection (virtual companies of the table collection): there could be multiple approaches to Duplicate records in Multiple companies , the approach i will be discussing in this blog is very simple and suitable in the scenario where there is huge data (more than million of records) for better performance it can also be used if there is less data :-) . Steps are mentioned as below: 1. First duplicate the desired table (i.e. in my case i want