Can't change rate w/ memorized transactions

[Bushwack]

I can't find an answer to what I think should be an easy problem to solve. Help...please! Goal: I am trying to adjust a price within an item list to apply to all memorized transactions within a given month.

Using QB Pro 2002, I have 12 separate Item Lists that I use corresponding to each month of the year (I'm using QBooks for property management). Each item list has the same dollar amount. I have 62 clients that are billed monthly (set up as memorized transactions). For example, Item List "January 2003" was invoiced to all 62 clients at a rate of $1,200 for the month of January. The following month, Item List "February 2003" was invoiced to all clients at a rate of $1,200 for the month of February ...and so on throughout 2003 (fyi, the description of each transaction changes per month which is why twelve items lists are needed. Also, each Item list is on an annual schedule...if that makes a difference to solving my problem).

Now, effective January 2004 each client will be billed $1,275/month. So I went into each 12 of the Item Lists (i.e. January, February, March, etc.) and changed the rate to $1,275. I expected that each memorized transaction (62 for each month in 2004) would update to the new rate. But that did not happen. Nevertheless, I went ahead and printed out a few test invoices for my January billing, hoping the rate increase would reflect on the invoices. But THAT didn't happen either (the old rate remained).

So what am I doing wrong? I thought by creating 12 Item Lists, I would be able to adjust the rate for each month of the year. Currently, it is looking like I will have to manually adjust 750+ memorized transactions (ugh!).

Any suggestions/advice would be appreciated.

[RCollier]

Actually, you are probably doing absolutely nothing wrong. I think the "failing" is in the memorized transaction itself. I've worked with memorized transactions for a short period of time, but only doing general JE's.

To correct your situation, I believe you are going to have to delete the memorized transaction(s) and then redo it/them at the corrected amount. I have not been able to find a way to adjust the amount of a memorized transaction once its been memorized.

[brecor]

Russ is correct. There is no way to globally change memorized invoices for item changes. You either have to go into the memorized invoice and change the item price or delete & recreate/re-memorize the invoice.

[Bushwack]

Thanks for the replies.

On a similar note, I'm looking to upgrade to QB 2004 Pro or possibly Premier 2004. On Intuit's comprison chart, it states that Premier will allow me to "set per item price levels". If not for this option, Pro 2004 would suit me fine.

Going back to my original post, will this feature in Premier be what I'm looking for to make adjustments in price (within an item list to apply to all memorized transactions within a given month). .Or am I still left doing manual adjustments?

Thanks ya'll! This forum has been a gift that keeps on giving.

[brecor]

I believe once you memorize a transaction, invoice in this case, it locks the price information at the time it was memorized and will not adjust it for item pricing changes. Hopefully in the future they will add a global pricing change enhancement.