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


Messages In This Thread
Import bank deatils with MT940 format - by marienk.lodewijk - 07-15-2015, 04:15 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)