Hello,
I like to have a sheet showing only transfer lines where the Outstanding QTY is <>0
I thought is would be:
=NL("Rows","Transfer Line",,"DataSource=","NAV2013SQL","Company=",$C$2,"Recipient",$C$5,"Outstanding Quantity","<>0")
But when I execute requesting column with NF I get also results from lines where outstanding Qty = 0.
Where did I go wrong?
Thanks.!
If that table can have fractional outstanding quantity (e.g., 0.00000002), that could explain the issue. Your filter would not filter it out (it is *not* zero), but if your NF() function is formatted to only show an integer, you would only see the zero.
If this is not the issue, I would suggest you create a Support Ticket so that you can share you report with Jet Reports Technical Support.
Hi Harry,
I found my error.
In Nav when you create an transfer from one to an other warehouse, Nav makes a Ship and receive line in one transfer order.
So every transfer line is double (one ship an one receive).
When the item then is shipped, but not yet received there still is an outstanding QTY.
So I filterd only the ship lines and it is now ok.
Thanks.!!