Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database error on selecting 'GL Entries'
05-26-2019, 12:15 AM,
#1
Database error on selecting 'GL Entries'
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'
Reply
05-26-2019, 01:08 AM, (This post was last modified: 05-26-2019, 01:19 AM by TimSchofield.)
#2
RE: Database error on selecting 'GL Entries'
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.


.php   GLTransInquiry.php (Size: 7.78 KB / Downloads: 3)
Reply
05-26-2019, 02:47 AM,
#3
RE: Database error on selecting 'GL Entries'
Thanks Tim, working perfectly again.

Regards
Alan
Reply
05-26-2019, 05:37 AM,
#4
RE: Database error on selecting 'GL Entries'
Thanks Tim, pulled!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)