16 May 2011

Crosscompany to get data from other companies / Get the data from other companies

CrossCompany is the Keyword to get the data from other companies..

static void CrossCompany_test(Args _args)
{
CustTable custTable;
container conCompanies = [ 'USMF', 'USRT', 'USSI' ]; // you can assign the selected company
str comp;
;

while select crossCompany : conCompanies * from custTable
{
info( custTable.AccountNum + " : " + custTable.name() + " : " + custTable.dataAreaId);
}


}

1 comment:

  1. will this work if table is storing data dat is not specific to the company???

    ReplyDelete

Give me the commetns and solutions

Merge Dimensions (MainAccountId and LedgerDimensions) defaultDimension in D365 F&O and X++

 public DimensionDynamicAccount getLedgerDimension(container _conData, TransDate _transDate = today()) {     int                            ...