[freeside] Billing problems after upgrade

[ivan]

http://www.sisd.com/freeside/list-archive/msg04365.html

On Thu, Jan 27, 2005 at 01:58:16AM -0600, Nicholas Moline wrote:
> Hello,
> 
> I have been using Freeside for some time.  I have recently upgraded to 
> 1.5.0pre6 in hopes of utilizing some of the new features, including the 
> self service modules, so that my customers can log in and pay their 
> bills directly, and the postscript invoicing to allow more styling in my 
>  invoices.
> 
> I upgraded my 1.4.1 to 1.5.0pre6 using the instructions given in the 
> documentation and it "seemed" at least to be a success.  The new 
> reporting options were amazing and after some slight tweaking I had a 
> decent invoice template that I was able to view all my existing invoices in.
> 
> Then over a month went by and I started getting comments submitted from 
> my more reliable customers "I haven't gotten a bill from you lately, is 
> something wrong?"
> 
> When I checked the customer I found, that while no invoice was 
> generated, their next bill date and last bill dates had been incremented 
> as if there was a new bill.
> 
> I started looking, and it seems that all my customers have had this 
> problem happen to them, any bill that was automatic, simply marked the 
> last bill date and next bill date and did not actually generate an invoice.
> 
> I tried editing the dates on a package back a month and running 
> freeside-daily -d '12/27/04' -v [user] [custnum] and I got the following 
> results:
> 
> bill customer 26 at /usr/local/share/perl/5.8.4/FS/cust_main.pm line 1120.
>   bill package 80 at /usr/local/share/perl/5.8.4/FS/cust_main.pm line 1159.
>     bill recur at /usr/local/share/perl/5.8.4/FS/cust_main.pm line 1195.
>   package 80 modified; updating
> Argument "" isn't numeric in sprintf at 
> /usr/local/share/perl/5.8.4/FS/cust_main.pm line 1250.
>   bill package 81 at /usr/local/share/perl/5.8.4/FS/cust_main.pm line 1159.
> collect customer 26: balance 0.00 at 
> /usr/local/share/perl/5.8.4/FS/cust_main.pm line 1528.
> 
> 
> Now line 1250 of cust_main.pm simply reads:
>        $recur = sprintf( "%.2f", $recur );
> 
> Now $recur is defined, otherwise the
>     warn "\$recur is undefined" unless defined($recur);
> 
> would have given me a warning, which it didn't several lines earlier. 
> I'm a bit confused as to why the recurring fee is coming up "" instead 
> of as what the fee that should be charged.
> 
> I should note it seems setup fees are working ok, at least from the 
> perspective that if I do a "one time charge" on a customer, the bill 
> does generate successfully with the charges on them, so this problem, 
> whatever it is seems to only be in the recurring fee, and I'm not really 
> sure why.  The recurring fees always worked fine before the upgrade, and 
> I don't use any complicated referring fees, just flat rate anniversary 
> billing.
> 
> To answer the questions in the checklist of REQUIRED information for 
> posting a request for information:
> Exact Version: 1.5.0pre6
> I use HTML::Mason, which was installed by dpkg on a debian machine and 
> is running version 1.26-1 according to dpkg at current
> 
> All of the required perl modules are installed and working, perl is 
> version 5.8.4 as noted in the errors.  PostgeSQL was also installed by 
> dpkg on debian and is currently 7.4.6-6
> 
> The OS is Debian GNU Linux, Sarge distribution
> libdbi-perl is version 1.46-5 and libdbd-pg-perl is 1.32-2
> 
> As this problem is not taking place in apache, there really isn't any 
> applicable portion of the error.log to post here.  This problem mis 
> taking place in the freeside-daily script, though I can confirm that if 
> I set a date back and attempt to run the "Bill Now" link through apache, 
> it has the same effect.
> 
> Any help you can provide me on this matter would be greatly appreciated.

-- 
_ivan