Post Reply 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Tax Rates Do Not Add Up - SOLVED?
12-27-2017, 10:56 PM (This post was last modified: 12-28-2017 05:37 AM by VortecCPI.)
Post: #1
Tax Rates Do Not Add Up - SOLVED?
When using a one-to-many relationship for tax rates the total tax rate is not concatenating.

Looking at PDFQuotation.php It appears as if the SQL only uses one associated record and it should use associated records.

I built a Tax Group of 7% by concatenating Tax Authorities and applicable rates but i only end up with 4% as the Tax Rate.

The idea is to be able to build Tax Rates similar to building a binary number in that it is simply combinations of Tax Rates.




The logic shown above results in a Tax rate of 4% instead of 7% and I believe that is due to the 4th SQL loop being outside of the 3rd SQL loop.

My fixes are attached so can somebody please verify my work, especially with respect to tax upon tax flag.

Attached File(s)
.php  PDFQuotation.php (Size: 11.48 KB / Downloads: 1)
.php  PDFQuotationPortrait.php (Size: 11 KB / Downloads: 1)
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 

Messages In This Thread
Tax Rates Do Not Add Up - SOLVED? - VortecCPI - 12-27-2017 10:56 PM

Forum Jump:

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