the error says that you did not select a carrier.
the default was put in _NA_ but is does not have a Role type Carrier
assigned to it.
=====================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <
http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
Linkedin
<
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
rugstan sent the following on 4/3/2010 3:12 PM:
I am using 9.04 and when I press the button to finalize the Purchase
Order
than I get this error and I cannot create a Purchase order. I tried
everyhing but cannot figure out the mistake I am making and where I am
making.
Thanks
Rishi
On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] <
ml-node+1750438-1188582885-210...@n4.nabble.com<ml-node%2b1750438-1188582885-210...@n4.nabble.com>
<ml-node%2b1750438-1188582885-210...@n4.nabble.com<ml-node%252b1750438-1188582885-210...@n4.nabble.com>
wrote:
>> want version of ofbiz, please
also what steps did you do and where did the error happen in the steps?
thanks
=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <
http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
Linkedin
<
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
rugstan sent the following on 4/3/2010 10:30 AM:
> Hi, I am getting an error when creating a Purchase Order. Can anyone
tell me
what I am doing wrong and how to fix it.
The Following Errors Occurred: Did not complete the order, the
following
occurred:ERROR : Could not create order (write error :Error while
inserting:
[GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29
12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29
12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29
12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29
12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29
11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31
11:49:09.0(java.sql.Timestamp)][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,null()][supplierPartyId,null()][vendorPartyId,null()]
(SQL Exception while executing the following:INSERT INTO
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?,
?)
(Cannot add or update a child row: a foreign key constraint fails
(`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN
KEY
(`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`,
`CARRIER_ROLE_TYPE_ID`)
REFERENCES `carrier_shipment_method` (`SHIPMEN)))).
Purchase Order : Order Confirmation Create OrderReview
OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad
--------------------------------------------------------------------------------
Order Terms Term Type Term Value Term Days Description
--------------------------------------------------------------------------------
Payment (net days) 30
--------------------------------------------------------------------------------
Splitting Preference Please wait until the entire order is ready
before
shipping.
--------------------------------------------------------------------------------
Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31
11:49:09.000 Shipping InformationDestination Supplier Shipment Method
Item
Quantity
--------------------------------------------------------------------------------
To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San
Francisco
CA
, 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2
--------------------------------------------------------------------------------
Grand Total $680.00
------------------------------
View message @
http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html
To unsubscribe from Getting an error when creating Purchase Order,
click
here< (link removed) =>.
