Open contextref opened 4 years ago
@ianslai good summary. Probably a good idea to introduce a confirmation screen in there which would display the total number of items about to be reserved, as well as how many would be remaining in the inventory as a result
per conversation with John Rousseau I do not think we need to do this. Now that Ian has 1. retained filtering parameters after reserving and 2. implemented "Address Filtering", the work flow is sufficiently speedy to reserve lots of items with the same filter parameters. Suggest we close this issue.
From my investigation for #212, this is what currently happens when you reserve 1 order line in the Demand Manager:
inventory
table is updated, incrementingqty_reserved
by the appropriate amount for the current location (involocation
) and desired product (partnumber
)demands
table is updated several times for the selected order line (with database IDuid
):qty_reserved
by the appropriate amountwolocation
to be the current workcenterprocess_status
toPARTIAL RESERVE
orRESERVED
according to whether the quantity reservedqty_reserved
meets the quantity orderedqty
transport
table gets a new row withstatus = 'RESERVED'
andwo
set to theuid
for the appropriate order line fromdemands
If we want to do a batch reservation, we'll need to think about how we can do this for multiple order lines in a robust way.