Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Quotation PDF - Tax Issue
02-08-2018, 01:54 AM (This post was last modified: 02-08-2018 02:23 AM by VortecCPI.)
Post: #1
Quotation PDF - Tax Issue
PDFQuotation.php and PDFQuotationPortrait.php

Both scripts are missing an additional JOIN on salesorders.debtorno=custbranch.debtorno which could cause a return of multiple records in the results from $sql3.

   

   

Of course salesorders.debtorno must be added to $sql to fulfill and support the above JOIN.

My shot at a code repair is attached...


Attached File(s)
.php  PDFQuotationPortraitSVN.php (Size: 10.46 KB / Downloads: 0)
.php  PDFQuotationSVN.php (Size: 11.17 KB / Downloads: 0)

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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