Re: [WebERP-developers] Error in suppinvstogrn

[Rafael C. <raf...@gm...>]

More info:

Database Error 1452 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
ASSISTANCE: The invoice could not be mapped to the goods received record
because Cannot add or update a child row: a foreign key constraint fails
(`verdoram_erp`.`suppinvstogrn`, CONSTRAINT `suppinvstogrn_ibfk_1` FOREIGN
KEY (`suppinv`) REFERENCES `supptrans` (`id`))

Database SQL Failure : The following SQL to map the invoice to the GRN was
used INSERT INTO suppinvstogrn VALUES ('457', '123')

Operation:
Enter an invoice, from a purchase order.
Existent suppinv=supptrans.id=457.  No, next auto_increment: 367.
Existent grnno=grns.grnno=123. Yes, It is the last record. Next
auto_increment: 124.

Regards, Rafael.



2015-11-30 9:33 GMT-06:00 Tim Schofield <tim...@gm...>:

> Hi Rafael, could it be that you already have a credit note with that
> transaction number. Try echoing the SQL at line 1553 of
> SupplierInvoice.php and let me know what the output is.
>
> Thanks
> Tim
>
> On 30 November 2015 at 15:08, Rafael Chacón
> <raf...@gm...> wrote:
> > Hi All,
> >
> > I updated a webERP to test. I got this error:
> >
> > Cannot add or update a child row: a foreign key constraint fails
> > (`verdoram_erp`.`suppinvstogrn`, CONSTRAINT `suppinvstogrn_ibfk_1`
> FOREIGN
> > KEY (`suppinv`) REFERENCES `supptrans` (`id`))
> >
> > Somebody has an idea abiout how to trouble shoutting this?
> >
> > Best regards, Rafael.
> >
> >
> ------------------------------------------------------------------------------
> > Go from Idea to Many App Stores Faster with Intel(R) XDK
> > Give your users amazing mobile app experiences with Intel(R) XDK.
> > Use one codebase in this all-in-one HTML5 development environment.
> > Design, debug & build mobile apps & 2D/3D high-impact games for multiple
> > OSs.
> > http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>
> --
> Course View Towers,
> Plot 21 Yusuf Lule Road,
> Kampala
> T   +256 (0) 312 314 418
> M +256 (0) 752 963 325
> www.weberpafrica.com
> Twitter: @TimSchofield2
> Blog: http://weberpafrica.blogspot.co.uk/
>