webERP Forum

Full Version: Customer Transaction Inquiries > Credit Note SQL Error - SOLVED
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
CustomerInquiry.php

When clicking on More Info > PDF we get a SQL error but if clicking More Info > HTML works just fine.

ERROR Message Report : There was a problem retrieving the invoice or credit note details for note number from the database. To print an invoice, the sales order record, the customer transaction record and the branch record for the customer must not have been purged. To print a credit note only requires the customer, transaction, salesman and branch records be available
ERROR Message Report : The SQL used to get this information that failed was
SELECT debtortrans.trandate, debtortrans.ovamount, debtortrans.ovdiscount, debtortrans.ovfreight, debtortrans.ovgst, debtortrans.rate, debtortrans.invtext, debtorsmaster.invaddrbranch, debtorsmaster.name, debtorsmaster.address1, debtorsmaster.address2, debtorsmaster.address3, debtorsmaster.address4, debtorsmaster.address5, debtorsmaster.address6, debtorsmaster.currcode, debtorsmaster.taxref, debtorsmaster.language_id, custbranch.brname, custbranch.braddress1, custbranch.braddress2, custbranch.braddress3, custbranch.braddress4, custbranch.braddress5, custbranch.braddress6, custbranch.brpostaddr1, custbranch.brpostaddr2, custbranch.brpostaddr3, custbranch.brpostaddr4, custbranch.brpostaddr5, custbranch.brpostaddr6, custbranch.salesman, salesman.salesmanname, debtortrans.debtorno, debtortrans.branchcode, paymentterms.terms, currencies.decimalplaces FROM debtortrans INNER JOIN debtorsmaster ON debtortrans.debtorno=debtorsmaster.debtorno INNER JOIN custbranch ON debtortrans.debtorno=custbranch.debtorno AND debtortrans.branchcode=custbranch.branchcode INNER JOIN salesman ON custbranch.salesman=salesman.salesmancode INNER JOIN currencies ON debtorsmaster.currcode=currencies.currabrev WHERE debtortrans.type=11 AND debtortrans.transno='10101'

Looking in to it now...
Error in query (1054): Unknown column 'paymentterms.terms' in 'field list'
This works fine:
PrintCustTransPortrait.php?FromTransNo=10108&InvOrCredit=Invoice&PrintPDF=True

But this does not:
PrintCustTrans.php?FromTransNo=10108&InvOrCredit=Invoice&PrintPDF=True
Added the following to the query:

PHP Code:
INNER JOIN paymentterms
ON debtorsmaster
.paymentterms=paymentterms.termsindicator 
Thanks, Paul.

I believe that has been fixed with 4.15. There were many changes to those files to get them mostly aligned with similar handling, including the queries.

If there might be something not covered, please let me know.

An overview of the changes are here.
Yes... I should have mentioned we are still using 4.14.1.

It will be some time before we merge our branch with 4.15.X branch...
Reference URL's