Hello, I am trying to filter all open sales orders with total amount zero in all sales orders view. I can't manage to figure out which filter to use. I have tried different options and I think the issue is I cannot use 0 as value (e.g. total amount or invoice amount = 0). It needs to be something else. Anyone able to help?
*This post is locked for comments
Sales order (SalesTable) doesn't have any fields that could be used to filter by amount. Instead the amount of the order can be seen by the sum of the sales lines. But you can't filter by that. So I think your problem is more about being able to filter sales order by amount in the first place. Once you achieve that, you should be able to filter by zero as well. If not, just filter by "<0,01" or something to get the same result.
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
