Fixing an investment lot

I have an account where the total of an individual holdings lot quantities do not add up to the total quantity for that holding in the account. Account Holding Qty = 57.373 the lot qty = 42.735. I have isolated the date when this occurs. it happened on Aug 13, 2020. I do not see any transactions for this holding in this account.

How do I adjust the Lot qty on this date to get it back up to the correct qty of 57.373? The register is correct from when the lot was opened on 11/30/2016 until 8/13/2020.

As a side note the rebuild investment lots routine does not complete. It says 'the resulting value is too big. Please Enter it as more than one transaction".

Comments

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    First I would go to Edit > Preferences > Investment transactions and make sure the Show Hidden Transactions box is checked. 

    Then go back to the account and look for s Placeholder in the problem date. Resolving the Placeholder may fix your problem.
    QWin Premier subscription
  • Scotty Van
    Scotty Van Member
    Thanks for your response Show hidden transactions is already checked. There is no placeholder transaction that I can see. I wish there was a way to select an investment lot in an account and see all the transactions for some date range.
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Perhaps there is a transaction in another account that due to some data corruption is affecting this holding.

    You might run an investing transaction report for all accounts and all securities near the problem date and see if there are other transactions on the same date. 

    If so, maybe deleting and re-entering those transactions will fix it.

    As always, back up your data file before changing historical data.
    QWin Premier subscription
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    I am concerned that your "Rebuild Lots" on the validation attempt failed.  That might indicate irreparable corruption.  If this discrepancy just recently appeared, you might be best to restore from a backup. 

    Is this a security held only in this one account?
    This is one lot of correctly 42.735 shares.  How many different lots are there for this security in this account? 
    Is this a security with a lot of trading in and out?   
    I am trying to get a sense of how complex (or simple) your circumstances are with this security.


Sign In or Register to comment.