We have a crystal report template we use for creating invoices. We need to summarise the taxes, the problem is, the taxes are compound taxes, and not always made up of the same components.
Each item on the invoice can have up to three taxes defined. Local, State, plus withholding taxes, of which there are over 15 kinds. In the database we have six fields, three that define which tax has been used, and what the tax amount is. For example:
Desc Price TaxCode1 Tax Amount1 TaxCode2 Tax Amount2 TaxCode3 Tax Amount3
Widget 1 100.00 VAT 10.00 Empty 0 Empty 0
Widget 2 100.00 VAT 10.00 PPN 11.00 Empty 0
Widget 3 100.00 PPN 10 PPH23 -2.30 PPH25 -10.00
What I need in the footer is
Can anyone tell me how to make a Crystal Reports Function to calculate these summaries.
The complication is the tax names, and taxes used, varies from invoice to invoice, and from installation to installation. So we need to summarize them based on the names in the actual database.
Many thanks for you help.