PO dropdown

Finance and Operations/AX Developer Forum
1

Hi,

In one of my form’s i want to display the purchase order numbers(in a drop down),whose status is “not invoiced”

-Regards,

Rajee

2

hai raji,

write a look up method!!

3

yes,i was also trying the same,but how to give the condition?

4

http://www.axaptapedia.com/SysTableLookup_class

5

Hi Rajarajeshwari,

In which form you trying add…

add this code in that form [Form – Datasource – Field(PurchId) – methods – override the lookup() method as follows]…it will solve the prob

public void lookup(FormControl _formControl, str _filterStr)
{
SysTableLookup sysTableLookup;
Query query;
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
;
sysTableLookup = SysTableLookup::newParameters(tablenum(PurchTable), _formControl);
sysTableLookup.addLookupfield(fieldnum(PurchTable, PurchId));

query = new Query();
queryBuildDataSource = query.addDataSource(tablenum(PurchTable));
queryBuildRange = queryBuildDataSource.addRange(fieldnum(PurchTable, PurchStatus));
queryBuildRange.value(queryValue(PurchStatus::Invoiced));
sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();
}

Naresh Kolli

6

Got it !!!

public void lookup()
{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(PurchTable), this);
Query query = new Query();
QueryBuildDataSource queryBuildDataSource = query.addDataSource(tablenum(PurchTable));
;
sysTableLookup.addLookupfield(fieldnum(PurchTable, PurchId));
sysTableLookup.addLookupfield(fieldnum(PurchTable, PurchName));
sysTableLookup.addLookupfield(fieldnum(PurchTable,PurchStatus));
queryBuildDataSource.addRange(fieldnum(PurchTable, PurchStatus)).value(enum2str(PurchStatus::Backorder));
queryBuildDataSource.addRange(fieldnum(PurchTable, PurchStatus)).value(enum2str(PurchStatus::Received));
queryBuildDataSource.addRange(fieldnum(PurchTable, PurchStatus)).value(enum2str(PurchStatus::Canceled));
queryBuildDataSource.addRange(fieldnum(PurchTable, PurchStatus)).value(enum2str(PurchStatus::None));

sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}

7

Thanks ppl for the support,

But naresh,please note i wanted to list all the PO’s with other status except the ststus “invoiced”.

8

HI Rajee,

Your code is right , is it not working…?