1 Reply Latest reply on Jun 25, 2014 3:49 PM by philmodjunk

    Printing Invoices by date and or by customer



      Printing Invoices by date and or by customer


           Looking for a way to be able to print ALL invoices for a selected date or select a customer with open invoices. I want a button to select a date and "Print All Invoices for 6/25/14

        • 1. Re: Printing Invoices by date and or by customer

               From the other thread title that you posted at the same time, your invoices database is based on one of the invoices starter solutions? For which version of FileMaker? (the starter solutions differ with each release of FileMaker.)

               These starter solutions use two related tables to hold the data specific to an invoice with additional data in other related tables:

               Customer---<Invoices----<Invoice Data>----Products

               On the invoice layout, you'll find a portal to Invoice Data where each item purchased is a row in this portal. They print a single invoice by using a list view layout based on Invoice Data. A script pulls up the found set for the current invoice's related Invoice data records on this layout, where fields from Invoices are included in the header and footer of this layout.

               The simplest method for printing a set of invoices from this starter solution is to:

               a) perform a find for the invoices on an invoices based layout

               b) Loop through those invoices using the already written script for printing an invoice--printing one invoice at a time, but in a loop.

               You may find the scripted find examples in this thread to be useful: Scripted Find Examples