Good morning,
i am trying to get a column in my data source that shows the warehouse location of the Avail Qty from the Supply Site on a Distribution Order. I was able to pull the Avail Qty from the Supply site just need to find a way if possible to pull the Warehouse the Avail Qty is in. thank you in advance
Avail Qty Column SQL
&AO.Inventory_Part_In_Stock_API.Get_Inventory_Qty_Onhand(SUPPLY_SITE,PART_NO,'*')
Screen Shot of Preview Screen
Best answer by paul harland
View original