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 ?
Best answer by Kasun Balasooriya
View original
This topic has been closed for comments
Userlevel 7
+18
Hi
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
Userlevel 7
+20
Hi
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.