I am using QB Basic 2005 for some very simple book keeping for my rental properties. I use classes to separate individual properties, and I use a notation in the memo field to distinguish individual units within a property (HR #01, HR #2, ... at the beginning of the memo field). My goal is to be able to get a P&L filtered by property (class) to see the entire property performance, and then to filter by unit (memo notation)to see what is going on with each individual unit.
I was using statements for billing rents earlier and then changed to using invoices in the middle of 2008. Both have my "HR #??" kind of notation in the memo field. I recently tried to do a Profit and Loss report on 2008 filtered on the memo field and to my surprise nothing billed using a statement shows up in the report, but everything using invoices is there just fine.
I went back and did a quick report of my accounts receivable filtered by the memo field and everything is there perfectly. If I do a quick report on the rental income account then the statements disappear. If I don't filter then they are all there and the memo on the quick report shows my memo notation perfectly.
What is going on here? Is there any way to fix this? Is this the behavior I would see on the 2009 version of QB?
Thanks for any help you can give me. Jim Shipman