Sage X3 Stock Valuation per Product per Warehouse

SUGGESTED

All

Is it possible to have an average cost per warehouse for a product for the same site?

Parents Reply Children
  • 0 in reply to Braam Koekekemoer
    SUGGESTED

    Hi Braam, Assembly like work orders are linked to a single stock site. So you would need to transfer the stock in the site where the assembly takes place before issuing it.

    If this is a single location with a single address, I would use a single site with multiple warehouses if needed. But in that case, we should have a single AVC.

    If really, the customer wants to track the cost separatly, then I would advise to use the average lot cost and ensure each receipt done in the different warehouse create a new lot number. Or you can create a small customization to create a lot number matching the warehouse code, in that case you would be able to have different AVC per warehouse. The problem would start when you want to move the lot from one warehouse to another or when you want to implement lot traceability.