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