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

  • 0
    SUGGESTED

    If you are using Lot/Serial valuation, the easiest thing to do would be to add the true tier values to the LotSerial selection grid (not the Lines grid).

    Otherwise you are looking at a really complicated script to query transaction history / or cost tier data and calculate the value.  Sage doesn't automatically do that for you (by warehouse).

    An easier script would be to show the warehouse's average cost for the item (at the point in time the line was added), since Sage does maintain those values in IM_ItemWarehouse (but in a way that is not easy to link into the grid, without a scripted lookup).

  • 0
    SUGGESTED

    The Last Unit Cost is NOT recorded at the warehouse level. It is on the item maintenance screen and applies to ALL warehouses.  You can get the AVERAGE for a certain warehouse.