2 Replies Latest reply on Sep 23, 2012 11:45 AM by willrollo

    creating invoices



      creating invoices


           I'm trying to create a database with tables for customers, orders, payments and invoices. I've looked at existing template solutions and none really matches our needs. What's the best way to handle multiple orders (or payments) from a single customer, so they will show up in a list on an invoice (kind of like on a credit-card statement)? I can create orders linked to a customer, but then they only show up in an invoice-type layout when I view as a table, and I can't get a total to appear.

           I guess what I'm after here is the best setup that will allow me to output something like this:


           Order date/ description /amount

           Another order date./ description/ amount

           Total of amounts


           Any advice much appreciated.