Adding Last_Total_Unit_Cost of an item by warehouse to SO field

SUGGESTED

Hello Everyone!

I am looking for a quicker and easier way to ascertain the last total unit cost of an item in a specific warehouse. Our organization has multiple warehouses and sometimes landed freight charges vary for different items based on their warehouse location. Thus, sometimes when we go to sell an item out of a different warehouse, the true cost is overlooked or missed and sales happen at very low profit percentages or break evens.

My question is - Is there a way to add a custom grid field to the SO Entry screen? We would like to retrieve the last total unit cost of the item in the respective warehouse it is pulling from without having to dig into cost detail for every individual item.

Does anyone know where to start looking in order to achieve this?

Thanks all!
-Josh