We recently upgraded to GP 2013 and have discovered that if you filter a SmartList (e.g. Account Transactions) using "is between" filter on Account Number, then enter two GL codes, it is not returning any data. Anyone have an idea how to resolve this?
thanks
Ken
*This post is locked for comments
If this post has been useful to you, please Verify this answer. This could help others trying to solve the same or similar problem.
Hi,
There is already an interesting post regarding this issue here:
https://community.dynamics.com/gp/f/32/t/129966
We have not heard back from the original poster of the question, so we have to wait to see if anything has changed in the operation.
Any update on this? I am experiencing the same issue. Worked fine in 2013 but now returns no results after 2013 R2 Upgrade.
So, is there a chance that the two filters are crossing each other?
I know this is a simple request, but may I request that you remove the Date Filter and see what happens to the data?
Please post a screenshot of the filters of the SmartList you are using.
Here I am asking again, have you checked the 'Sorting' settings for Account field?
Yes. There's another "in between" filter on transaction date
Ken in addition to filter by Account Number using 'is between' are you adding any other filters?
So the problem is the sorting of the Account Number which is a composite field, perhaps somebody changed it by mistake. Have you checkED the 'Sorting' of this field:
Open the 'Account Format Setup' window: Microsoft Dynamics GP > Tools > Setup > Company and click 'Sorting' button.
It does work on other fields like Main, Department etc
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...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (