Setup multiple locations as Warehouses vs Sites due to the need to move jobs (WIP) easily between different buildings. Some materials will be stocked with minimum levels and demands will be driven by the warehouse on the JobMtl table.
MRP is driven at the Site (Plant) level with suggestions for supply to be bought to the primary warehouse. Would like to automate the demand to the warehouse where the demand exists.
Has anyone done something like this?
Are these warehouses all in physically different locations, then? As in, POs need to go to the correct warehouse?
Yes,
All of the warehouses are at different locations.
I am looking into Advanced Unit of Measure as a potential solution because you can set minQty and other parameters against a Attribute Set and also call out an attribute set at the job level.
MRP will create a PO suggestion for that specific attribute (which would be the warehouse code). Using a BPM update the warehouse to deliver the PO to by setting it on the release.
OK - you’re connecting the dots. I knew you could force POs to a specific warehouse, but I was pretty sure that the warehouse specified on a PO suggestion was (like you said) the primary warehouse on the part/plant record. I was looking in PartDtl because I didn’t think there was a Warehouse there to store the demand requirement - but there is. It’s called TargetWarehouseCode. The help on that field says it is only valuable for supply records, though… not demand records. I hadn’t gotten a chance to look into that closer.
Key is when MRP runs Get Details - the material warehouses need to default to the demand warehouse code.
Then when Generate Suggestions - need to have the warehouse set based on jobmatl.warehousecode.