web-erp-users

[webERP-users] Problem with my first Credit

[Terry P. <te...@tj...>]

*Database Error 1452* : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
ASSISTANCE: The debtor transaction taxes records could not be inserted
because
Cannot add or update a child row: a foreign key constraint fails
(`expert_wifi`.`debtortranstaxes`, CONSTRAINT `debtortranstaxes_ibfk_1`
FOREIGN KEY (`taxauthid`) REFERENCES `taxauthorities` (`taxid`))
*Database SQL Failure* : The following SQL to insert the debtor transaction
taxes record was used
INSERT INTO debtortranstaxes( debtortransid, taxauthid, taxamount)
VALUES('349', '', '0')
*Database Rollback Due to Error Above* : Rolling Back Transaction OK



webERP version 4.12.3

I was trying to credit a invoice (my first ever credit attempt) using the
shipping cost credit entry. I get the same error if I try and credit using
a Item line.

Anyone have any advice ?


-- 
Best Regards
Terry Porter <te...@tj...>



<http://expert-wifi.com>

Re: [webERP-users] Problem with my first Credit

[<ph...@lo...>]

Hi Terry

Have you got a tax category for Freight set up?
Sadly this is a limitiation and was hard coded...

Phil

On 2016-03-08 17:15, Terry Porter wrote:
> Database Error 1452 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> ASSISTANCE: The debtor transaction taxes records could not be inserted
> because
> Cannot add or update a child row: a foreign key constraint fails
> (`expert_wifi`.`debtortranstaxes`, CONSTRAINT
> `debtortranstaxes_ibfk_1` FOREIGN KEY (`taxauthid`) REFERENCES
> `taxauthorities` (`taxid`))
> DATABASE SQL FAILURE : The following SQL to insert the debtor
> transaction taxes record was used
> INSERT INTO debtortranstaxes( debtortransid, taxauthid, taxamount)
> VALUES('349', '', '0')
> 
> DATABASE ROLLBACK DUE TO ERROR ABOVE : Rolling Back Transaction OK
> 
> webERP version 4.12.3
> 
> I was trying to credit a invoice (my first ever credit attempt) using
> the shipping cost credit entry. I get the same error if I try and
> credit using a Item line.
> 
> Anyone have any advice ?
> 
> --
> 
> Best Regards
> Terry Porter <te...@tj...>
> 
>  [1]
> 
> Links:
> ------
> [1] http://expert-wifi.com
> 
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
> 
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

Re: [webERP-users] Problem with my first Credit

[rfthomas <rf...@as...>]

Terry,

Could this be realted to the problem reported and fixed in:

http://weberp-accounting.1478800.n4.nabble.com/Problems-with-Credit-Notes-td4658527.html

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problem-with-my-first-Credit-tp4658547p4658556.html
Sent from the web-ERP-users mailing list archive at Nabble.com.