Select from multiple companies

kovorka

:-k

Hi All,

I want to do a select statement from multiple companies from inside AX.
basically, I want to ignore the DataAreaId field for the tables I'm working
with.

I want to do this because I need to view information from all companies as a convenience thing for an administrator to approve things from all companies, instead of changing from one company to the other. This feature will ultimately be used in the Enterprise portal. Not sure if there's an easier way to do this...

Harish

Hi,

From Ax, changing companies is straight forward. Example -

changeCompany(salesTable.interCompanyCompanyId)
    {
        purchLine = PurchLine::find(salesTable.interCompanyPurchId, salesLine.lineNum, true);

        if (purchLine)
        {
            purchLine.interCompanySkipUpdate = true;
            purchLine.delete();
        }
    }

Does this help?

Kind regards,