I'm building a report where I need 2 totals. One is total sales from IN, which is the total of all records for a given date. The second total is the quantity sold from the same IN record, but only for certain items sold. In other words, for any given record in the table, I may or may not want to add the quantity sold to a total (or column) based on its item number.

I want both totals to show on the same report. I can use an "if" statement to report the quantity for one item but I can't find a way to filter for any of a variety of items.

Hi Kate

This will be very hard to explain on the forum, and very easy to explain while you are watching. Some questions just don't lend themselves to the forum.

Why don't you ask your Adagio consultant this question, and if he/she doesn't know the answer, have that person contact me?

Also, it would help if you mentioned the modules (I'm assuming Invoices) and the versions.

Steve
steve@sschwartzcpa.com

PS - The invoices table is tricky because credit notes show as positives, so you have to "turn them around".

Thanks Steve. I caught the credit note thing. I'll call my representative.

Kate