RE: Inventory Transfer – Locations
I need to produce a search that displays Inventory transfers to and from a particular location.
It seems on Inventory transfers the to and from location is utterly useless natively. I can get them to show using a formula:
From: case when nvl({quantity},0) < ‘0’ then {location} else null end
To: case when nvl({quantity},0) >= ‘1’ then {location} else null end
Is there a way I can adapt this in the Criteria to only show a certain From and To location? I cant thing of a way to do it it. Worst case I will need to export to excel and Filter there.
I don’t believe inventory transfers play nice this way. I think it is doable with transfer orders, though.