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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,645
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (