Bushwack
12-06-2003, 10:55 PM
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.
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.