web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Using crossCompany wi...
Microsoft Dynamics AX (Archived)

Using crossCompany with update_recordset

(0) ShareShare
ReportReport
Posted on by ALAhmed 916

I have this script , i want use update_recordset. How can i use crossCompany from update_recordset? 

while select forUpdate crossCompany  Table
            where Table.dataAreaId  == _dataArea
            &&    Table.ItemId      == Table.ItemId
        {
            changecompany(Table.dataAreaId)
            {
                Table.Stopped = false;
                Table.update();
            }
        }


*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Alex,

    The crosscompany is not supported with update_recordset. You have to use the script you already provided yourself.

    Also have a look at Cross-Company Data Modification Using X++ [AX 2012]

  • Mea_ Profile Picture
    Mea_ 60,284 on at

    Hi Alex,

    You can use next script

    while select crossCompany Table
    where Table.dataAreaId  == _dataArea
       && Table.ItemId      == _itemId
{
    changecompany(Table.dataAreaId)
    {
        tableUpdate = null;

        select forUpdate tableUpdate 
            where tableUpdate.RecId == Table.RecId;
        if (tableUpdate)
        {
            tableUpdate.Stopped = false;
            tableUpdate.update();
        }
    }
}
  • Suggested answer
    Oleg Abapolov Profile Picture
    Oleg Abapolov 39 on at

    You must disable update method, database log and alerts, otherwise compiler will throw an error. Find more details in my post dynamicsaxhints.blogspot.com/.../specifics-of-updaterecordset.html

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans