‎2019 Aug 23 11:20 AM
I have been trying to get a straight forward query of Items (grouped) that are release to pick with the SUM amount filtered on them needing to be picked on the day it is run (CurrentDate().
I want it as ItemCode, ItemDscription, ItemGrpName, Released Amount - just for my Warehouse 01
I can't seem to get it to pull through correctly - either the filters block any data or it seems to be pulling to high a quantity through of the released stock items which makes me think it isn't just filtering to released stock on that required date.