20 Şubat 2015 Cuma

Lookup method to other Companies for Axapta 2009

public void lookup()
{


   SysTableLookup       sysTableLookup = SysTableLookup::newParameters(tablenum(InventLocation), this);
    Query                query = new Query();
    QueryBuildDataSource queryBuildDataSource;
    ;

    sysTableLookup.addLookupfield(fieldnum(InventLocation, InventLocationId));
    sysTableLookup.addLookupfield(fieldnum(InventLocation, Name));
    sysTableLookup.addLookupfield(fieldnum(InventLocation, InventSiteId));

    queryBuildDataSource = query.addDataSource(tablenum(InventLocation));
    queryBuildDataSource.addRange(fieldnum(InventLocation,         InventLocationType)).value(queryValue(InventLocationType::Standard));

    changecompany('your other company code')
    {
       sysTableLookup.parmQuery(query);
       sysTableLookup.performFormLookup();
    }
}

Hiç yorum yok: