Skip to main content

Hi all. I need to create a read only custom field in the Remote Warehouse Parts Planning screen that shows the result of On Hand Qty - Refill Point Qty. Is this possible on this screen ?

 

Hi @bear7364 
Yes, theoretically you can implement it. 
Use  SQL query in select statement with required where condition.
ex :
select ONHAND_QTY-REFILL_POINT_INV_QTY
from REMOTE_WHSE_PART_PLANNING

 

What is the issue you received while implementing this?

If you can explain it further, we can help on this.

-BR


Hi @bear7364 ,

This should be possible but when I look at the base view Remote_Whse_Assort_Part, it seems the 

On Hand Qty is not part of it. Hence it could get a bit tricky to fetch the values with a select statement. 

I suggest going through the following community article to workaround this. 

 

Custom Field - Select statement with two variables | IFS Community

 

Hope this helps!

 

Thanks,

Kasun