+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: Import bank deatils with MT940 format (/showthread.php?tid=2520)
Import bank deatils with MT940 format - marienk.lodewijk - 07-15-2015
Hell when i have analyse my acounting in the import page for banking i get this error:
Database Error 1452 : Cannot insert a GL entry for the payment because
Cannot add or update a child row: a foreign key constraint fails (`lodewijk_mlid`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY (`account`) REFERENCES `chartmaster` (`accountcode`))
Database SQL Failure : The SQL that failed to insert the payment GL entry was
INSERT INTO gltrans (type, typeno, trandate, periodno, account, narrative, amount) VALUES (1, '1', '2015-01-15', '-5', '', 'RFNONREF//B5A15PGSAO84K7FQ\n FACTUUR 512591 874100\n', '-400')
Database Rollback Due to Error Above : Rolling Back Transaction OK
Next to that i have discoverd that it the import in totaly not working on IE 11
RE: Import bank deatils with MT940 format - agaluski - 07-15-2015
Error message states you don't have a G/L Account code setup for the account code in your input file. can you post your input file?
RE: Import bank deatils with MT940 format - TimSchofield - 07-16-2015
The accountcode field in that sql given in the error message is empty. To be honest I don't know this script but is it possible a correct bank account hasn't been selected?
Tim