Hi Everyone,
I have a couple of question regarding the use of insert_recordset and CrossCompany . I reviewed old post and Documentation regarding the use of insert_recordset and crossCompany (https://docs.microsoft.com/en-us/dynamicsax-2012/developer/cross-company-data-modification-using-x?redirectedfrom=MSDN), and for older Dynamics AX versions it has been said that this is not allowed. Now, if I try to perform this in D365FO, let's say an example like this one:
insert_recordset tmpTable(Number, Date, Vendor)
select crosscompany RecId, Date
from secondaryTable
group by RecId, date
where secondaryTable.Field = Value
join Party
from vendTable
group by Party
I receive the followin error:
CrossCompany insert_recordset Operations is allowed only for admins.
So my questions are:
1. ¿Can we use both keywords? - since it was being said this wasn´t allowed.
2. If indeed we can use both keywords, is there a way to make the procedure available for role-based security (Only SysAdmins would be able to run functionality tied to those statements).
3. Is there oficial documentation to support this?
Regards,
