Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
GL Import error
10-06-2015, 07:54 AM
Post: #1
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
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
GL Import error - daveparrish - 10-06-2015 07:54 AM
RE: GL Import error - agaluski - 10-06-2015, 08:02 AM
RE: GL Import error - daveparrish - 10-06-2015, 08:52 AM
RE: GL Import error - daveparrish - 10-06-2015, 10:28 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)