Hi, is it possible to return rows based on a NL("Sum") calculation?
I am trying to find items that have only sold a quantity of between 1 and 3 in a certain date range for a particular location code. My report is using the Navision Item Ledger Entry table.
Thanks
Steve
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
that is possible, but you could try to use an easier way.
in your item-table the should be e.g. a field like "Sales (qty)", which is refering to the value-ledger entries and item-ledger-entries.
And you can use it with setting filters on the fileds "datefilter" and "locationfilter".
give it a try…
regards
jetsetter
Please sign in to leave a comment.