that do not have the purchase order in there under order entry. On Sun, Apr 4, 2010 at 1:24 AM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote:
> There is one demo for R9.04, it's even accessible from the OFBiz home page > > Jacques > > From: "BJ Freeman" <bjf...@free-man.net> > > I suggest you down load a separate 9.04 and install the demo data, and >> run in local host mode. >> try your PO to see if it works. >> if so then compare the demo data with the data in your installation to >> see what you don't have. >> >> I would suggest using the Demo server but they don't have one for 9.04 >> right now. >> >> ========================= >> 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:04 PM: >> >>> I had no party with NA >>> >>> Veru confused >>> >>> On Sat, Apr 3, 2010 at 4:14 PM, Rishi Khanna <rugs...@gmail.com> wrote: >>> >>> 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 >>>> >>>> >>> >>> >>> >> >> > > -- Rishi Khanna Director Rugstan Inc. Ph # 650-292-2493
