Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Import bank deatils with MT940 format
07-15-2015, 04:15 PM,
#1
Import bank deatils with MT940 format
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
Reply
07-15-2015, 11:17 PM,
#2
RE: Import bank deatils with MT940 format
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?
Reply
07-16-2015, 12:04 AM, (This post was last modified: 07-16-2015, 12:05 AM by TimSchofield.)
#3
RE: Import bank deatils with MT940 format
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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)