AnsweredAssumed Answered

Product Category Accounting Report

Question asked by SamOsman on Sep 26, 2016
Latest reply on Sep 26, 2016 by SamOsman

Hi,

 

I have a database that's based on the Invoice Starter Solution. I'm wanting to create a report like the following, have tried to do this with sub-summary parts, but can not get my head around the correct way of doing it. Hope someone can put me in the right direction.

 

InvoiceNumberInvoiceDateCustomerNameTotal Invoice PriceVATCat1Cat2Cat3
00125/12/16Smith£16.80£2.80£11.00£3.00

 

This would show each invoice on a line, with the invoice line items broken down by their category. For example, 2 products above are in 'Cat1' and 1 product is in Cat2. So this is totalled per invoice, and then each invoice split up the totals by the categories, which are set in the 'Product' table in the database.

Outcomes