You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by rugstan <ru...@gmail.com> on 2010/04/03 19:30:16 UTC
Getting an error when creating Purchase Order
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 this message in context: http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750301.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Getting an error when creating Purchase Order
Posted by rugstan <ru...@gmail.com>.
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-210824@n4.nabble.com<ml...@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
--
View this message in context: http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750539.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Getting an error when creating Purchase Order
Posted by Rishi Khanna <ru...@gmail.com>.
I had no party with NA
Veru confused
On Sat, Apr 3, 2010 at 4:14 PM, Rishi Khanna <ru...@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 <bj...@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-210824@n4.nabble.com<ml...@n4.nabble.com>
>> <ml...@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
Re: Getting an error when creating Purchase Order
Posted by Rishi Khanna <ru...@gmail.com>.
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.roux@les7arts.com> wrote:
> There is one demo for R9.04, it's even accessible from the OFBiz home page
>
> Jacques
>
> From: "BJ Freeman" <bj...@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 <ru...@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 <bj...@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-210824@n4.nabble.com<ml...@n4.nabble.com>
>>>>>> <ml...@n4.nabble.com>
>>>>>> >
>>>>>>
>>>>> <ml...@n4.nabble.com>
>>>>> <ml...@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
Re: Getting an error when creating Purchase Order
Posted by BJ Freeman <bj...@free-man.net>.
I run 9.04 for on one of my websites.
if you look at the order entry page
you will see purchase order under sales order
=========================
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/4/2010 2:30 PM:
> 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.roux@les7arts.com> wrote:
>
>> There is one demo for R9.04, it's even accessible from the OFBiz home page
>>
>> Jacques
>>
>> From: "BJ Freeman" <bj...@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 <ru...@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 <bj...@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-210824@n4.nabble.com<ml...@n4.nabble.com>
>>>>>>> <ml...@n4.nabble.com>
>>>>>> <ml...@n4.nabble.com>
>>>>>> <ml...@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
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>
>
Re: Getting an error when creating Purchase Order
Posted by Jacques Le Roux <ja...@les7arts.com>.
There is one demo for R9.04, it's even accessible from the OFBiz home page
Jacques
From: "BJ Freeman" <bj...@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 <ru...@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 <bj...@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-210824@n4.nabble.com<ml...@n4.nabble.com>
>>>> <ml...@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
>>>
>>
>>
>>
>
>
Re: Getting an error when creating Purchase Order
Posted by BJ Freeman <bj...@free-man.net>.
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>
Jacques Le Roux sent the following on 4/4/2010 1:24 AM:
> There is one demo for R9.04, it's even accessible from the OFBiz home page
>
> Jacques
>
> From: "BJ Freeman" <bj...@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 <ru...@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 <bj...@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-210824@n4.nabble.com<ml...@n4.nabble.com>
>>>>>>
>>>>> <ml...@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
>>>>
>>>
>>>
>>>
>>
>>
>
>
>
Re: Getting an error when creating Purchase Order
Posted by BJ Freeman <bj...@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 <ru...@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 <bj...@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-210824@n4.nabble.com<ml...@n4.nabble.com>
>>> <ml...@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
>>
>
>
>
Re: Getting an error when creating Purchase Order
Posted by Rishi Khanna <ru...@gmail.com>.
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 <bj...@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-210824@n4.nabble.com<ml...@n4.nabble.com>
> <ml...@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
Re: Getting an error when creating Purchase Order
Posted by Rishi Khanna <ru...@gmail.com>.
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 <bj...@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 <bj...@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-210824@n4.nabble.com<ml...@n4.nabble.com>
> <ml...@n4.nabble.com>
> >
> >> <ml...@n4.nabble.com>
> <ml...@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
Re: Getting an error when creating Purchase Order
Posted by BJ Freeman <bj...@free-man.net>.
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 <bj...@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 <bj...@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-210824@n4.nabble.com<ml...@n4.nabble.com>
>> <ml...@n4.nabble.com>
>>>> <ml...@n4.nabble.com>
>> <ml...@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) =>.
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>
>>
>>
>
>
Re: Getting an error when creating Purchase Order
Posted by BJ Freeman <bj...@free-man.net>.
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 <bj...@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-210824@n4.nabble.com<ml...@n4.nabble.com>
>> <ml...@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) =>.
>>>>
>>>>
>>>>
>>>
>>
>>
>
>
Re: Getting an error when creating Purchase Order
Posted by BJ Freeman <bj...@free-man.net>.
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-210824@n4.nabble.com<ml...@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) =>.
>>
>>
>>
>
>
Re: Getting an error when creating Purchase Order
Posted by BJ Freeman <bj...@free-man.net>.
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] <
>> ml-node+1750438-1188582885-210824@n4.nabble.com<ml...@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) =>.
>>>
>>>
>>>
>>
>
>
>
Re: Getting an error when creating Purchase Order
Posted by BJ Freeman <bj...@free-man.net>.
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] <
>>> ml-node+1750438-1188582885-210824@n4.nabble.com<ml...@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) =>.
>>>>
>>>>
>>>>
>>
>>
>
>
>