Trying to Load an excel file which contains two types of records with same format
First type is Record Type A = purchase order and Second type is Record Type B = Reception
If Purchase order is not received yet , Record Type B doesn't exist
Each record is recognized with a [Movement order number] and a [movement order line] has unique keys
In Record Type B , two fields are containing the [Purchase order number] and [Purchase order line] (movement order number and movement order line) from Record type A to link the reception with the purchase order.
My need is to load all Record Type B = All receptions (easy !) and Record type A when Movement order number and movement order line do not exist as purchase order number and purchase order line in Record type B = Purchase Orders not received yet.
