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 ?
Solved
Custom field to show the sum of 2 existing fields
+3Best answer by Kasun Balasooriya
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
This topic has been closed for comments
+18Hi
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
-Kelum Niranjana
1 person likes this
+20Hi
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
Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.