Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

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

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,  

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator 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 10,996 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans