from your error > [carrierPartyId,_NA_ there is a party there ========================= 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> Rishi Khanna sent the following on 4/3/2010 5:28 PM: > Hi Sir, > > I do not have any party with _NA_ and I even checked the database there is > no such party. > > Please advise what to do now? > > Thanks > > RIshi > > On Sat, Apr 3, 2010 at 5:04 PM, BJ Freeman <[email protected]> wrote: > >> click on the party tab >> in the partyID put _NA_ >> then click on lookup >> then click on _NA_ >> click on Role(s) >> see if there is a RoletypeID of carrier >> if not then >> under add role >> select carrier >> click on Add >> >> ======================= >> >> 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 >> >> Rishi Khanna sent the following on 4/3/2010 4:14 PM: >>> HI, >>> >>> Thanks for the help. >>> >>> But where I go and assign the role type carrier? >>> >>> Rishi >>> >>> On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[email protected]> wrote: >>> >>>> 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]> >> <ml-node%[email protected]<ml-node%[email protected]> >>>> <ml-node%[email protected]<ml-node%[email protected]> >> <ml-node%[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) =>. >>>>>> >>>>>> >>>>>> >>>> >>> >> >> > >
