Announcements
Hi Experts,
Do you know how to use Smart List to search multiple accounts transactions at in one certain period of month once together?
For example, I want to run accounts 3410 and 3660 transactions for period 1st May to 31 May.
Smart List- I filed out three criteria: account number contains 3410; account number contains3660; Transaction Date 1/5-31/5, then I choose match1 or more; get nil transactions which are wrong.
Any ideas ?
Thanks you very much in advance
Regards,
Hi,
You won't be able to get this kind of results out of smartlist with the basic filters..
Either you'll to resort to Excel or SSRS reports, this way you can filter on multiple values from within the Account number column...
Excel and SSRS out-of-the-box reports should do the job and are free, part of the GP reporting setup.
I don't think you can use contain with two different values.
Create SQL view and then by using Smartlist Designer create new smartlist.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156