--- openbravo/src-db/database/sourcedata/AD_TABLE.xml
+++ openbravo/src-db/database/sourcedata/AD_TABLE.xml
@@ -12583,6 +12583,7 @@
 iol.uOM as uOM, iol.id as goodsShipmentLine, iol.movementQuantity as movementQuantity,
 io.businessPartner as businessPartner, io.documentNo as shipmentNumber,
 io.movementDate as movementDate,  attributeSetValue as attributeSetValue,
+(select ol.id from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine.id = iol.id) as salesOrderLine,
 @rmAUM@ as aum,
 @rmAUMQty@ as aumqty,
 @rmAUMId@ as aumId,
@@ -12665,7 +12666,8 @@
 ol.salesOrder.businessPartner as businessPartner, '' as shipmentNumber,
 '' as movementDate,  '' as attributeSetValue,'' as returnQtyOtherRM,
 'Y' as obSelected, coalesce(ol.orderedQuantity,0)*(-1) as returned, 
- (select oli.returnReason from OrderLine as oli where oli.salesOrder.id = :salesOrderId  and oli.id=ol.id) as returnReason, coalesce (ol.tax, '') as tax, ol.@unitPriceProperty@  as unitPrice, 
+ (select oli.returnReason from OrderLine as oli where oli.salesOrder.id = :salesOrderId  and oli.id=ol.id) as returnReason, coalesce (ol.tax, '') as tax, ol.@unitPriceProperty@  as unitPrice,
+ol.id as salesOrderLine, 
 '' as orderNo
 from OrderLine ol  
 where ol.goodsShipmentLine is null
