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.
Hi
I might missing something here but I do not understandand why you need to use a formula for you query. I will use a saved search (based on Transaction) and on the criteria I would have use expressions as in the below example
In the system used for the example the location is renamed Warehouse and it is point to the specific location CAN-1.
I am not sure how they are named on your system
On the result you can include the fields Warehouse, To Warehouse, Quantity and any other field that is necessary for your analysis.
I hope this makes sense.
Cheers
Edo Aroni
