So there you go, to create a purchase order the system needs a 
CarrierShipmentMethod record that looks like this one:
https://demo-trunk.ofbiz.apache.org/webtools/control/ViewGeneric?entityName=CarrierShipmentMethod&shipmentMethodTypeId=NO_SHIPPING&partyId=_NA_&roleTypeId=CARRIER

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 1/10/2010, at 11:46 PM, biletnikov wrote:

> 
> Let me demonstrate you what happens if I use
> OrderItemShipGroup.supplierPartyId
> 
> Firstly, the system creates the SALES_ORDER and it looks fine (I'm
> debugging). After that, there is a trigger :
> 
>    <eca service="storeOrder" event="return">
>        <condition field-name="orderTypeId" operator="equals"
> value="SALES_ORDER"/>
>        <action service="checkCreateDropShipPurchaseOrders" mode="sync"
> run-as-user="system"/>
>    </eca>
> and it has begun to create PURCHASE_ORDER
> 
> Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> &apos;ORDER_ITEM_SHIP_GROUP&apos; caused a violation of foreign key
> constraint &apos;ORDER_ITSG_CSHM&apos; for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> &apos;ORDER_ITEM_SHIP_GROUP&apos; caused a violation of foreign key
> constraint &apos;ORDER_ITSG_CSHM&apos; for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)) (Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> &apos;ORDER_ITEM_SHIP_GROUP&apos; caused a violation of foreign key
> constraint &apos;ORDER_ITSG_CSHM&apos; for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)))"
> type="org.ofbiz.service.GenericServiceException">org.ofbiz.service.GenericServiceException:
> Could not commit transaction for service [createSalesOrderService] call:
> Roll back error, could not commit transaction, was rolled back instead
> because of: Failure in create operation for entity [OrderItemShipGroup]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> &apos;ORDER_ITEM_SHIP_GROUP&apos; caused a violation of foreign key
> constraint &apos;ORDER_ITSG_CSHM&apos; for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> &apos;ORDER_ITEM_SHIP_GROUP&apos; caused a violation of foreign key
> constraint &apos;ORDER_ITSG_CSHM&apos; for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)) (Error while inserting:
> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10010(java.lang.String)][createdStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][createdTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][facilityId,null()][giftMessage,(java.lang.String)][isGift,N(java.lang.String)][lastUpdatedStamp,2010-10-01
> 12:03:52.078(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01
> 12:02:40.875(java.sql.Timestamp)][maySplit,Y(java.lang.String)][orderId,10441(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)][supplierPartyId,null()][vendorPartyId,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID,
> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID,
> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT,
> GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE,
> ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
> &apos;ORDER_ITEM_SHIP_GROUP&apos; caused a violation of foreign key
> constraint &apos;ORDER_ITSG_CSHM&apos; for key (NO_SHIPPING,_NA_,CARRIER).
> The statement has been rolled back.)))
> at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:546)
> at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219)
> at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> at
> de.alfah.ofbiz.service.test.AlfahOrderProductServiceTest.testCreateOrder(AlfahOrderProductServiceTest.java:30)
> at org.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:137)
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
> 
> 
> 
> On Fri, Oct 1, 2010 at 4:01 AM, Scott Gray-2 [via OFBiz] <
> [email protected]<ml-node%[email protected]>
>> wrote:
> 
>> Focus on understanding what the validation errors are telling you, the
>> service that creates the drop ship purchase orders does not use or require a
>> shopping cart for the sales order.  Somewhere you have not persisted all the
>> data that ofbiz needs to create the purchase order.
>> 
>> Regards
>> Scott
>> 
>> On 1/10/2010, at 8:36 AM, biletnikov wrote:
>> 
>>> 
>>> Thank you for you response.
>>> 
>>> I already have the experience of using OrderItemShipGroup.supplierPartyId
>> to
>>> point the necessary supplier for new order creating, so I use
>> "storeOrder"
>>> service for that, unfortunately when I create SALES_ORDER and if the
>>> supplierPartyId is specified, OFBiz tries to create PURCHASE_ORDER to
>> this
>>> supplier automatically and it faces the validation errors : contact data
>> are
>>> not specified, because they are retrieved from the ShoppingCart, but I do
>> 
>>> not use the shopping cart yet. We just develop own service which should
>> be
>>> the mature back-end system and reuse all value things of OFBiz for our
>>> front-end shop.
>>> 
>>> On Thu, Sep 30, 2010 at 9:51 PM, Scott Gray-2 [via OFBiz] <
>>> [hidden email] 
>>> <http://user/SendEmail.jtp?type=node&node=2790029&i=0><[hidden
>> email] <http://user/SendEmail.jtp?type=node&node=2790029&i=1>>
>>>> wrote:
>>> 
>>>> I would suggest looking at the drop ship functionality that is available
>> in
>>>> OFBiz and customizing it for this situation.  The shopping cart has the
>>>> ability to set a supplierPartyId per ship group and that can probably be
>> 
>>>> leveraged in this situation.  What biletnikov is describing is really
>> just
>>>> drop shipments with the ability for the customer to decide the supplier
>>>> rather than leaving the system to do it automatically.
>>>> 
>>>> But BJ please try and avoid spreading incorrect information, especially
>>>> when it has the effect of turning people away from the mailing lists.
>>>> 
>>>> Regards
>>>> Scott
>>>> 
>>>> On 1/10/2010, at 7:21 AM, BJ Freeman wrote:
>>>> 
>>>>> By all means Scott
>>>>> Provide him the answer.
>>>>> 
>>>>> 
>>>>> 
>>>>> Scott Gray sent the following on 9/30/2010 2:16 AM:
>>>>>> On 30/09/2010, at 9:38 PM, BJ Freeman wrote:
>>>>>> 
>>>>>>> anything beyond Out Of The Box is beyond this mailing list.
>>>>>> 
>>>>>> Huh? Since when is this the case?
>>>>>> This list is exactly where people should come when they want to
>> discuss
>>>> their business problems and how OFBiz could help solve them.
>>>>>> 
>>>>>>> I suggest you contact someone on the providers list available from
>> the
>>>> front page of ofbiz to help you.
>>>>>>> 
>>>>>>> 
>>>>>>> biletnikov sent the following on 9/30/2010 12:17 AM:
>>>>>>> 
>>>>>>>> 
>>>>>>>> Thank you for your response.
>>>>>>>> 
>>>>>>>> The lead time and inventory levels are not used.
>>>>>>>> We are not going to use PreferenceOrder  and Ratingtype, because we
>> do
>>>> not
>>>>>>>> have preferable or not preferable suppliers. All of them are actual,
>> 
>>>> and
>>>>>>>> different products can have own list of suppliers, but the customer
>>>> wants to
>>>>>>>> select this supplier of the product before he place it into the
>>>> shopping
>>>>>>>> cart. And I see that the customer selected SupplierProduct can not
>> be
>>>>>>>> considered for the order (in OrderItem) in the current OFBiz data
>>>> model.
>>>>>>>> We do not use E-commerce shop, we have own front-end solution, so it
>> 
>>>> means
>>>>>>>> we are finding the way how to handle with product suppliers.
>>>>>>>> 
>>>>>>>> Could you suggest which way is the most easier to customize:
>>>>>>>> 
>>>>>>>>  - store the  Product<->   ProductSupplier   like one-to-one
>>>> relation, if
>>>>>>>>  the product has 3 suppliers, it means we create 3 products and add
>> 
>>>> the
>>>>>>>>  ProductSupplier for each product, if the OrderItem refers to
>>>> productId we
>>>>>>>>  know which supplier we need
>>>>>>>>  - have the Product<->   ProductSupplier one-to-many  relation, but
>> 
>>>> add
>>>>>>>>  supplierId to the OrderItem. Also, we need a UI possibility in
>>>> OFBiz to edit
>>>>>>>>  order items and we should able to select a new supplier for the
>>>> OrderItem.
>>>>>>>> 
>>>>>>>> we use OFBiz just as ERP, Ordering, Accounty, Party management
>> system.
>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>>>> On Thu, Sep 30, 2010 at 12:45 AM, BJ Freeman [via OFBiz]<
>>>>>>>> [hidden email] <
>> http://user/SendEmail.jtp?type=node&node=2743575&i=0>
>>>> <[hidden email] <http://user/SendEmail.jtp?type=node&node=2743575&i=1>>
>> 
>>>>>>>>> wrote:
>>>>>>>> 
>>>>>>>>> are you planning on  supplying the PreferenceOrder and Ratingtype
>> to
>>>> the
>>>>>>>>> customer.
>>>>>>>>> how about the lead time and inventory levels.
>>>>>>>>> 
>>>>>>>>> 
>>>> 
>> https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=SupplierProduct
>>>>>>>>> 
>>>>>>>>> so every productID can be related to Supplier product.
>>>>>>>>> this is done in the Catalog->product-supplier.
>>>>>>>>> 
>>>>>>>>> the one to many for supplier product exists
>>>>>>>>> 
>>>>>>>>> 
>>>> 
>> https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=Product
>>>>>>>>> 
>>>>>>>>> The productID in OrderItem relates to many supplierproducts you
>>>> enter.
>>>>>>>>> you can automatically pick the SupplierPreferenceOrder (main
>> suppler)
>>>> or
>>>>>>>>> SupplierRatingtype of that you add that will be the best supplier
>>>> Rating.
>>>>>>>>> 
>>>>>>>>> The selection, currently, of the supplier is done by
>>>>>>>>> SupplierPreferenceOrder. This is set up manually and customization
>> is
>>>> 
>>>>>>>>> necessary to use SupplierRatingtype figure this out by the criteria
>> 
>>>> you
>>>>>>>>> set from the data in SupplierProduct.
>>>>>>>>> 
>>>>>>>>> if you put the info in the Product detail page they can select it
>>>> before
>>>>>>>>> order. that is a customization.
>>>>>>>>> 
>>>>>>>>> if you put in the Cart after the orders get more complicated unless
>> 
>>>> you
>>>>>>>>> just want to show what ofbiz current logic selects for the
>> supplier.
>>>>>>>>> this also is a customization.
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> biletnikov sent the following on 9/29/2010 11:55 AM:
>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> In our case, we sell products which are provided by different
>>>> suppliers
>>>>>>>>> and
>>>>>>>>>> the customer has ability to select the most preferable supplier.
>>>>>>>>>> 
>>>>>>>>>> We see, that OFBiz data model allows to specify the suppliers for
>>>> each
>>>>>>>>>> product (SupplierProduct), so a product can have many suppliers (
>>>> for
>>>>>>>>>> example, 3 SupplierProduct).
>>>>>>>>>> 
>>>>>>>>>> But, how to specify the product and the supplier that customer
>> needs
>>>> for
>>>>>>>>> the
>>>>>>>>>> order? A customer wants to see the supplier in the order.
>>>>>>>>>> 
>>>>>>>>>> The Order entity has OrderItem entities, which relate to Product
>>>> (via
>>>>>>>>>> productId) and nothing for the supplier.
>>>>>>>>>> 
>>>>>>>>>> The solution which we see, is to duplicate Product for each
>> supplier
>>>> and
>>>>>>>>>> have   one - to - one relation  between Product and
>> SupplierProduct,
>>>> in
>>>>>>>>> this
>>>>>>>>>> case we are able to determine the supplier by productId.
>>>>>>>>>> 
>>>>>>>>>> Is it the best solution?
>>>>>>>>>> 
>>>>>>>>>> Thank you.
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> ------------------------------
>>>>>>>>> View message @
>>>>>>>>> 
>>>> 
>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t>
>> <
>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2719855.html?by-user=t&by-user=t&by-user=t&by-user=t>>
>> 
>>>>>>>>> To unsubscribe from Many suppliers for product, the customer
>> selects
>>>> the
>>>>>>>>> necessary supplier, click here<
>>>> 
>> http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>
>> <
>> http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t&by-user=t&by-user=t>>>.
>> 
>>>> 
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>> 
>>>> 
>>>> 
>>>> *smime.p7s* (3K) Download Attachment<
>> http://attachment/2743575/0/smime.p7s>
>>>> 
>>>> 
>>>> ------------------------------
>>>> View message @
>>>> 
>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.html<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2743575.html?by-user=t&by-user=t>
>>>> To unsubscribe from Many suppliers for product, the customer selects the
>> 
>>>> necessary supplier, click here<
>> http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4&by-user=t&by-user=t>>.
>> 
>>>> 
>>>> 
>>>> 
>>> 
>>> 
>>> --
>>> Best regards,
>>> Sergei Biletnikov
>>> 
>>> --
>>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2748882.html<http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2748882.html?by-user=t&by-user=t>
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>> 
>> 
>> *smime.p7s* (3K) Download Attachment<http://attachment/2790029/0/smime.p7s>
>> 
>> 
>> ------------------------------
>> View message @
>> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2790029.html
>> To unsubscribe from Many suppliers for product, the customer selects the
>> necessary supplier, click 
>> here<http://ofbiz.135035.n4.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2719579&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MjcxOTU3OXwyMDcwNzk3NDQ4>.
>> 
>> 
>> 
> 
> 
> -- 
> Best regards,
> Sergei Biletnikov
> 
> -- 
> View this message in context: 
> http://ofbiz.135035.n4.nabble.com/Many-suppliers-for-product-the-customer-selects-the-necessary-supplier-tp2719579p2888175.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to