I have written an invoicing package for my company in FileMaker Pro 8. Each line item on the invoice has a Revenue Code ("revCode") and at the bottom of the invoice I would like it to list each revenue code and the total amount that goes in to each.

For example:

If I have an invoice with 4 line items.

Item 1: $5.98 RevCode: 001 3994 994

Item 2: $38.40 RevCode: 001 2993 449

Item 3: $9.95 RevCode: 001 3994 994

Item 4: $11.02 RevCode: 001 3304 299

And at the bottom of the invoice I would like a summary printed that would look like this:

Rev Code: 001 3994 994 Amt: $15.93

Rev Code: 001 2993 449 Amt: $38.40

Rev Code: 001 3304 299 Amt: $11.02

Some background:

Each line item is a different record. They are all tied together by "invoiceNumber". So to print an invoice we are performing a Find on "invoiceNumber".

Thanks for the help!

sorry way lack of cafeen hope this helps... there 2 scritpt options...

first 1 goes to line item and just sub summarizes only showing unique rev codes.

Second one populates a few globals to stack up the summary...

sample.fp7.zip

Ugo and Comment have more or less made precedence in this area, by using selfjoins for this purpose - not quite knowing when the straw that breaks the camels back actually is reached?

But the issue is that it's not necessarily a scripted matter, it could be achieved by an extra portal as well, exploiting tunneled relations...

--sd

sampleMod.zip

Edited March 15, 200619 yr by Guest