You are right, FN uses about 6 digits to store prices. For instance, FN can use a price with 4 decimal places if the price is $99.9999 or under. But for a price with 3 digits before the decimal, FN only saves the first 3 digits after the decimal: $150.123. Since FN uses at most four digits after the decimal, you would also have problems entering a price of $1.123456. FN would record it as $1.2345.
Sometimes it will look like you were able to enter the entire price. So it is important to tab after entering a price with many digits. After you tab you will see the price that FN has saved.
In both cases, the solution is simple:
- Enter the price normally, making note of any amount that is dropped. In your example, you would enter $150.123.
- Calculate the missing amount. In you example it is 2,000 shares x $0.0004 = $0.80.
- Enter a credit transaction in Unrealized Gains and losses for that amount. For instance:
- CR 12/31/03
- Payee/Payor: Revalue fractional amount
- Account: [name of stock's account]
- Memo: 2,000 sh @ $.0004
- Credit: .80
The balance on the Asset and Liability Info screen and on balance sheets will now be correct, and you have a good audit trail. The change will show correctly Investment reports will still show the wrong amount, since they calculate current value as shares x price. You can stop this calculation so that your investment reports match your balance sheet:
- Select Investments | Investment and Account Options.
- Remove the check mark from Calculate Balances for Investment Accounts.
See the topic "Price per Unit" Rounding for a related discussion about very large prices.
- David
FNI Support
[This message has been edited by David (edited 09-07-2007).]