for your eyes only...

[dank]

In honor of the new resellers' forum, and equally due to my being somewhat bored and having had a need for something along these lines in the past, I put together a little program this evening. It's designed to calculate the amount credited on an annual hosting account that is changed to a new annual package (upgrade or downgrade) and the new amount due or refunded.

So, without further ado...

http://abledesign.com/fq.php

Should be pretty self-explanatory.

I started out with fields for old/new cost to reseller, but I couldn't think of any relevance to those in the calculations... If I've overlooked or mis-calculated anything, let me know. If people find it functional and useful, I'll post the source code.

Dan

[Bob]

Hi Dan,

I would think that this could be very useful to many, including myself. However I believe I have found at least one area that just dosen't compute ;)

Old Package Annual Date Dec 5, 2002 = $299.40 (Silver)
New Package Annual Date Oct 5, 2003 = $179.40 (Basic)

Calculation
10 Months actual use 10 X $24.95 = $249.50
$299.40 - $249.50 = $49.90 Credit to be applied to new Package

New Package $179.40 - Credit $49.90 = $129.50 Amount due with new Package.

Your tool results in
Amount credited on client's account: $248.54
Amount refunded with new package: -$69.14

Hope this helps,
Bob

- Computing these can be a bear, which is why I love matching dates :P -

[dank]

Ah, thanks for catching that. Looks like I flipped around the credits calculation. I thought I had that working right last night, so either I dreamed it (it was 3am) or I changed something after the fact...

Oh, as an additional explanation as to the reason behind this tool, when you upgrade or downgrade packages, the current date becomes the new billing date. That's fine when it's your own package and you just pay the difference, but I've never quite been sure how to handle it for clients. They've already paid in advance for a year, so I prefer not to hit them with another bill to extend an "additional" year down the road, but calculating the difference between packages on a discounted account had a lot of room for error. %)

Dan

[Bob]

Originally posted by dank:
Ah, thanks for catching that. Looks like I flipped around the credits calculation. I thought I had that working right last night, so either I dreamed it (it was 3am) or I changed something after the fact... Well 3 Am would explain that %)

I just checked it again and it appears to be doing the Right Thing TM :)

Originally posted by dank:
Oh, as an additional explanation as to the reason behind this tool, when you upgrade or downgrade packages, the current date becomes the new billing date. That's fine when it's your own package and you just pay the difference, but I've never quite been sure how to handle it for clients. They've already paid in advance for a year, so I prefer not to hit them with another bill to extend an "additional" year down the road, but calculating the difference between packages on a discounted account had a lot of room for error. %)

Dan Actually when you upgrade or downgrade an Annual Package the following applies (Regardless of whether Resold or not) "FutureQuest will pro-rate out the existing package, at the annual rate providing the new package is also going to be annual, and apply any credits to the newly upgraded package. The new annual package will be charged at the annual rate for a full year from the date of upgrade."

And I would find this to be a very useful tool myself ;)
-Bob

[dank]

Is that different than what I said? :\

Dan

[Bob]

On Review (The Instant Reply was put into effect as a result of the Red Flag being thrown) it would appear not to be different :BPG2:

;) Bob

[dank]

The Instant Reply
Is that Instant Replay or Instant Reply? I'm often guilty of the latter, myself. ;)

Dan
- inconclusive evidence

[Bob]

That was definitely the "Instant Reply" %)

-Bob

[Randall]

Looks like it could be helpful also for converting an IRM to a full package, or vice versa. You just have to factor in the conversion fees, which escape me at the moment.

Randall

[dank]

I know there's a $50 fee for changing the primary domain name on an account, but I'm not aware of any other conversion fees. Is that what you're referring to?

Dan

[Randall]

I know there's a $50 fee for changing the primary domain name on an account, but I'm not aware of any other conversion fees. Right, I've seen that figure for switching an IRM with the primary domain. But I vaguely remember that moving an IRM to its own account (or moving a full package into an IRM) also involves some costs.

One of the FQ elves will tell me if I'm hallucinating again. ;)

Randall

[Bob]

When changing an IR to a Full Package the only charge incurred is that of the new Full Package.

When changing a Full Package to an IR the only charge is that of the new IR Service Fee.

Now, if you are switching the Domain Name associated with the Full Package, whether the domain was already an IR or not yet on the FutureQuest Network, there is a $50.00 fee... and they are nightmares for us as many file and core changes are required...

Hope this clarifies ;)
-Bob

[Randall]

All right, I'll lay off the blueberry muffins for a while. They do strange things to my brain. %)

Randall

# Was that a white rabbit I just saw...? Nope, just another muffin

[Bob]

Originally posted by dank:
If people find it functional and useful, I'll post the source code.

Dan Hmmm... well... I find it useful...:QTthumb:

Please :sure:
-Bob

[dank]

Ok, I can take a hint. :) I figured I'd get a bit more feedback from others first...

http://abledesign.com/fq_source.php

That should do it for you. Pretty simple little script; it would be nice and short if not for the date dropdown setup I borrowed from my calendar program.

Dan

[Bob]

Whoo Hoo Deb gives early :gift: (http://www.aota.net/forums/showthread.php?postid=97386#post97386) and now Dan too! :stardanc:

Thanks Dan,
Bob

[dank]

I can't believe I didn't think of this earlier. He who brings the gifts...

Dliver

[Mandi]

I'm chiming in late, but thanks Dan :QTthumb:

[dank]

:)