Share
Report
39Hi All,
I have Scenario where my Item A0001& A002 are a Batch tracked items, and we have mixed pallets where for a given LP max qty = 40 QTY
Location: WH1A; LP01 = A001 20 qty + A002 20 qty
Location: WH1B; LP02 = A001 5 qty + A0002 35 qty
Location : WH1C; LP03 = A001 10 qty + A002 30 QTY
I have a sales order for 55 QTY for Item A002
The way my work is getting created =
Pick A0002 from WH1A = 20
Pick A0002 from WH1B = 35
The Way I want system to create work is by going by a LP - on hand qty descending for the sku.
Pick A0002 from WH1B = 35
Pick A0002 from WH1C = 20
is this possible on location directives to specify such a query with table joins, I tried but could not find solution
All responses (
Answers (
