Thread Rating:
  • 0 Vote(s) - 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.)
#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 Files
.php   PDFQuotation.php (Size: 11.48 KB / Downloads: 1)
.php   PDFQuotationPortrait.php (Size: 11 KB / Downloads: 1)
https://www.linkedin.com/in/eclipsepaulbecker
Reply


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

Forum Jump:


Users browsing this thread: 1 Guest(s)