Re: [WebERP-developers] CounterReturns.php Error

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

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