Dealing With Part invoices

[Lee J]

To All FM Gurus.

I have a system where i track our Time and Materials against our projects or jobs.

This works on the LineItem process via a Portal and todate works really well.

At the end of the Project i go through and "Flag" each of the items with are chargeable and ignore those that are not chargeable.

This then presents me with a Invoice Value which i pass over to my Invoice DB.

What has transpired is, some of the larger projects need to be Part Invoiced.

But to make it a little more complex some clients request a break down based on categories.

I have managed to create the Break downs and display, however i can't seem to find a way so that those items that have already been invoiced are not included in the next invoice stage.

Thanks in advance

FileMaker Version: 6

Platform: Windows XP