Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SmartList not Populati...
Microsoft Dynamics GP (Archived)

SmartList not Populating All Journal Entries

(0) ShareShare
ReportReport
Posted on by Community Member

I am running a smartlist for a client that has restrictions to bring in all journal entries for a specified account, facility number and all of 2014. The issue I am running into is that there is a specific journal entry that has a trx date of 9/30 and also 12/31/14 (but posted in 2015 with BBF source doc type) that I can see in JE inquiry and verify the facility ID. I would expect that both of the entries would show up in the smartlist, but only the BBF record is showing up. The kicker, is that there 4 JE's that should behave this way, 2 show up as expected, 2 do not. Any suggestions would be great.

Also, The client is using Binary Stream (facility ID's assigned).

*This post is locked for comments

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at
    RE: SmartList not Populating All Journal Entries

    Thanks for the follow-up Jason.  Glad you figured it out.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: SmartList not Populating All Journal Entries

    After consulting with Binary Stream support we found that there were records in one of the Binary Stream tables that were missing either batch numbers or Facility ID's. We cleared that table to push them back to the assign facility utility. Once reassigned, they were showing up correctly in SmartList.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at
    RE: SmartList not Populating All Journal Entries

    Sure thing.  I'd recommend reaching out to Binary Stream support then.

  • Community Member Profile Picture
    Community Member on at
    RE: SmartList not Populating All Journal Entries

    Yes, I have verified that there is nothing to be assigned, as well as making sure the facility assigned is correct. Thanks so much for the quick response.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at
    RE: SmartList not Populating All Journal Entries

    Have you looked in the MEM Facility Assignment window to see if there are any JE's missing a facility assignment?

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans