AnsweredAssumed Answered

Summary of certain filtered records from a table

Question asked by willrollo on Aug 11, 2013
Latest reply on Aug 11, 2013 by philmodjunk

Title

Summary of certain filtered records from a table

Post

     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. 

     For example:

                            Product                             Price               Code

     LIne 1           Paper                                  20                      10000   

     Line 2            Delivery                            5                           11000

     LIne 3            Pen                                    2                           10000

      

     SubTotal: 27

Total Coded 10000 - 22

     Thank you

Outcomes