Split multiple tax in the invoice
If i have 2 diferent tax in lookup.
Example
Tax type - sales - sales
tax type - munincipal - munincipal
How can split in the invoice report?
In the original Invoice Report only i see $f{tax}.
If i run a report i can see a Sum of sales + Munincipal, but i want see a separete detail of tax in the invoice report.
For example.
Sales tax $1.00
munincipal $4.00
Re: Split multiple tax in the invoice
Tax amounts are stored at both the invoice and invoice item level, but not the taxes that were used to derive the amounts.
To see a separate tax detail, you need to customise the jasper report template for invoices. Given the restriction above, its not straight forward.
You'd need to examine each item's tax amount and determine if none, one, or both of sales tax and municipal tax are incorporated. The easiest way to do this may be to calculate the expected tax for each invoice item within the report template and compare that with the actual tax.
-Tim