Security not "currently held" and not in Net Worth Report BUT shows in Portfolio

Many thanks but, I'm using Quicken for Mac 5.17.1. I can't find a hide securities function nor a validate/repair function. Those functions were in old versions of Quicken for Mac but, I can't find them in the latest.

It is confusing. Here's a summary of the problem for one security:

- Securities list shows the CD as not currently held i.e., there is no green dot in the "Currently Held" column.

- The CD appears in the Net Worth Report only if the report is run for certain dates - the CD has been held continuously since 2012 but there have been a sell transaction and a buy transaction on the same day every year.

- The CD appears correctly in the "Portfolio" tab for the Account's register for all dates starting with the first buy transaction in 2012 [the portfolio tab shows prices and holdings of all securities in an investment account as at a given date as well as capital gains and performance].

I have other securities which are not "Currently Held" which do show correctly in the Net Worth Report.

I can't find anything material which would explain why some securities show correctly in the Net Worth Report and other don't.

I suspect this might have something to do with dates. I'm going to look for a pattern in dates and appearing in the Net Worth Report. I think the issue might be the order in which transactions appear. Most transactions pairs (like the buy-sell pair), are in reverse order on the given date. So, Quicken shows the buy happened before the sell. I have manually fixed many go those. Where I have done so, the security no longer appears in the Net Worth Report. I reckon this a bug which I will report somehow.

P.S., I am in Australia. We don't have "CDs". We have instruments called "Term Deposits" which are basically the same thing. We don't really buy or sell them. When they mature we can renew them. But, Quicken does not have those concepts so, I use "CDs" and enter buy-sell transaction pairs to emulate the renewal process.

> @lhossus said:
> You might try dating the sell of the old CD one day before the buy of the new CD.

Yes, of course, I should have thought of that. I changed dates on the sell transactions to one day before the buys. It worked. The Net Worth Report updated in real time showing the correct total.

I suspect part of the problem lies in data imported from Q2007. All transactions with the same date were entered in reverse order - i.e. buys before sell and transfers before interest receipts. I've been manually re-ordering those transactions but, clearly that's not fixed the way reports use the data. Transactions which I have entered since the import don't have the problem.

Many thanks for the solution.