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.



Add Comment
2 Answer(s)

I don’t believe inventory transfers play nice this way.  I think it is doable with transfer orders, though.

Intermediate Answered on May 26, 2021.
Add Comment


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

RE: Inventory Transfer - Locations

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.


Edo Aroni









Beginner Answered on September 27, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor