msdynamicsax: selecting data from multiple companyaccounts

[Blog bot]

Источник: http://msdynamicsax.wordpress.com/20...mpanyaccounts/
==============


Some of you might have heard about the new reserved word in x++ called crossCompany. It enables you to select data across multiple companies in Ax without the use of changecompany (which I hated)

Anyway, this is an example of how it works:

static void getTotalLineAmount(Args _args)
{
    SalesLine       salesLine;
    container       companies = ['dmo', 'dm2', 'dm3']; // specify the companyaccounts to select from
    ;
    select crossCompany : companies sum(LineAmount) from salesLine;
   
    info (num2str(salesLine.LineAmount,0,2,1,2));
}




Источник: http://msdynamicsax.wordpress.com/20...mpanyaccounts/