How do I change "N/A" to a dollar amount?

JimDB

I deposited money into a brokerage account. Normally I then use the money to buy money market shares. This time I did not do that right away. After an update, Quicken entered a placeholder entry for the amount of my deposit. So then I made the entry for the purchase of the money market shares. After doing that, I noticed that instead of making a "0" entry under the cash amount column, it entered N/A. The placeholder entry was resolved, but I still have a cash balance for the amount of my deposit instead of "0". How do I change N/A to zero?

NotACPA

Since you've already made the correction to your records, there's nothing else to do but delete the placeholder, which will eliminate the N/A also.

JimDB

I did remove the placeholder, and it didn't eliminate the N/A.

NotACPA

Which suggests that there's another placeholder and another difference between the quantity of a position that Q is showing and what's being downloaded from your FI … because it's that discrepancy that causes Q to create the N/A.

JimDB

I don't see any other placeholders.

NotACPA

Then you might have a corrupted Q data file. Have you tried taking a backup and then Validating the file?

Jim_Harman

If you have already entered the missing transaction, there may be a Cash Balance Adjustment just before the transaction you entered. You should delete that too.

JimDB

I just ran validate and repair and it did not eliminate the N/A. There were no cash balance adjustments prior to the transaction, but I will do an adjustment to correct the cash balance. That seems to be the easiest way to correct this. Thank you for your help.