<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Sreenivas,<br>
<br>
That'll be great!<br>
<br>
The requirement we're working to meet is as follows.<br>
<br>
An order comes in for a hosting account, multiple domain names, a
payment gateway, and a SSL certificate.<br>
<br>
These items may be entered by a sales rep or an operator, whose time is
precious, thus they need the quickest mechanism possible to enter these
items.<br>
<br>
Each item is on its own recurring schedule, for example:<br>
- Hosting is monthly<br>
- Domain names are annual, or bi annual<br>
- SSL is annual<br>
- Payment gateway is annual<br>
<br>
Some of these items are included for free in the first cycle, e.g.
domain name free for first year of service or first month of hosting is
free.<br>
<br>
We achieve this be entering recurring properties against each line item.<br>
<br>
For the record, we capture the following attributes for recurring items:<br>
- Product (lookup to Product database)<br>
- Price (the amount to be charged on each anniversary)<br>
- First payment free (yes/no)<br>
- Extra details (text field that holds the descriptor of the recurring
product, e.g. domain name, hosting account name, ssl cert domain, etc)<br>
- Status (active [paid], expired, unpaid, etc)<br>
- Next payment due date (calculated)<br>
- Cycle (monthly, quarterly, annual, bi-annual, etc)<br>
<br>
When these items arrive at their anniversary date, a single invoice is
produced with all of the Accounts due recurring products on it. We do
this in the cron job.<br>
<br>
I like the idea of this being raised on a sales order. In our case,
we'd have to capture the recurring details for each product on each
line item.<br>
<br>
We'd also have to provide a related list on the Accounts screen to show
all recurring products for an Account, as we've found that customers
purchase many of these items over time, and we need to be able to
access all of them in a single place in summary form. (hence why we
put this on the accounts screen in our case)<br>
<br>
We are yet to build a recurring products module, but we are planning on
doing this. Again, this is to allow us to see the record of all
recurring products in a single screen so that we can
audit/manage/review all "live revenue" products through a single
screen. It would be impractical for us to scan through sales orders,
or a related list on each Account to do this. When we build the
recurring products module, it might negate the need to enter these on a
Sales Order, as we could do the Additions via the Recurring Products
module.<br>
<br>
<br>
<br>
Thanks,<br>
Brett<br>
Phone 0404 067 421<br>
<br>
<table border="0" cellpadding="2" cellspacing="2">
<tbody>
<tr>
<td valign="top"><a href="http://www.roarz.com/bretts-blog"><img
alt="" src="cid:part1.02090008.03070207@roarz.com" border="0"
height="68" width="45"></a><br>
</td>
<td valign="top"><a href="http://www.roarz.com/email"><img alt=""
src="cid:part2.02000802.08030002@roarz.com" border="0" height="67"
width="154"></a><br>
</td>
<td valign="top"><small><a href="http://www.roarz.com/email">www.roarz.com</a> Phone:
1300 885 125 Fax: 07 3009 0648 ABN: 69 113 777 594 <br>
<a href="http://www.roarz.com/capalaba">Capalaba Centre</a>:
Suite 2A, 26 Redland Bay Road Capalaba Qld 4157<br>
<a href="http://www.roarz.com/logancity">Logan City Centre</a>:
Suite 2A, 26 Redland Bay Road Capalaba Qld 4157<br>
<a href="http://www.roarz.com/vgc">Gold Coast Centre</a>: Level
9, 12-13 Marine Parade Southport Qld 4215<br>
<i>ROARZ will help you get your website up to date and keep it
that way.</i><br>
</small></td>
</tr>
</tbody>
</table>
<br>
<br>
Sreenivas Kanumuru wrote:
<blockquote
id="mid_370368f40811110540m4d5fbc83l123d4eb9079e2965_mail_gmail_com"
cite="mid:370368f40811110540m4d5fbc83l123d4eb9079e2965@mail.gmail.com"
type="cite">Hi,<br>
<br>
We intend to support Recurring invoices capability in 5.1. We plan to
use an approach similar to the one taken by Joe. i.e., Use SalesOrder
as a template and add a section to configure the recurring properties
such as start period, end period and the frequency. When the recurring
invoice is created by the system, the status will be set to 'Created'
and an email alert can be sent to the owner. The owner can then change
the status to 'Approved' <br>
<br>
Hope this approach fits the need for most clients. Please let us know
your feedback.<br>
<br>
-Sreenivas (vtiger team)<br>
<br>
<br>
<br>
<br>
<br>
<div class="gmail_quote">On Tue, Nov 11, 2008 at 1:16 PM, Joe Bordes <span
dir="ltr"><<a moz-do-not-send="true" href="mailto:joe@tsolucio.com">joe@tsolucio.com</a>></span>
wrote:<br>
<blockquote id="StationeryCiteGenerated_1" class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br>
<br>
We have this working using the SO as a template.<br>
<br>
<a moz-do-not-send="true"
href="http://vtiger-spain.com/wiki/doku.php?id=recurringbilling"
target="_blank">http://vtiger-spain.com/wiki/doku.php?id=recurringbilling</a><br>
<br>
Joe<br>
TSolucio<br>
<br>
quentusrex escribió:<br>
<div>
<div class="Wj3C7c">> Is there work already being done on the
Recurring Revenue feature? If<br>
> not has the feature already been designed, just not implemented?
If not,<br>
> who should I talk to about this feature? I want to get this feature<br>
> implemented quickly and I'm willing to do all of the work if I can
get<br>
> some help on the proper vtiger way to implement the feature.<br>
><br>
> I'd like something that would run as a cron job that would check
every<br>
> day to see all of the sales orders to see if they were marked as<br>
> 'recurring' if so then check to see when the last invoice was
generated.<br>
> If the last invoice was more than a month ago, then generate an
invoice,<br>
> that needs to be approved by the sales person. Then the sales
person<br>
> approves the invoice, and sends it out.<br>
><br>
> -William<br>
><br>
> _______________________________________________<br>
> Reach hundreds of potential candidates - <a moz-do-not-send="true"
href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a><br>
><br>
><br>
<br>
_______________________________________________<br>
Reach hundreds of potential candidates - <a moz-do-not-send="true"
href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a><br>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Reach hundreds of potential candidates - <a class="moz-txt-link-freetext" href="http://jobs.vtiger.com">http://jobs.vtiger.com</a> </pre>
</blockquote>
<br>
</body>
</html>