Hi,
I usually don't do much with custom reports, but I'm trying to do an AP report that basically reports check payments for a given date range. I have my transaction date range showing current dates, yet when I run the report it's giving me 3 or 4 years of data....and I'm only asking for the current month.
Any ideas?
Thanks.
AP Custom Report
Moderators: Moderators, Tech Support
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: AP Custom Report
How is the actual query listed on the screen with the big "Run Query" button?
One I just created shows the following and works fine:
(Transaction Date ranges from 01/01/2011 to 01/31/2011)
This was done using the "between two dates" selection on the query builder.
One I just created shows the following and works fine:
(Transaction Date ranges from 01/01/2011 to 01/31/2011)
This was done using the "between two dates" selection on the query builder.
Re: AP Custom Report
My query looks just like yours does....except with a few additions.
(Transaction Date ranges from 01/01/2011 to 01/31/2011)
and Transaction Type exactly matches Manual Check or Computer Check
and Reference does not contain VOID
This is what my Query screen looks like. It runs fine, it just gives me data all the way back to 2004.
(Transaction Date ranges from 01/01/2011 to 01/31/2011)
and Transaction Type exactly matches Manual Check or Computer Check
and Reference does not contain VOID
This is what my Query screen looks like. It runs fine, it just gives me data all the way back to 2004.
Re: AP Custom Report
Try changing it to look like this:fbcacctg wrote:My query looks just like yours does....except with a few additions.
(Transaction Date ranges from 01/01/2011 to 01/31/2011)
and Transaction Type exactly matches Manual Check or Computer Check
and Reference does not contain VOID
This is what my Query screen looks like. It runs fine, it just gives me data all the way back to 2004.
(Transaction Date ranges from 01/01/2011 to 01/31/2011)
and (Transaction Type exactly matches Manual Check or Computer Check)
and (Reference does not contain VOID)
I think that second line may be tripping you up as the system is taking that OR before 'Computer Check' and linking it to the last AND.
The joys of and/or logic and grouping !!
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: AP Custom Report
Yep, the problem is a lack of brackets!