webERP Forum

Full Version: Database error on selecting 'GL Entries'
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
When running 'Supplier Account Inquiry' and then selecting 'GL Entries', I get the following error.
Running latest from github.

Code:
Database Error 1054 :
Unknown column 'supptrans.ovdiscount' in 'field list'

Code:
Database SQL Failure : The SQL that failed was
SELECT supptrans.supplierno AS otherpartycode, supptrans.ovamount, supptrans.ovgst, supptrans.rate, supptrans.ovdiscount, suppliers.suppname AS otherparty FROM supptrans INNER JOIN suppliers ON supptrans.supplierno = suppliers.supplierid WHERE supptrans.type = '20' AND supptrans.transno = '163'
Hi Alan, this is a problem with this commit - https://github.com/timschofield/webERP-s...30fd47a22f

I am attaching the corrected file.

Tim

PaulT : I have sent a pull request to your release branch.

[attachment=962]
Thanks Tim, working perfectly again.

Regards
Alan
Thanks Tim, pulled!
Reference URL's