summary portal

[Tim Harris]

Here is the problem I'm trying to solve.

I have a layout for invoices. In the layout is a portal for invoice line items. Each line item has a VAT code and VAT value and net price.

I want to show a 'VAT breakdown' on the Invoice screen. This needs to be a dynamic list, with one line per VAT code. So if the number of invoice line items is 20, and between then there are three VAT types, then the 'VAT Breakdown' will show three lines, with the NET totals for each line.

I don't want to hard code fields, one per VAT type.

[Ocean West]

Welcome to the forums Tim,

You could get a return separated list that sums up the values by type using http://www.fmfunctions.com/fid/118

Edited March 31, 2009 by Guest