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 <bjf...@free-man.net> 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 <bjf...@free-man.net> 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] < > >>> 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> > > > >> <ml-node%2b1750438-1188582885-210...@n4.nabble.com<ml-node%252b1750438-1188582885-210...@n4.nabble.com> > <ml-node%252b1750438-1188582885-210...@n4.nabble.com<ml-node%25252b1750438-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) =>. > >>>> > >>>> > >>>> > >>> > >> > >> > > > > > > > -- Rishi Khanna Director Rugstan Inc. Ph # 650-292-2493