Hi Padmaja,
It seems Axapta doesn't have wildcard (for this). (it does for other
things)
I can only think of a trick to do this.
Instead of:
LedgerTrans.Voucher == 'F111*'
Use:
LedgerTrans.Voucher >= 'F111' && LedgerTrans.Voucher < 'F112'
Regards,
Nico
--- In development-axapta@yahoogroups.com, Padmaja Iyingar
<[EMAIL PROTECTED]> wrote:
>
> 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
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.