Find Error in return tab under order tab.
Locked
Find Error in return tab under order tab.
 
|
Re: Find Error in return tab under order tab.
Administrator
|
Re: Find Error in return tab under order tab.
|
|
Re: Find Error in return tab under order tab.
|
|
It seems that the Billing Account # 9876 doesn't exist in your sustem.
Jacopo On Aug 11, 2008, at 9:23 AM, gopalbi wrote: > > Hello friend i need your help, > > when i click on return tab under order tab and enter the Create new > return > button. If we some value on the from like > > Currency- American Doller > Enter date- 2008-08-07 12:03:55.0 > Return From party- Admin > Return to facility - abc > Billing Account - 9876 > Payment Method Id - 8975 > Auto-Recive- yes > > Then it shown the this type of error. > The Following Errors Occurred: > > ERROR: Could not complete the Create a ReturnHeader > [file:/F:/workspace/ofbiz30july/applications/order/script/org/ofbiz/ > order/order/OrderReturnServices.xml#createReturnHeader] > process [problem creating the newEntity value: Error while inserting: > [GenericEntity:ReturnHeader][billingAccountId,9876(java.lang.String)] > [createdBy,admin(java.lang.String)][createdStamp,2008-08-08 > 12:05:59.484(java.sql.Timestamp)][createdTxStamp,2008-08-08 > 12:05:59.14(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)] > [destinationFacilityId,10009(java.lang.String)][entryDate,2008-08-07 > 12:03:55.0(java.sql.Timestamp)][fromPartyId,admin(java.lang.String)] > [lastUpdatedStamp,2008-08-08 > 12:05:59.484(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-08 > 12:05:59.14(java.sql.Timestamp)] > [needsInventoryReceive,Y(java.lang.String)][paymentMethodId, > 8975(java.lang.String)] > [returnHeaderTypeId,CUSTOMER_RETURN(java.lang.String)][returnId, > 10012(java.lang.String)][statusId,RETURN_REQUESTED(java.lang.String)] > [toPartyId,Company(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO RETURN_HEADER > (RETURN_ID, RETURN_HEADER_TYPE_ID, STATUS_ID, CREATED_BY, > FROM_PARTY_ID, > TO_PARTY_ID, PAYMENT_METHOD_ID, FIN_ACCOUNT_ID, BILLING_ACCOUNT_ID, > ENTRY_DATE, ORIGIN_CONTACT_MECH_ID, DESTINATION_FACILITY_ID, > NEEDS_INVENTORY_RECEIVE, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES > (?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity > constraint violation message from server: "Cannot add or update a > child row: > a foreign key constraint fails (`ofbiznew/return_header`, CONSTRAINT > `RTN_TO_BACT` FOREIGN KEY (`BILLING_ACCOUNT_ID`) REFERENCES > `billing_account` (`BILLING_ACCOUNT_ID`))"))] > > Please help me.And give me correct direction. > > Thanks in advance. > > Thanks & Regards: > Gopal Bisht > > > jacques.le.roux wrote: >> >> From: "gopalbi" <[hidden email]> >> >> Could you send more details ? I don't see any errors. >> >> Jacques >> >> > > -- > View this message in context: http://www.nabble.com/Find-Error-in-return-tab-under-order-tab.-tp18920526p18921178.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
smime.p7s (3K)
Re: Find Error in return tab under order tab.
|
|
Re: Find Error in return tab under order tab.
|
|
just try to leave the Billing Account field empty
Jacopo On Aug 11, 2008, at 10:45 AM, gopalbi wrote: > > Sorry jacopo, > > i can't understand what you saying.So please give the solution how > to solve > this problem. > > Thanks for your reply. > > Thanks & Regards: > Gopal Bisht > > Jacopo Cappellato-3 wrote: >> >> It seems that the Billing Account # 9876 doesn't exist in your >> sustem. >> >> Jacopo >> >> On Aug 11, 2008, at 9:23 AM, gopalbi wrote: >> >>> >>> Hello friend i need your help, >>> >>> when i click on return tab under order tab and enter the Create new >>> return >>> button. If we some value on the from like >>> >>> Currency- American Doller >>> Enter date- 2008-08-07 12:03:55.0 >>> Return From party- Admin >>> Return to facility - abc >>> Billing Account - 9876 >>> Payment Method Id - 8975 >>> Auto-Recive- yes >>> >>> Then it shown the this type of error. >>> The Following Errors Occurred: >>> >>> ERROR: Could not complete the Create a ReturnHeader >>> [file:/F:/workspace/ofbiz30july/applications/order/script/org/ofbiz/ >>> order/order/OrderReturnServices.xml#createReturnHeader] >>> process [problem creating the newEntity value: Error while >>> inserting: >>> [GenericEntity:ReturnHeader][billingAccountId, >>> 9876(java.lang.String)] >>> [createdBy,admin(java.lang.String)][createdStamp,2008-08-08 >>> 12:05:59.484(java.sql.Timestamp)][createdTxStamp,2008-08-08 >>> 12:05:59.14(java.sql.Timestamp)] >>> [currencyUomId,USD(java.lang.String)] >>> [destinationFacilityId,10009(java.lang.String)][entryDate,2008-08-07 >>> 12:03:55.0(java.sql.Timestamp)][fromPartyId,admin(java.lang.String)] >>> [lastUpdatedStamp,2008-08-08 >>> 12:05:59.484(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-08 >>> 12:05:59.14(java.sql.Timestamp)] >>> [needsInventoryReceive,Y(java.lang.String)][paymentMethodId, >>> 8975(java.lang.String)] >>> [returnHeaderTypeId,CUSTOMER_RETURN(java.lang.String)][returnId, >>> 10012(java.lang.String)] >>> [statusId,RETURN_REQUESTED(java.lang.String)] >>> [toPartyId,Company(java.lang.String)] >>> (SQL Exception while executing the following:INSERT INTO >>> RETURN_HEADER >>> (RETURN_ID, RETURN_HEADER_TYPE_ID, STATUS_ID, CREATED_BY, >>> FROM_PARTY_ID, >>> TO_PARTY_ID, PAYMENT_METHOD_ID, FIN_ACCOUNT_ID, BILLING_ACCOUNT_ID, >>> ENTRY_DATE, ORIGIN_CONTACT_MECH_ID, DESTINATION_FACILITY_ID, >>> NEEDS_INVENTORY_RECEIVE, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, >>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES >>> (?, ?, ?, ?, >>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or >>> integrity >>> constraint violation message from server: "Cannot add or update a >>> child row: >>> a foreign key constraint fails (`ofbiznew/return_header`, CONSTRAINT >>> `RTN_TO_BACT` FOREIGN KEY (`BILLING_ACCOUNT_ID`) REFERENCES >>> `billing_account` (`BILLING_ACCOUNT_ID`))"))] >>> >>> Please help me.And give me correct direction. >>> >>> Thanks in advance. >>> >>> Thanks & Regards: >>> Gopal Bisht >>> >>> >>> jacques.le.roux wrote: >>>> >>>> From: "gopalbi" <[hidden email]> >>>> >>>> Could you send more details ? I don't see any errors. >>>> >>>> Jacques >>>> >>>> >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Find-Error-in-return-tab-under-order-tab.-tp18920526p18921178.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >> >> >> >> > > -- > View this message in context: http://www.nabble.com/Find-Error-in-return-tab-under-order-tab.-tp18920526p18922017.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Re: Find Error in return tab under order tab.
|
|
Re: Find Error in return tab under order tab.
|
|
On Aug 11, 2008, at 11:16 AM, gopalbi wrote: > > I am very very thanks for your reply. > > Ok it's mean that if Billing Account in the return page value is > similar to > the which is avaible in the biiling_account table like > billing_account_id(9876). > > Therefore it's mean here dropdown is required.The value is come from > the > billing_account table. Regards, Jacopo > > > It's right. Please give me correct direction. > > Thanks & Regards: > Gopal Bisht. > > > > Jacopo Cappellato-3 wrote: >> >> just try to leave the Billing Account field empty >> >> Jacopo >> >> On Aug 11, 2008, at 10:45 AM, gopalbi wrote: >> >>> >>> Sorry jacopo, >>> >>> i can't understand what you saying.So please give the solution how >>> to solve >>> this problem. >>> >>> Thanks for your reply. >>> >>> Thanks & Regards: >>> Gopal Bisht >>> >>> Jacopo Cappellato-3 wrote: >>>> >>>> It seems that the Billing Account # 9876 doesn't exist in your >>>> sustem. >>>> >>>> Jacopo >>>> >>>> On Aug 11, 2008, at 9:23 AM, gopalbi wrote: >>>> >>>>> >>>>> Hello friend i need your help, >>>>> >>>>> when i click on return tab under order tab and enter the Create >>>>> new >>>>> return >>>>> button. If we some value on the from like >>>>> >>>>> Currency- American Doller >>>>> Enter date- 2008-08-07 12:03:55.0 >>>>> Return From party- Admin >>>>> Return to facility - abc >>>>> Billing Account - 9876 >>>>> Payment Method Id - 8975 >>>>> Auto-Recive- yes >>>>> >>>>> Then it shown the this type of error. >>>>> The Following Errors Occurred: >>>>> >>>>> ERROR: Could not complete the Create a ReturnHeader >>>>> [file:/F:/workspace/ofbiz30july/applications/order/script/org/ >>>>> ofbiz/ >>>>> order/order/OrderReturnServices.xml#createReturnHeader] >>>>> process [problem creating the newEntity value: Error while >>>>> inserting: >>>>> [GenericEntity:ReturnHeader][billingAccountId, >>>>> 9876(java.lang.String)] >>>>> [createdBy,admin(java.lang.String)][createdStamp,2008-08-08 >>>>> 12:05:59.484(java.sql.Timestamp)][createdTxStamp,2008-08-08 >>>>> 12:05:59.14(java.sql.Timestamp)] >>>>> [currencyUomId,USD(java.lang.String)] >>>>> [destinationFacilityId,10009(java.lang.String)][entryDate, >>>>> 2008-08-07 >>>>> 12:03:55.0(java.sql.Timestamp)] >>>>> [fromPartyId,admin(java.lang.String)] >>>>> [lastUpdatedStamp,2008-08-08 >>>>> 12:05:59.484(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-08 >>>>> 12:05:59.14(java.sql.Timestamp)] >>>>> [needsInventoryReceive,Y(java.lang.String)][paymentMethodId, >>>>> 8975(java.lang.String)] >>>>> [returnHeaderTypeId,CUSTOMER_RETURN(java.lang.String)][returnId, >>>>> 10012(java.lang.String)] >>>>> [statusId,RETURN_REQUESTED(java.lang.String)] >>>>> [toPartyId,Company(java.lang.String)] >>>>> (SQL Exception while executing the following:INSERT INTO >>>>> RETURN_HEADER >>>>> (RETURN_ID, RETURN_HEADER_TYPE_ID, STATUS_ID, CREATED_BY, >>>>> FROM_PARTY_ID, >>>>> TO_PARTY_ID, PAYMENT_METHOD_ID, FIN_ACCOUNT_ID, >>>>> BILLING_ACCOUNT_ID, >>>>> ENTRY_DATE, ORIGIN_CONTACT_MECH_ID, DESTINATION_FACILITY_ID, >>>>> NEEDS_INVENTORY_RECEIVE, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, >>>>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES >>>>> (?, ?, ?, ?, >>>>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or >>>>> integrity >>>>> constraint violation message from server: "Cannot add or update a >>>>> child row: >>>>> a foreign key constraint fails (`ofbiznew/return_header`, >>>>> CONSTRAINT >>>>> `RTN_TO_BACT` FOREIGN KEY (`BILLING_ACCOUNT_ID`) REFERENCES >>>>> `billing_account` (`BILLING_ACCOUNT_ID`))"))] >>>>> >>>>> Please help me.And give me correct direction. >>>>> >>>>> Thanks in advance. >>>>> >>>>> Thanks & Regards: >>>>> Gopal Bisht >>>>> >>>>> >>>>> jacques.le.roux wrote: >>>>>> >>>>>> From: "gopalbi" <[hidden email]> >>>>>> >>>>>> Could you send more details ? I don't see any errors. >>>>>> >>>>>> Jacques >>>>>> >>>>>> >>>>> >>>>> -- >>>>> View this message in context: >>>>> http://www.nabble.com/Find-Error-in-return-tab-under-order-tab.-tp18920526p18921178.html >>>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>>>> >>>> >>>> >>>> >>>> >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Find-Error-in-return-tab-under-order-tab.-tp18920526p18922017.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >> >> >> >> > > -- > View this message in context: http://www.nabble.com/Find-Error-in-return-tab-under-order-tab.-tp18920526p18922326.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
| Free forum by Nabble | Edit this page |