GL Import error
Hi All
I have two servers setup one lab and one production I was able to import the GL accounts into the Lab server with no problem but when I try to import into the production server I get the following error.
Both server are setup exactly the same.
Database Error 1366 :
Incorrect integer value: '' for column 'chequeno' at row 1
Database SQL Failure : The SQL that failed was
INSERT INTO gltrans (type, typeno, chequeno, trandate, periodno, account, narrative, amount, tag ) VALUES ( '0', '4', '', '2015-9-1', '4', '1000', 'Import from Facts system', '-121741.09', '' )
Any help would be appreciated.
Thanks
Davwe
|