Printing Invoice Statements
I have been trying to find a way to print a complete receivables statement from Filemaker Pro for our customers with outstanding invoices.
Is there a way to do this?
Yes it is quite possible.
Please describe what you want to see in your statement and how it is not working for you.
I am looking for a customer statement that includes:
Invoice DateInvoice NumberBalance OwingAmount PaidStatement Total
Thanks so much for your help.
How have you structured your database?
Do you have a table for recording payments that you link to invoices and customer tables? How have you linked them? Do these links work for you?
If you haven't set this up yet, you might consider the following "business rules" questions as a guide in how to structure your payments:
Do you allow only one payment per invoice and no payment can pay off more than one invoice?
Can a customer pay off part of an invoice?
Can one payment pay off several invoices?
Retrieving data ...