Re: [WebERP-developers] CounterReturns.php Error

[Phil D. <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