Thank you for your post.
I'm having a problem looking for a "Sales Invoice" template. The closest one I can find is the "Purchase Orders" template that comes with FileMaker Pro 10.
The Line Items table contains the details of each Purchase Order, so select this table to do your reporting purposes. You can then set up a Sub-Summary when sorted by ID_Product.
I would not advise moving this information into a Repeating field. A Repeating field is a single field that contains many values, and you will be unable to summarize the information.
Any other information you can provide may be helpful.
Thank you for this. The template I am using is Filemaker Pro Business Productivity Solution - Sales Orders.
This is nearly perfect, apart from this one challenge! I want to see a product report not just all of my sales per invoice.
There is also a Stock Database attached - inventory - wondered if this could do it as well or also? it would be good to see a report of what products went out and in from the sales each week.
Thank you for the clarification.
The Business Productivity Solution can definitely be modified. As I look on the Sales Report, the entries are made into the Line Items table. You can create a report based on the Line Items table and group/sub-summarize by Product Serial Number. Add a Summary field to total the Amount field and place that in the Sub-Summary part.
Thank you! will give it a go