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

    creating invoices

    Fryx

      Title

      creating invoices

      Post


           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:

           Customer

           Order date/ description /amount

           Another order date./ description/ amount

           Total of amounts

            

           Any advice much appreciated.