[freeside-users] Time of "next bill date"

Gerald V. Livingston II gerald.freeside at sysmatrix.net
Sun Sep 10 04:35:44 PDT 2006


Is there a way to reset all of the "time" parts of the "Next bill date" to
"00:00:01"??

I have discovered while moving customers from our legacy system that the
"time" is set to whatever time one sets the account up *OR* manually clicks
the "bill now" (to account for credits or past due accounts being imported
and generate invoices from the new system).

I have also discovered that "freeside-daily" does *NOT* ignore the time
part of the date field. 

Example: (freeside-daily set in cron to run at 09:00)

Create new customer at 15:00 on August 9th. Bill for the first month of
service and enter the payment to generate an initial invoice showing
account activation and payment. Next billing date field gets set to
September 9th at 15:00.

freeside-daily runs at 09:00 on September 9th. The customer listed above is
NOT billed because it is not yet 09/09/2006 15:00:00 -0500 (CDT). 

freeside-daily runs at 09:00 on September 10th and the above account is now
billed -- but now the "next billing date" field is set to 10/10/2006
because the account was actually billed on the 10th this time.

If it was a new account near the end of the billing list the actual field
may get set to something like "10/10/2006 09:07:03 -0500 (CDT)"

Now, let's say in October a few accounts have been deleted that would have
fallen earlier in the daily run. So, on 10/10/2006 freeside-daily passes
this account at 09:06:59 -- once again it gets skipped over, not billed
until the following day, and its billing day gets pushed back again, now to
the 11th of each month.

If the time portion of that field could be defaulted to always be 00:00:01
*OR* if freeside-daily would simply ignore the time portion of that field
the problem would be solved.

Gerald


More information about the freeside-users mailing list