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

Hi Matt,

Sounds like your script needs to perform one Find...

Set Variable $Customer, InvContactID_kf
Enter Find Mode
Set Field, InvContactID_kf ; $Customer
New Record / Request
Insert Calculated Result, InvAmountBalance ; ">0"
Perform Find

Be sure to trap for no records found in case the customer has no open balance.

Hope that helps,