I’m trying to solve the problem of purchase receipt.
When raw material arrive, I have a DN containing:
ORDER A position 1 ITEMCODEA 200KG
ORDER A position 3 ITEMCODEB 500KG
ORDER B position 1 ITEMCODEA 200KG
The user must have the possibility to select a specific order number and position in order to allow system update the received quantity of the correct supply row order.
If i’m not in wrong the two fields that identify the order to update are purchase_order and purchase_order_item in the Purchase Receipt item.
Now the problem is that the field purchase_order_item indeed don’t have the value of row position but an alphanumeric Key (example 9f41d20209) that the user doesnt’ know.
The solution more user friendly in my opinion is to show a table with in each row Po mumber, row number, qty ordered, qty received, and a radio button. Depends on the row selected the fields purchase_order and purchase_order_item has to be filled with correct values.
Is it possible?Or you have another better solution?