a quick work around is to go into the party for _NA_ and give it a role carrier.
I am not sure this might cause another glitch down the road. but it will allow the PO to be generated. ========================= 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> BJ Freeman sent the following on 4/3/2010 3:49 PM: > if you selected > No shipping > it is assigned _NA_ for PartyID > the Party ID _NA_ 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> > > > BJ Freeman sent the following on 4/3/2010 3:39 PM: >> 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] < >>> [email protected]<ml-node%[email protected]> >>>> 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) =>. >>>> >>>> >>>> >> >> > > >
