Hi, i am new to filemaker. Now, i am working on the invoice system. My original idea is to create a invoice and invoice line item table(portal) to allow generation of the invoice
catagory wording amount
so the invoice report will be based on the invoice line item and the summary field could calculate the total of all items with same invoice number.
i have made a various version for several languages that means i create 6 tables and corresponding line item tables to store the data separately.
Now, my boss would like to have a summary report of the clients(based on the invoice table). so my question is do i need to rewrite the whole app.
my first thought is to combine all the tables into 1 so it is much easy to handle the summary report.
welcome to any approach. Thank you. i am using filemaker 15.
The summary report is like
date invoice number total of each invoice settlement