Hi ,
I am trying to select Sum of accounts's AmoustMST for that particular Voucher series.
///For example I want to sum up all accounts only for the voucher F111*.
I can not do a substr in the select WHERE clause as its a database field.
'select LedgerTrans where LedgerTrans.Accountnum >= 1000 && LedgerTrans.AccountNUm <=2000 && LedgerTrans.TrandsDate= 1\1\2004 && LedgerTrans.Voucher == 'F111%' is not working......
I thought F111% is equal to F111*.
How can I selectively select this one?.
Can some one help please?
Thanks,
Padmaja Iyer.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
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.