ledgersmb
Unexpected Date range in search filters
Version
1.12.9
What browsers are you seeing the problem on?
This problem isn't browser related
What happened?
I want to see last year's transactions, and find the date selectors cumbersome, so wondered if this would work:
I selected the start date of January 1 2024, and a period of Year. Now, the point is not that this isn't the right way to do it (I've figured out that I have to leave the date blank, just select the year in the dropdown after Period, and then click the Year radio button), but that the results are … strange.
It gives me this result:
… plus many more lines
Note, that in the header there's a From date but no To Date (and the capitalization should be consistent!). Now if I click on any of the COA account numbers on that report, I get:
I'm fairly sure that the first report has actually included everything from the date I specified to either the current date, or the last entry in the database (in my case those would be the same, so I can't tell), but the second report has thrown in a spurious end date prior to the start date! And so, there are never any results.
What should have happened?
I'd hope that the first page would simply stop me choosing inconsistent options, but the two reports should always be using the same date range!
I notice that most other pages have a period selection like this (from Income Statement):
On this page, it's impossible to give a start date but select a 'Period'
@auspex thanks for your reports. please keep up the good work! I've been working to release v1.13.0 beta1, which took considerably more time than expected. Also, I'm working on fixing a major bug in inventory tracking for Cost Of Goods Sold calculation. That too is taking quite a bit of time. I'll get to your reports when these two are completed.
Other screens with the same problem:
- Accounts Receivable > Search
- Accounts Payable > Search
- Accounts Receivable > Reports > Outstanding
- Accounts Payable > Reports > Outstanding
- Order Entry > Reports > Sales Orders
- Order Entry > Reports > Purchase Orders
- Shipping > Ship
- Shipping > Receive
- Quotations > Reports > Quotations
- Quotations > Reports > RFQs
- General Journal > Search
- Goods & Services > Reports > COGS & Inventory
- Goods & Services > Reports > Inventory Activity
- Timecards > Search
- Taxforms > Reports