AnsweredAssumed Answered

creating invoices

Question asked by Fryx on Sep 22, 2012
Latest reply on Sep 23, 2012 by willrollo


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.