Home → Investments →

Assigning Security Lots

• Edit

John Hetherington

05 Oct, 2023 10:00 AM

I have one security that is giving a message "You have allocated an incorrect number of shares" when attempting to match sells to buys, even though the information displayed indicates that the correct number has been selected. Also, if I view the Portfolio for this security, it indicates that the cost basis is zero, and if I then click on the security line in Portfolio, the securities detail also shows the cost basis to be zero. If, in the Securities Detail, I then select and open another security, and then return to the problem one, it correctly shows the cost basis.
I am not having this issue with any other securities.

1. 1 Posted by Stuart Beesley ... on 05 Oct, 2023 10:14 AM

   

   Step 1. Install/run toolbox extension. Does it pop up any warnings?

   • Edit

2. 2 Posted by johnhet on 05 Oct, 2023 11:35 AM

   

   Only indicates a few potential duplicate securities, not including the
   problem stock though.

   • Edit

3. 3 Posted by Stuart Beesley ... on 05 Oct, 2023 12:37 PM

   

   Ok. I would use toolbox to reset / wipe the lot matching on that security and then match the lots again from scratch.

   • Edit

4. 4 Posted by johnhet on 05 Oct, 2023 12:54 PM

   

   I tried that - it did not detect any mis-matched records to reset. If I
   look at the DIAG Show Open Share Lots, it reports that the cost basis is
   invalid as there are mis-matched buy/sells.

   • Edit

5. 5 Posted by Stuart Beesley ... on 05 Oct, 2023 02:33 PM

   

   Use the option to change it to avg cost. Say yes to wipe lots. Then use the option to change back to lot control. Then manually match the records.

   • Edit

6. 6 Posted by johnhet on 05 Oct, 2023 11:28 PM

   

   Thank you very much Stuart, this solved the problem.

   • Edit

7. 7 Posted by Stuart Beesley ... on 06 Oct, 2023 06:23 AM

   

   Toolbox 🧰 +1 😃

   • Edit

8. Ethan closed this discussion on 08 Oct, 2023 02:51 AM.