Menu
▾
▴
web-erp-developers
|
From: ciesac <we...@si...> - 2014-10-18 03:05:17
|
Hi all , I try to return in CounterReturns.php Please any help with this error : Error de Base de Datos 1452 : Cannot insert a GL transaction for the bank account debit Cannot add or update a child row: a foreign key constraint fails (`weberp_databse`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY (`account`) REFERENCES `chartmaster` (`accountcode`)) Database Rollback Due to Error Above : Rolling Back Transaction OK thank you -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/CounterReturns-php-Error-tp4657725.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |
|
From: Phil D. <ph...@lo...> - 2014-10-18 05:08:51
|
It seems you have a mis configuration probably of sales GL postings or COGS GL postings that is set to a non existent GL account Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 18/10/14 15:45, ciesac wrote: > Hi all , I try to return in CounterReturns.php Please any help with this > error : > > Error de Base de Datos 1452 : Cannot insert a GL transaction for the bank > account debit > Cannot add or update a child row: a foreign key constraint fails > (`weberp_databse`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY > (`account`) REFERENCES `chartmaster` (`accountcode`)) > Database Rollback Due to Error Above : Rolling Back Transaction OK > > thank you > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/CounterReturns-php-Error-tp4657725.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push notifications. > Take corrective actions from your mobile device. > http://p.sf.net/sfu/Zoho > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
|
From: Webmaster S. <we...@si...> - 2014-10-19 00:28:56
|
Thanks Phil, where can I look at that? www.sistemaciesac.com we...@si... Cel 00 51 - 99613-7334 RPM #916661 2014-10-18 0:08 GMT-05:00 Phil Daintree <ph...@lo...>: > It seems you have a mis configuration probably of sales GL postings or > COGS GL postings that is set to a non existent GL account > > Phil > > Phil Daintree > Logic Works Ltd - +64 (0)275 567890 > http://www.logicworks.co.nz > > On 18/10/14 15:45, ciesac wrote: > > Hi all , I try to return in CounterReturns.php Please any help with > this > > error : > > > > Error de Base de Datos 1452 : Cannot insert a GL transaction for the > bank > > account debit > > Cannot add or update a child row: a foreign key constraint fails > > (`weberp_databse`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY > > (`account`) REFERENCES `chartmaster` (`accountcode`)) > > Database Rollback Due to Error Above : Rolling Back Transaction OK > > > > thank you > > > > > > > > -- > > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/CounterReturns-php-Error-tp4657725.html > > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > > > ------------------------------------------------------------------------------ > > Comprehensive Server Monitoring with Site24x7. > > Monitor 10 servers for $9/Month. > > Get alerted through email, SMS, voice calls or mobile push notifications. > > Take corrective actions from your mobile device. > > http://p.sf.net/sfu/Zoho > > _______________________________________________ > > Web-erp-developers mailing list > > Web...@li... > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push notifications. > Take corrective actions from your mobile device. > http://p.sf.net/sfu/Zoho > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
|
From: Phil D. <ph...@lo...> - 2014-10-19 01:10:48
|
http://www.weberp.org/weberp/SalesGLPostings.php or http://www.weberp.org/weberp/COGSGLPostings.php Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 19/10/14 12:28, Webmaster SisteMaCiesac wrote: > Thanks Phil, where can I look at that? > > www.sistemaciesac.com <http://www.sistemaciesac.com> > we...@si... <mailto:we...@si...> > Cel 00 51 - 99613-7334 > RPM #916661 > > 2014-10-18 0:08 GMT-05:00 Phil Daintree <ph...@lo... > <mailto:ph...@lo...>>: > > It seems you have a mis configuration probably of sales GL postings or > COGS GL postings that is set to a non existent GL account > > Phil > > Phil Daintree > Logic Works Ltd - +64 (0)275 567890 > http://www.logicworks.co.nz > > On 18/10/14 15:45, ciesac wrote: > > Hi all , I try to return in CounterReturns.php Please any > help with this > > error : > > > > Error de Base de Datos 1452 : Cannot insert a GL transaction > for the bank > > account debit > > Cannot add or update a child row: a foreign key constraint fails > > (`weberp_databse`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY > > (`account`) REFERENCES `chartmaster` (`accountcode`)) > > Database Rollback Due to Error Above : Rolling Back Transaction OK > > > > thank you > > > > > > > > -- > > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/CounterReturns-php-Error-tp4657725.html > > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > > > ------------------------------------------------------------------------------ > > Comprehensive Server Monitoring with Site24x7. > > Monitor 10 servers for $9/Month. > > Get alerted through email, SMS, voice calls or mobile push > notifications. > > Take corrective actions from your mobile device. > > http://p.sf.net/sfu/Zoho > > _______________________________________________ > > Web-erp-developers mailing list > > Web...@li... > <mailto:Web...@li...> > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push > notifications. > Take corrective actions from your mobile device. > http://p.sf.net/sfu/Zoho > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > <mailto:Web...@li...> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push notifications. > Take corrective actions from your mobile device. > http://p.sf.net/sfu/Zoho > > > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Humberto S. <we...@si...> - 2014-10-19 15:31:25
|
Thanks Phil -----Original Message----- From: Phil Daintree <ph...@lo...> Date: Sun, 19 Oct 2014 14:10:37 To: webERP Developers<web...@li...> Reply-To: webERP Developers <web...@li...> Subject: Re: [WebERP-developers] CounterReturns.php Error ------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho |
|
From: Webmaster S. <we...@si...> - 2014-10-21 00:23:51
|
Please Cannot add or update a child row: a foreign key constraint fails > > (`weberp_databse`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY > > (`account`) REFERENCES `chartmaster` (`accountcode`)) I create correct sales GL postings or COGS GL postings but It give me same error , its is like the chartmaster with bank account is not correct set up ? 2014-10-18 20:10 GMT-05:00 Phil Daintree <ph...@lo...>: > http://www.weberp.org/weberp/SalesGLPostings.php > > or > > http://www.weberp.org/weberp/COGSGLPostings.php > > Phil > > Phil Daintree > Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz > > On 19/10/14 12:28, Webmaster SisteMaCiesac wrote: > > Thanks Phil, where can I look at that? > > www.sistemaciesac.com > we...@si... > Cel 00 51 - 99613-7334 > RPM #916661 > > 2014-10-18 0:08 GMT-05:00 Phil Daintree <ph...@lo...>: > >> It seems you have a mis configuration probably of sales GL postings or >> COGS GL postings that is set to a non existent GL account >> >> Phil >> >> Phil Daintree >> Logic Works Ltd - +64 (0)275 567890 >> http://www.logicworks.co.nz >> >> On 18/10/14 15:45, ciesac wrote: >> > Hi all , I try to return in CounterReturns.php Please any help >> with this >> > error : >> > >> > Error de Base de Datos 1452 : Cannot insert a GL transaction for the >> bank >> > account debit >> > Cannot add or update a child row: a foreign key constraint fails >> > (`weberp_databse`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY >> > (`account`) REFERENCES `chartmaster` (`accountcode`)) >> > Database Rollback Due to Error Above : Rolling Back Transaction OK >> > >> > thank you >> > >> > >> > >> > -- >> > View this message in context: >> http://weberp-accounting.1478800.n4.nabble.com/CounterReturns-php-Error-tp4657725.html >> > Sent from the web-ERP-developers mailing list archive at Nabble.com. >> > >> > >> ------------------------------------------------------------------------------ >> > Comprehensive Server Monitoring with Site24x7. >> > Monitor 10 servers for $9/Month. >> > Get alerted through email, SMS, voice calls or mobile push >> notifications. >> > Take corrective actions from your mobile device. >> > http://p.sf.net/sfu/Zoho >> > _______________________________________________ >> > Web-erp-developers mailing list >> > Web...@li... >> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > >> >> >> >> ------------------------------------------------------------------------------ >> Comprehensive Server Monitoring with Site24x7. >> Monitor 10 servers for $9/Month. >> Get alerted through email, SMS, voice calls or mobile push notifications. >> Take corrective actions from your mobile device. >> http://p.sf.net/sfu/Zoho >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > > > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push notifications. > Take corrective actions from your mobile device.http://p.sf.net/sfu/Zoho > > > > _______________________________________________ > Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push notifications. > Take corrective actions from your mobile device. > http://p.sf.net/sfu/Zoho > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > |
|
From: Phil D. <ph...@lo...> - 2014-10-21 00:49:27
|
Have a look also at the gl accounts set up in stock categorirs for each item on the invoice causing the error. Regards Phil Phil Daintree Cell: +64 (0) 275 567890 http://www.logicworks.co.nz On 21 October 2014 12:56:11 PM NZDT, Webmaster SisteMaCiesac <we...@si...> wrote: >Please > >Cannot add or update a child row: a foreign key constraint fails >> > (`weberp_databse`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN >KEY >> > (`account`) REFERENCES `chartmaster` (`accountcode`)) > > >I create correct sales GL postings or COGS GL postings but It give me > same error , its is like the chartmaster with bank account is not >correct set up ? > > > > >2014-10-18 20:10 GMT-05:00 Phil Daintree <ph...@lo...>: > >> http://www.weberp.org/weberp/SalesGLPostings.php >> >> or >> >> http://www.weberp.org/weberp/COGSGLPostings.php >> >> Phil >> >> Phil Daintree >> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz >> >> On 19/10/14 12:28, Webmaster SisteMaCiesac wrote: >> >> Thanks Phil, where can I look at that? >> >> www.sistemaciesac.com >> we...@si... >> Cel 00 51 - 99613-7334 >> RPM #916661 >> >> 2014-10-18 0:08 GMT-05:00 Phil Daintree <ph...@lo...>: >> >>> It seems you have a mis configuration probably of sales GL postings >or >>> COGS GL postings that is set to a non existent GL account >>> >>> Phil >>> >>> Phil Daintree >>> Logic Works Ltd - +64 (0)275 567890 >>> http://www.logicworks.co.nz >>> >>> On 18/10/14 15:45, ciesac wrote: >>> > Hi all , I try to return in CounterReturns.php Please any help >>> with this >>> > error : >>> > >>> > Error de Base de Datos 1452 : Cannot insert a GL transaction for >the >>> bank >>> > account debit >>> > Cannot add or update a child row: a foreign key constraint fails >>> > (`weberp_databse`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN >KEY >>> > (`account`) REFERENCES `chartmaster` (`accountcode`)) >>> > Database Rollback Due to Error Above : Rolling Back Transaction OK >>> > >>> > thank you >>> > >>> > >>> > >>> > -- >>> > View this message in context: >>> >http://weberp-accounting.1478800.n4.nabble.com/CounterReturns-php-Error-tp4657725.html >>> > Sent from the web-ERP-developers mailing list archive at >Nabble.com. >>> > >>> > >>> >------------------------------------------------------------------------------ >>> > Comprehensive Server Monitoring with Site24x7. >>> > Monitor 10 servers for $9/Month. >>> > Get alerted through email, SMS, voice calls or mobile push >>> notifications. >>> > Take corrective actions from your mobile device. >>> > http://p.sf.net/sfu/Zoho >>> > _______________________________________________ >>> > Web-erp-developers mailing list >>> > Web...@li... >>> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>> > >>> >>> >>> >>> >------------------------------------------------------------------------------ >>> Comprehensive Server Monitoring with Site24x7. >>> Monitor 10 servers for $9/Month. >>> Get alerted through email, SMS, voice calls or mobile push >notifications. >>> Take corrective actions from your mobile device. >>> http://p.sf.net/sfu/Zoho >>> _______________________________________________ >>> Web-erp-developers mailing list >>> Web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>> >> >> >> >> >------------------------------------------------------------------------------ >> Comprehensive Server Monitoring with Site24x7. >> Monitor 10 servers for $9/Month. >> Get alerted through email, SMS, voice calls or mobile push >notifications. >> Take corrective actions from your mobile >device.http://p.sf.net/sfu/Zoho >> >> >> >> _______________________________________________ >> Web-erp-developers mailing >lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> >> >> >> >------------------------------------------------------------------------------ >> Comprehensive Server Monitoring with Site24x7. >> Monitor 10 servers for $9/Month. >> Get alerted through email, SMS, voice calls or mobile push >notifications. >> Take corrective actions from your mobile device. >> http://p.sf.net/sfu/Zoho >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> > > >------------------------------------------------------------------------ > >------------------------------------------------------------------------------ >Comprehensive Server Monitoring with Site24x7. >Monitor 10 servers for $9/Month. >Get alerted through email, SMS, voice calls or mobile push >notifications. >Take corrective actions from your mobile device. >http://p.sf.net/sfu/Zoho > >------------------------------------------------------------------------ > >_______________________________________________ >Web-erp-developers mailing list >Web...@li... >https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Webmaster S. <we...@si...> - 2014-10-26 21:07:11
|
Yes I fixed it , was an old file, now I am updated this file, thanks for your help Phil Best Regards www.sistemaciesac.com we...@si... Cel 00 51 - 99613-7334 RPM #916661 2014-10-20 19:49 GMT-05:00 Phil Daintree <ph...@lo...>: > Have a look also at the gl accounts set up in stock categorirs for each > item on the invoice causing the error. > Regards > Phil > Phil Daintree > Cell: +64 (0) 275 567890 > http://www.logicworks.co.nz > > On 21 October 2014 12:56:11 PM NZDT, Webmaster SisteMaCiesac < > we...@si...> wrote: > >> Please >> >> Cannot add or update a child row: a foreign key constraint fails >>> > (`weberp_databse`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY >>> > (`account`) REFERENCES `chartmaster` (`accountcode`)) >> >> >> I create correct sales GL postings or COGS GL postings but It give me >> same error , its is like the chartmaster with bank account is not >> correct set up ? >> >> >> >> >> 2014-10-18 20:10 GMT-05:00 Phil Daintree <ph...@lo...>: >> >>> http://www.weberp.org/weberp/SalesGLPostings.php >>> >>> or >>> >>> http://www.weberp.org/weberp/COGSGLPostings.php >>> >>> Phil >>> >>> Phil Daintree >>> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz >>> >>> On 19/10/14 12:28, Webmaster SisteMaCiesac wrote: >>> >>> Thanks Phil, where can I look at that? >>> >>> www.sistemaciesac.com >>> we...@si... >>> Cel 00 51 - 99613-7334 >>> RPM #916661 >>> >>> 2014-10-18 0:08 GMT-05:00 Phil Daintree <ph...@lo...>: >>> >>>> It seems you have a mis configuration probably of sales GL postings or >>>> COGS GL postings that is set to a non existent GL account >>>> >>>> Phil >>>> >>>> Phil Daintree >>>> Logic Works Ltd - +64 (0)275 567890 >>>> http://www.logicworks.co.nz >>>> >>>> On 18/10/14 15:45, ciesac wrote: >>>> > Hi all , I try to return in CounterReturns.php Please any help >>>> with this >>>> > error : >>>> > >>>> > Error de Base de Datos 1452 : Cannot insert a GL transaction for the >>>> bank >>>> > account debit >>>> > Cannot add or update a child row: a foreign key constraint fails >>>> > (`weberp_databse`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY >>>> > (`account`) REFERENCES `chartmaster` (`accountcode`)) >>>> > Database Rollback Due to Error Above : Rolling Back Transaction OK >>>> > >>>> > thank you >>>> > >>>> > >>>> > >>>> > -- >>>> > View this message in context: >>>> http://weberp-accounting.1478800.n4.nabble.com/CounterReturns-php-Error-tp4657725.html >>>> > Sent from the web-ERP-developers mailing list archive at Nabble.com. >>>> > >>>> > >>>> ------------------------------------------------------------------------------ >>>> > Comprehensive Server Monitoring with Site24x7. >>>> > Monitor 10 servers for $9/Month. >>>> > Get alerted through email, SMS, voice calls or mobile push >>>> notifications. >>>> > Take corrective actions from your mobile device. >>>> > http://p.sf.net/sfu/Zoho >>>> > _______________________________________________ >>>> > Web-erp-developers mailing list >>>> > Web...@li... >>>> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>>> > >>>> >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Comprehensive Server Monitoring with Site24x7. >>>> Monitor 10 servers for $9/Month. >>>> Get alerted through email, SMS, voice calls or mobile push >>>> notifications. >>>> Take corrective actions from your mobile device. >>>> http://p.sf.net/sfu/Zoho >>>> _______________________________________________ >>>> Web-erp-developers mailing list >>>> Web...@li... >>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>>> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Comprehensive Server Monitoring with Site24x7. >>> Monitor 10 servers for $9/Month. >>> Get alerted through email, SMS, voice calls or mobile push notifications. >>> Take corrective actions from your mobile device.http://p.sf.net/sfu/Zoho >>> >>> >>> >>> _______________________________________________ >>> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Comprehensive Server Monitoring with Site24x7. >>> Monitor 10 servers for $9/Month. >>> Get alerted through email, SMS, voice calls or mobile push notifications. >>> Take corrective actions from your mobile device. >>> http://p.sf.net/sfu/Zoho >>> _______________________________________________ >>> Web-erp-developers mailing list >>> Web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>> >>> >> ------------------------------ >> >> Comprehensive Server Monitoring with Site24x7. >> Monitor 10 servers for $9/Month. >> Get alerted through email, SMS, voice calls or mobile push notifications. >> Take corrective actions from your mobile device. >> http://p.sf.net/sfu/Zoho >> >> ------------------------------ >> >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push notifications. > Take corrective actions from your mobile device. > http://p.sf.net/sfu/Zoho > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X