Open Lot's Report

[rdg]

Recently GE underwent a reverse 1 for 8 share split.
Prior to the split (August 2) the Open Lots report worked fine.
After I enter the split, the report only displays the share price, all other information displays as N/A.
If I delete the split transaction the report will revert to the correct info (pre split).

Any ideas or suggestions?

I have previously sold some shares in two transactions:
The first transaction was a as FIFO sale, the second transaction was by Specified lots.

[Mark]

Hi rdg,

What accounting method are you using to display the Open Lots report? If you're using "Specified Lots" or "Assigned Investment Property" with the investment's property set to "Specified Lots" make sure you've specified all the sold lots. Also, from within the report with some N/A values, look at "Help / Logs / Report Calculations..." for an explanation of the N/A values.

[rdg]

Thanks Mark;
I had originally assigned FIFO on my first sale, my second transaction was switched to specified lots. When I went back and specified the FIFO lots in the first sale the report was correct.
What I can't figure out why the split transaction screwed up the report as it was fine up until that date.

[Mark]

Hi rdg,

I'm not following on how you're changing accounting methods. You can't assign an accounting method to a transaction. The accounting method is a property of the investment, and applies to all your transactions in that investment. Maybe you're trying to say that you have "Specific Lots" as the investment's accounting method, but when you specified lots you used the FIFO button?

If you look in the report log, it will explain any N/A figures. Are you still having a problem? What does the report log say?

[rdg]

Sorry for confusion:
I had originally set the "accounting method" as FIFO and was used in the first sale.
The report was fine.
For my second transaction, I changed the accounting method in the Investment Properties to specified lots and identified the individual lots for that sale.
The report was still generating with all the data showing after this sale.

Subsequently, I entered the reverse split and all the information except share price showed as N/A.

I went back and edited my original sale transaction and identified my FIFO lots as "specified lots" sold. The report is now fine and all data displays correctly.

I just couldn't figure why the report would generate "normally" after the two sale transactions but once I entered the split it became N/A. The criteria of the report was set to "specified lots" in all cases.

[Mark]

Hi rdg,

I wouldn’t expect the report to work before you specified all of the lots. This is a requirement when using the specified lot accounting method.