[WebERP-developers] Error with new GLPosting.inc when addding a GL account

[Pak R. <pak...@gm...>]

Hi Exson:

For business reasons, I just had to create a new GL account and record a
transaction against it. When I tried to see the balance sheet afterwards I
get this error:

*Database Error 1064* : Failed to retrieve new account code and periods
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 'code IS NULL
ORDER BY accountcode,periodno' at line 6
*Database SQL Failure* : The SQL that failed was
SELECT chartmaster.accountcode,periods.periodno FROM (chartmaster CROSS
JOIN periods) LEFT JOIN chartdetails ON
chartmaster.accountcode=chartdetails.accountcode AND
periods.periodno=chartdetails.period WHERE (periods.periodno BETWEEN '-14'
AND '106') AND chartdetails.account code IS NULL ORDER BY
accountcode,periodno

I think it's related to the new GLPosting.inc file, as it's the only
updated file we played with lately. I reverted the GLPosting.inc file to
the previous version and worked OK again, so seems like related to the new
GLPosting.inc

Could you please check it out?

Regards,
Ricard