Malcolm & James,
Thanks so much for your reply. That is exactly what I was looking for and solved my problem.
Sincerely,
Bob
Bob Brinker
Oakdene Group, Inc.
2625 Butterfield Rd. (Suite 212E)
Oak Brook, IL 60523-1261
(630)368-1046 x/230
(630)368-1050 (Fax)
[EMAIL PROTECTED]
"Malcolm Burtt" <[EMAIL PROTECTED]>
11/08/2004 12:56 PM GMT
Please respond to Axapta-Knowledge-Village
To: <[EMAIL PROTECTED]>
cc:
bcc:
Subject: RE: [Axapta-Knowledge-Village] Adding Conditions to the Range of a Query
Hi
Try the following....
queryBuild.dataSourceTable(tableNum(SalesLine)).addRange(fieldnum(SalesLine,remainSalesFinancial)).value(">0");
Malcolm Burtt
Global IT Group
"Business Solutions designed for YOUR business processes"
Global IT Group is the trading name of Touchstone Global Business Solutions Ltd. and is part of the Touchstone Group PLC.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 08 November 2004 13:48
To: [EMAIL PROTECTED]
Subject: [Axapta-Knowledge-Village] Adding Conditions to the Range of a Query
Hi All,
Ho do I modify the SalesNotInvoiced report to only print lines for items
with delivered quantity that has not been invoiced? I thought it could be
done by modifying the range of a query but have not been successful ib
getting it donne.
The field I want to test is RemainSalesFinancial which is in the embedded
data source SalesLine and I only want OrderLine records where
RemainSalesFinancial > 0. The first data source is the SalesTable.
thought it could be done by modifying the prompt method but could not get
past the syntax, etc. The code in the prompt method is shown below and the
statement I added is the 3rd queryBuild.
Any help, comments, suggestions, etc will be greatly appreciated.
boolean prompt()
{
Query queryBuild;
boolean ret;
;
ret = super();
queryBuild = this.query();
queryBuild.dataSourceTable(tableNum(SalesLine)).addRange(fieldnum(SalesLine,
salesStatus)).value(enum2value(SalesStatus::Backorder));
queryBuild.dataSourceTable(tableNum(SalesLine)).addRange(fieldnum(SalesLine,
salesStatus)).value(enum2value(SalesStatus::Delivered));
queryBuild.dataSourceTable(tableNum(SalesLine)).addRange(fieldnum(SalesLine,
remainSalesFinancial)).value(RemainSalesFinancial>0);
this.query(queryBuild);
return ret;
}
Thanks,
Bob
Bob Brinker
Oakdene Group, Inc.
2625 Butterfield Rd. (Suite 212E)
Oak Brook, IL 60523-1261
(630)368-1046 x/230
(630)368-1050 (Fax)
[EMAIL PROTECTED]
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor | |
| |
|
Yahoo! Groups Links
- To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.