Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database error on selecting 'GL Entries'
05-26-2019, 12:15 AM
Post: #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'
Find all posts by this user
Quote this message in a reply
05-26-2019, 01:08 AM (This post was last modified: 05-26-2019 01:19 AM by falkoner.)
Post: #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: 2)
Visit this user's website Find all posts by this user
Quote this message in a reply
05-26-2019, 02:47 AM
Post: #3
RE: Database error on selecting 'GL Entries'
Thanks Tim, working perfectly again.

Regards
Alan
Find all posts by this user
Quote this message in a reply
05-26-2019, 05:37 AM
Post: #4
RE: Database error on selecting 'GL Entries'
Thanks Tim, pulled!
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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