Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

how to use Smart List to search multiple accounts transactions in certain month at once together?

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

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,  

Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: how to use Smart List to search multiple accounts transactions in certain month at once together?

    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.

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: how to use Smart List to search multiple accounts transactions in certain month at once together?

    I don't  think you can use contain with two different values.

    Create SQL view and then by using Smartlist Designer create new smartlist.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans