• From: Canada, Ontario, Kitchener
  • Registered: 03/03/2024
  • Posts: 19

Topic: Date Range for Search

Is there any way to set the auto date range to a longer range in the search function?  I was digging through the config file, but couldn't locate anything.  I am having to broaden the search range constantly to reach back to where I need to start looking.

Additionally, if anyone has ideas on searching by order total payment amount due, that would be really helpful as well.  We sometimes have a check show up with just a dollar amount and a different name than the actual business name.  It takes quite a while to dig and find some of these.  Would be great to search by total.

Thank you all for a great Open Source accounting program!  Dumping QB was a great feeling this year.

jeskremer's Website

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 548

Re: Date Range for Search

Preferences -> Transaction days will increase the search range.

rafat's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,156

Re: Date Range for Search

Identify the inquiry page to display and then cull out the necessary fields and the computations needed and make a generic SQL SELECT query and execute it in any MySQL client and then make a php script for it.

apmuthu's Website