Jump to content

Creating a summar with a custom function


This topic is 5744 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 5744 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.