Search Again: Re: Apply Credit to all users? From: Shawn Hogan Date: Friday, February 5, 1999 Time: 5:48:19 pm System Administrator wrote: >Is there an easy way to apply a day credit to ALL user accounts? Manually >having to create and close a 1 day credit invoice for each account seems >rather cumbersome.... Any tips? Thanks! Well, you could use the replace function to do it... 1. Go to Scripts and select Find All (or do a find so that the accounts you want to do it to are in your found set). 2. Put the cursor in the Expiration Date field. 3. Go to Script and select Replace. 4. Select 'Replace with calculated result' 5. Set the calculation to: "Expiration Date + 1" (without quotes) 6. Hit replace If you do that, you are going to need to rebuild the indexes when you are done also (in maintenance). - Shawn ------------------------------- Shawn D. Hogan President, Data Point Solutions http://www.data-point.com (619) 452-3696 ICQ: 8319647

Messages In This Thread: Apply Credit to all users? by System Administrator on Feb 5, 1999 at 5:38:08 pm Re: Apply Credit to all users? by Shawn Hogan on Feb 5, 1999 at 5:48:19 pm