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.

 

 

Add Comment
2 Answers

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

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.

Cheers

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.