cross etiketine sahip kayıtlar gösteriliyor. Tüm kayıtları göster
cross etiketine sahip kayıtlar gösteriliyor. Tüm kayıtları göster
21 Kasım 2013 Perşembe
AXAPTA - Make a table field works cross-company
I learned this way from a forum . You have to just create a relation like up and care about extended data type of related fields. After that you won't need a custom lookup or supress validate method at forms. It works at AX 2009, I had no change to test with 2012.
AXAP - Cross company lookup
public void lookup(FormControl _formControl, str _filterStr)
{
CustTable custTable;
Query Query = new Query();
QueryBuildDataSource qbds;
SysTableLookup SysTableLookup =
SysTableLookup::newParameters(TableNum(CustTable), _formControl);
;
super(_formcontrol,_filterstr);
Query.allowCrossCompany(true);
Query.addCompanyRange(myTable.Company);
qbds = Query.addDataSource(TableNum(CustTable));
SysTableLookup.addLookupfield(FieldNum(CustTable, AccountNum), true);
SysTableLookup.addLookupfield(FieldNum(CustTable, Name));
SysTableLookup.parmQuery(Query)
SysTableLookup.performFormLookup();
}
Don't forget to supress control's validate method!..
{
CustTable custTable;
Query Query = new Query();
QueryBuildDataSource qbds;
SysTableLookup SysTableLookup =
SysTableLookup::newParameters(TableNum(CustTable), _formControl);
;
super(_formcontrol,_filterstr);
Query.allowCrossCompany(true);
Query.addCompanyRange(myTable.Company);
qbds = Query.addDataSource(TableNum(CustTable));
SysTableLookup.addLookupfield(FieldNum(CustTable, AccountNum), true);
SysTableLookup.addLookupfield(FieldNum(CustTable, Name));
SysTableLookup.parmQuery(Query)
SysTableLookup.performFormLookup();
}
Don't forget to supress control's validate method!..
Kaydol:
Kayıtlar (Atom)