01-30-2012, 07:44 PM
Hi:
Attempting to change the stock category for one item gave us the following error:
Database Error : The stock cost journal could not be inserted because
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 14
Database SQL Failure : The SQL that was used to create the stock cost journal and failed was
INSERT INTO gltrans (type, typeno, trandate, periodno, account, narrative, amount) VALUES ( 0, '925', '2012-01-30', '34', '', 'BSPE12 Change stock category', '0'
Even if the error was displayed, It DID change the stock category.
Stock category has all GL accounts properly set, so I can't understand why the SQL insert has an empty account.
NO record was inserted to gltrans table.
Attempting to change the stock category for one item gave us the following error:
Database Error : The stock cost journal could not be inserted because
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 14
Database SQL Failure : The SQL that was used to create the stock cost journal and failed was
INSERT INTO gltrans (type, typeno, trandate, periodno, account, narrative, amount) VALUES ( 0, '925', '2012-01-30', '34', '', 'BSPE12 Change stock category', '0'
Even if the error was displayed, It DID change the stock category.
Stock category has all GL accounts properly set, so I can't understand why the SQL insert has an empty account.
NO record was inserted to gltrans table.