[freeside] Billing + Freeside Bill Script

[Brian Walters]

Collin if you are still having this problem let me know. We've modified our
script a little and now bill folks by 1st of Month billing. Basically if we
activate them on the first 2 days of the month then they pay for that month,
otherwise a bill is generated with today's invoice date and the first of
next month as the beginning date. To take things a step further though, I
modifed things so that the setup date is recorded correctly. This makes it
real easy to keep track of when a customer was actually sarted but also
allow for routine monthly billing.

Ivan, I will try to clean up our code and get a patch to you with this and
many other things(texas tax law, DSL circuit info, credit card collection
link, pdf email bills) just as soon as I can get it caught up the current
CVS and have time to make a real patch.

Brian Walters                                       
-----------------------------------------------------------------------
www.MyLinuxISP.com                         A Friendly ISP for ALL Users




> -----Original Message-----
> From: Colin [mailto:colinc at terrigal.net.au]
> Sent: Monday, June 26, 2000 7:16 PM
> To: ivan-freeside at sisd.com
> Subject: Re: [freeside] Billing + Freeside Bill Script
>
>
>
>
> ivan wrote:
>
> > On Tue, Jun 27, 2000 at 09:49:34AM +1000, Colin wrote:
> > >
> > >
> > > ivan wrote:
> > >
> > > > On Wed, Jun 21, 2000 at 03:13:36PM +1200, Colin wrote:
> > > > > Hello, sorry for being a nusiance.
> > > > >
> > > > > I have a question regarding the billing of customers.
> Currently we bill
> > > > > all customers at the beginning of each month, so this
> means that the
> > > > > customer should receive an invoice several days before
> the beginning of
> > > > > the next month. It seems as though freeside does not
> allow customers to
> > > > > be bill before the date of the next bill.
> > > > > Eg, Clicking on 'Bill Now' does not create an invoice as
> the date for
> > > > > next bill is 01 July 2000.
> > > > > We also liked to bill every single customer at the same
> time, it seems
> > > > > as though this can be acheived by using the freeside-bill
> script in
> > > > > /bin. Again, does not seem to bill customers until the
> next bill date is
> > > > > matched, even if i specify the date in the command line.
> > > >
> > > > You can use the -d option of freeside-bill to run billing
> as if it's a
> > > > different date.  As per my previous message, Freeside does
> not currently
> > > > support pro-rating or 1st-of-the-month billing, only
> anniversery billing.
> > >
> > > I think you may have misinterpreted my question, we do not
> wish to implement
> > > pro-rating billing.
> > > We would like 1st of the month but we can simply changed all
> packages to the
> > > 1st of the month manually to do this so that anniversary
> billing is used.
> > >
> > > My question is whether we can bill/print the invoice before
> the actual billing
> > > date.
> > > Eg: If the next billing date is 07/01/2000, can we print the
> invoice prior to
> > > this date, say 06/26/2000, so that the customers can receive
> the invoice
> > > before the billing date.
> >
> > Again, you can use the -d option of freeside-bill to run billing as if
> > it's a different date.
> >
> > > At the moment it seems as though no customers get billed even
> if i specify the
> > > date prior to the billing date when running the billing
> script. It runs the
> > > script as though it is billing the customers but nothing is
> entered in mysql,
> > > i've checked all the tables.
> > > It'll only add the data if the date i specify is after the
> billing date, as in
> > > the above example 07/02/2000 works fine.
> >
> > What's the question then?
> >
> > --
> > meow
> > _ivan
>
> yes, i know -d can run the billing script with a different date,
> but it ONLY seems
> to work with dates after the next billing date, not with dates before.
> EG:
>     next billing date = 07/01/2000  (this date is already stored
> in the database)
>     i want to bill prior to above date, say 06/26/2000
>     i run 'freeside-bill -c -d 2000-06-26 freeside'
>     It seems to run through and bill customers, I go to mysql and
> check the tables,
> nothing is added in cust_bill, cust_bill_pkg, cust_pay_batch, and
> the billing date
> is not changed to the next month (08/01/2000) for packages
>     IF i run 'freeside-bill -c -d 2000-07-02 freeside' it works
> fine, but this date
> is after the billing date which is not what we want to do.
>
> We want to bill customers prior to the next billing date, not after.
>
>