Best approach for VAT amounts by VAT code presentation in Invoice
I have to create an Invoice. I have a Master that stores all invoice amounts including VAT TOTAL AMOUNT. I have a Detail that has all products records that stores in each record VAT Code and VAT amount for that product line.
Now I want to print one Invoice, with all its product lines including Vat details, I'm ok with that I have all necessary information. Now I have also to print on the same report the sum of VAT amount for each Vat Codes that I have in invoice, could be more than one. What is the best approach to do that in FastReport? I'm new with that solution and I have to tell that I'm lost between Master.Detail approach, Group approach, Sub Report etc...
Thanks in advance for your advice,
This discussion has been closed.
Comments
At the end I found my solution using a mix of the 3 approaches above. Discussion closed.
Hello!
We’re delighted that you’ve already put together a working layout! For an invoice with VAT breakdown by VAT code, the ideal combination is the Master DataBand (Invoices) -> Detail DataBand (Line Items) + a child Subreport (or a DataBand from the same invoice) with a GroupHeader by VAT Code and a Total (Sum) in the GroupFooter, linked by InvoiceId.
If you have any questions regarding pagination or filtering within such a Subreport, please attach an example .frx file and we’ll help you configure i