Re: [WebERP-developers] CounterReturns.php Error

[Webmaster S. <we...@si...>]

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
>
>