Invoice Statements
Posted: Fri Aug 01, 2008 3:41 am
Hi All,
I want to extend the invoices module by adding a print / pdf statement function.
As a basic I think I'm going to duplicate and then edit the report by customer layout / script but having a few issues, which are mostly down to my ropey filemaker scripting knowledge and wondered if anyone could help.
What I'd like to achieve is that by clicking on the statement button (currently the envelope button, which we don't use) a statement would be generated for just the company that is currently showing in the main window.
To do this I think I need to perform 2 script steps, both of which are giving me a few problems:
- Find the current records company so that only records from the currently shown company are included into the find set.
- List all the records that have an invoice balance (ie, omit any with a zero balance)
Any help most appreciated
cheers, Matt
I want to extend the invoices module by adding a print / pdf statement function.
As a basic I think I'm going to duplicate and then edit the report by customer layout / script but having a few issues, which are mostly down to my ropey filemaker scripting knowledge and wondered if anyone could help.
What I'd like to achieve is that by clicking on the statement button (currently the envelope button, which we don't use) a statement would be generated for just the company that is currently showing in the main window.
To do this I think I need to perform 2 script steps, both of which are giving me a few problems:
- Find the current records company so that only records from the currently shown company are included into the find set.
- List all the records that have an invoice balance (ie, omit any with a zero balance)
Any help most appreciated
cheers, Matt