[freeside] Billing + Freeside Bill Script

[ivan]

On Thu, Jul 20, 2000 at 10:44:22AM -0500, Brian Walters wrote:
> 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.

Sounds good.  Keep me informed as to your timeframe - i think it's time
for a 1.2.4 release soon.

> 
> 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.
> >
> >
> 

-- 
meow
_ivan