How to link a Sales Return Shipment to the Return?

[Jacopo Cappellato-3]

What is the best way to associate a ReturnItem to a ShipmentItem of  
type "sales return"?
Do we need an associative entity between ReturnItem and ShipmentItem  
or we can simplify the design by adding the shipmentId and  
shipmentItemSeqId to the ReturnItem entity?

I guess we will need the associative entity... and if we go for it,  
what is the best name for the new entity? ReturnItemShipment?

Thanks,

Jacopo

[David E Jones]

On Jun 16, 2008, at 4:11 AM, Jacopo Cappellato wrote:

> What is the best way to associate a ReturnItem to a ShipmentItem of  
> type "sales return"?
> Do we need an associative entity between ReturnItem and ShipmentItem  
> or we can simplify the design by adding the shipmentId and  
> shipmentItemSeqId to the ReturnItem entity?
>
> I guess we will need the associative entity... and if we go for it,  
> what is the best name for the new entity? ReturnItemShipment?

This sounds fine to me. The join entity should have a quantity on it  
like other similar entities so that you could have multiple  
ShipmentItems for a single ReturnItem.

-David

[Jacopo Cappellato-3]

Thanks David,

this is done in rev. 669188

Jacopo


On Jun 16, 2008, at 6:08 PM, David E Jones wrote:

>
> On Jun 16, 2008, at 4:11 AM, Jacopo Cappellato wrote:
>
>> What is the best way to associate a ReturnItem to a ShipmentItem of  
>> type "sales return"?
>> Do we need an associative entity between ReturnItem and  
>> ShipmentItem or we can simplify the design by adding the shipmentId  
>> and shipmentItemSeqId to the ReturnItem entity?
>>
>> I guess we will need the associative entity... and if we go for it,  
>> what is the best name for the new entity? ReturnItemShipment?
>
> This sounds fine to me. The join entity should have a quantity on it  
> like other similar entities so that you could have multiple  
> ShipmentItems for a single ReturnItem.
>
> -David
>