Summary of certain filtered records from a table
I have an invoice solution, tables of which include; Invoice Details, Invoice Items and Products.
Each product record has a nominal ledger code (only three different codes, numerical).
When an invoice is created, there are normally about three lines that have one code, and two other lines with their unique codes. I need to create a way of totally each coded line items, as opposed to the total of all line items.
Product Price Code
LIne 1 Paper 20 10000
Line 2 Delivery 5 11000
LIne 3 Pen 2 10000
Total Coded 10000 - 22