Import Packing List > Should display an error message if user tries to import the same item (product, lot number) within the same packing unit

[jmiranda]

Scenario: There are two shipment items for product code VP71, lot number NULL. The user tries to import a packing list with two VP71 rows.

Pallet	Product	Lot Number	Qty
Pallet 1	VP71	NULL	100
Pallet 1	VP71	NULL	300

The reason this is a problem is because OB cannot determine which shipment item to update so it updates the first shipment item twice.

update shipment_item set quantity = 100 where product = VP71 and lot_number = NULL and container = Pallet 1;
update shipment_item set quantity = 300 where product = VP71 and lot_number = NULL and container = Pallet 1;

which would leave you with

Pallet	Product	Lot Number	Qty
Pallet 1	VP71	NULL	300
Pallet 1	VP71	NULL	300

Instead the two line items should be consolidated.

Pallet	Product	Lot Number	Qty
Pallet 1	VP71	NULL	400

Remember, this is only the case WITHIN the same packing unit (pallet, box, unpacked items).