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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

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

Syndicate content