Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Pro Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-04-2018, 04:32 PM
Yachtcollector Yachtcollector is offline
Registered User
 
Join Date: Sep 2011
Location: Windham, NH 03087
Posts: 9
Understanding Date Ranges in Reports

Recently, I needed to run a report showing all the transactions of a certain type and in a certain range of time. I set the parameters in the report tool and ran the report. This resulted in showing ALL the defined transactions over the five year period we have used QuickBooks, not the period I defined. I tried this a few more times and got the same results.

The attached photo show an example of this. I have searched my account for all the annual dues payments I made in the period 12/01/2017 to 1/1/2018. (I'm actually a life-honors member and have not made dues payment since 2015.) but as you can see, the report shows all the payments I made back to 2011; not the range I searched.

How do I run these reports so that they search the period I defined?

A photo of my screen with the report and the setup is posted at https://1drv.ms/i/s!AiR9KzpBmPls0E25kquqKSRvZou5. Isn't a bit unreasonable that you can't directly ATTACH an image to the forum!!!!!!!
Attached Images
File Type: jpg screen shot 1.jpg (157 Bytes, 11 views)

Last edited by Yachtcollector; 01-04-2018 at 04:52 PM.
Reply With Quote
  #2  
Old 01-04-2018, 05:33 PM
Froid Froid is offline
Registered User
 
Join Date: Feb 2017
Location: Southern California
Posts: 128
You can post images hosted on another site, inserted as below with [IMG] and [/IMG] wrapping your hosted image.

[IMG] http://zzzzzzzzzzzzzzzzzzzz.com/data/717/xxxxxxx.jpg [/IMG]

People are never real keen about clicking to a link.
Reply With Quote
  #3  
Old 01-04-2018, 07:54 PM
Yachtcollector Yachtcollector is offline
Registered User
 
Join Date: Sep 2011
Location: Windham, NH 03087
Posts: 9
It's a Microsoft Onedrive link. What's with not being able to directly attach a photo? I tried ten times - it just would not work.
Reply With Quote
  #4  
Old 01-04-2018, 08:16 PM
Froid Froid is offline
Registered User
 
Join Date: Feb 2017
Location: Southern California
Posts: 128
Haven't done this for awhile. Lemme see if this works. Dang...forgot how to do it!

http://gallery.roadbikereview.com/data/717/scones.jpg

Last edited by Froid; 01-04-2018 at 08:37 PM.
Reply With Quote
  #5  
Old 01-04-2018, 08:51 PM
Yachtcollector Yachtcollector is offline
Registered User
 
Join Date: Sep 2011
Location: Windham, NH 03087
Posts: 9
Working Now

OK, this is a stupid answer but here goes. I was working from a report I built a while back to do something else. Try as I might, the date ranges would not work. I opened another report, which I did not build and I don't use it, I changed the fields to meet the criteria I needed to find including the date range. It pulled up the information perfectly. Why would one report behave very differently than another report?
Reply With Quote
  #6  
Old 01-04-2018, 10:25 PM
Lorin Browning Lorin Browning is offline
Registered User
 
Join Date: Apr 2004
Location: Landrum SC
Posts: 638
Have you compared the filters from one query to the other?

Have you verified that the size of a jpg that you want to attach is smaller than the size of a jpg allowed on this board?
__________________
Lorin Browning, Ph. D.
Fellow -- National Tax Practice Institute
lorin@lorinbrowning.com

Last edited by Lorin Browning; 01-04-2018 at 10:29 PM.
Reply With Quote
  #7  
Old 01-05-2018, 07:29 AM
Yachtcollector Yachtcollector is offline
Registered User
 
Join Date: Sep 2011
Location: Windham, NH 03087
Posts: 9
Yes. I set the filter in the report exactly as in the report that would not work. One works, one pulls up ever transaction for as long as we have had QB. It's a puzzle but at least I now have a work-around - don't start with that old report.

As for the JPG, yes I saw the limitation of 100kb. My file is 168kb - that is probably the issue, but this is just a screen shot. How could you reasonably make this any smaller?
Reply With Quote
  #8  
Old 01-05-2018, 10:31 AM
Lorin Browning Lorin Browning is offline
Registered User
 
Join Date: Apr 2004
Location: Landrum SC
Posts: 638
Photoshop.
__________________
Lorin Browning, Ph. D.
Fellow -- National Tax Practice Institute
lorin@lorinbrowning.com
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 05:39 PM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.