I had no party with NA Veru confused
On Sat, Apr 3, 2010 at 4:14 PM, Rishi Khanna <[email protected]> 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 <[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]> >> > >> >> 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
