[freeside] Billing + Freeside Bill Script

[ivan]

On Tue, Jun 27, 2000 at 10:16:06AM +1000, Colin wrote:
> 
> 
> 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

That's correct, since you've asked the billing to run as if it's 6/26.

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

You don't actually have to wait until 7/2 to run that command.

> We want to bill customers prior to the next billing date, not after.

You can run `freeside-bill -c -d 2000-07-02 freeside' when the real date
is 6/26.

-- 
meow
_ivan