Using a data source to show demand against stock in specific location
Hi,
I am trying to create a lobby element to show demand vs current stock in specific locations instead of whole site. I have a data source that shows all current demand for site and to filter when demand qty > beginning onhand stock. I can’t figure out how to direct the search just to specific locations or warehouse.
Have tried adding various API.get info arguments but can’t seem to get it right.
Looking to have a value that will show Demand Qty > Stock in “X” location.
Any help will be greatly appreciated.
Page 1 / 1
Hello,
You could add the following into the condition
DEMAND_QTY=(select sum(qty_onhand) from &AO.inventory_part_in_stock where part_no=mrp_part_supply_demand_all.part_no and location_no = 'X')
However, I would suggest you create an IAL to fetch this data. You can then use the IAL as the view.
If you dont want to create the IAL then I would suggest getting a Technical Person to create a new API procedure to fetch the qty_onhand for the required locations.
Hi,
I have added your suggestion to my data source but sadly it did not work. Just gave me back a blank preview.
I will look into creating IAL but am new to this so will seek some assistance from our technical expert.
Thank you very much for your support :)
Did you change the = to >
Yes I did :)
from dual) and DEMAND_QTY > (select sum(qty_onhand) from &AO.inventory_part_in_stock where part_no=mrp_part_supply_demand_all.part_no and location_no = 'LRB1' or location_no = 'HCB1')
Tried with only one location defined also but still a blank return.
Is it returning blanks because there are no records where the demand qty > available stock?
I can use the select statement as shown below.
Got it! I was looking at it from the wrong way, change the > to < and works perfect!
