›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Migration to v3 Issues with Transactions

xcerikxcerik
in Migration
I am trying a migration to v3, but I had some problems with values vs formulas in the Transactions sheet. I pasted formulas from the Source-Demo, and then all seemed to be working correctly. Later, I realized I had negative cash balances on my accounts, due to the missing v2.4 auto-dividends. What I can't figure out is as I add rows for the dividends to the Source Transactions page, I am getting '#VALUE' in the calculated columns (TotalAmnt,CashImpact,CashBalance, and QtyChange). I'm not sure if these columns are needed for the Report calculations, but I would like them to display the correct values.
Any insight into these issues would be appreciated.

Comments

  • VidasMatelisVidasMatelis
    You need all values in Transactions to be visible and not errors, otherwise you might encounter unexpected errors.
    As you already have problems with the workbook you are working, I would recommend start with new downloaded v3 workbook.
    First populate v3 all other worksheets (account, symbols, etc), but transactions. Save this workbook and make a copy if you need to
    Go to your old transactions v2 file and remove all filters. Select all columns you can edit (do not select columns with formulas) choose copy and then paste "as values" (right mouse click and choose Paste options "Values..") , to empty excel worksheet. Adjust column order as needed to match destination and then paste them into v3 worksheet transactions.
  • xcerikxcerik
    @VidasMatelis Thanks for the quick reply. I did as you suggested and all is good now. Paste as values was an important step that I had missed, so I appreciate the advice.
Sign In or Register to comment.