Records not showing up

[Drus]

I have an Accounts Receivable Trial Balance where I need all invoices that meet the following criteria: (a)They must have an invoice balance that does not equal zero; and (b) they must have a transaction date <= 3/31/02.

However, not all records are appearing when I generate the report. All the records that are showing DO meet the criteria, but the report does not include ALL records that meet the criteria.

Any ideas? Andrew Hagenbach
OPUS SYSTEMS, INC.
916.503.3173
ahagenbach@opus-sys.com

 

[Soleil525]

First thing I would do is look at the transaction date to ensure that it is not null or blank and <= 03/31/02 and the invoice amt > 0. Do this for a few records that you are expected to see on the report. You might have done this but I didn't see you mention it in the message.

 

[synapsevampire]

Post the record selection criteria and generated SQL along with some sample data of what is and in't being returned correctly.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com