[freeside] Freeside 1.4.0 pre 5 - billing output

[ivan]

Thanks.  Change the setup field from NULL to the numeral 0 in your
database to fix the problem with this particular package definition.

On Mon, Nov 05, 2001 at 07:34:31PM -0500, Timothy M. Butkiewicz wrote:
> 
> Here is the result of:
> 
>   SELECT setup FROM part_pkg WHERE pkgpart = 50
> 
> +-------+
> | setup |
> +-------+
> | NULL  |
> +-------+
> 1 row in set (0.00 sec)
> 
> 
> -----Original Message-----
> From: ivan [mailto:ivan at 420.am]
> Sent: Monday, November 05, 2001 7:13 PM
> To: Timothy M. Butkiewicz
> Subject: Re: [freeside] Freeside 1.4.0 pre 5 - billing output
> 
> 
> SEND THE RESULT OF:
> 
>   SELECT setup FROM part_pkg WHERE pkgpart = 50
> 
> The "error reval-ing part_pkg->setup" 
> error does occur because "the customer was active, had been billed in the
> past, but for whatever reason the setup date was never added to the field
> cust_pkg.setup".
> 
> On Mon, Nov 05, 2001 at 07:09:13PM -0500, Timothy M. Butkiewicz wrote:
> > 
> > Sorry for the confusion. Forget the setup fee.
> > 
> > What happened was the customer was entered ( in 1.3.1).
> > Then they added several packages.
> > Then freeside-bill  kicked it (It runs nightly as a cron)
> > The customer received a bill, but a date was not placed in cust_pkg.setup,
> > it was just left null.
> > 
> > So then we brought up 1.4pre5
> > So when I ran freeside-bill and received:
> > > > Error billing,  customer #110:Error reval-ing part_pkg->setup pkgpart
> > 50:
> > 
> > It was because the customer was active, had been billed in the past, but
> for
> > whatever reason the setup date was never added to the field cust_pkg.setup
> > (which to my understanding should have happened automagically.)
> > 
> > All in all I fixed it.
> > 
> > 
> > +----------------------------
> > Timothy M. Butkiewicz
> >  Director of Office Technologies
> >  cyberM.I.N.D.
> >  877.373.6680 x 20
> >  www.cybermind-usa.com
> >  www.cybermind-usa.net
> >  
> > 
> > -----Original Message-----
> > From: ivan [mailto:ivan at 420.am]
> > Sent: Monday, November 05, 2001 6:54 PM
> > To: ivan-freeside at sisd.com
> > Subject: Re: [freeside] Freeside 1.4.0 pre 5 - billing output
> > 
> > 
> > On Mon, Nov 05, 2001 at 06:51:39PM -0500, Timothy M. Butkiewicz wrote:
> > > 
> > > I found that this cust did not have a setup date, but had been billed.
> > 
> > Not for the setup fee they weren't.  If you're going to ask for help,
> > please don't refuse to answer questions about your installation.
> > That doesn't help anyone.
> > 
> > Would you do:
> >   
> >   SELECT setup FROM part_pkg WHERE pkgpart = 50
> > 
> > and send the exact results, please?
> > 
> > 
> > > Setup
> > > date wan NULL.
> > > I added the setup date and that solved the problem.
> > > 
> > > +----------------------------
> > > Timothy M. Butkiewicz
> > >  Director of Office Technologies
> > >  cyberM.I.N.D.
> > >  877.373.6680 x 20
> > >  www.cybermind-usa.com
> > >  www.cybermind-usa.net
> > >  
> > > 
> > > -----Original Message-----
> > > From: ivan [mailto:ivan at 420.am]
> > > Sent: Monday, November 05, 2001 6:55 AM
> > > To: ivan-freeside at sisd.com
> > > Subject: Re: [freeside] Freeside 1.4.0 pre 5 - billing output
> > > 
> > > 
> > > On Sun, Nov 04, 2001 at 02:09:27PM -0600, Timothy M. Butkiewicz wrote:
> > > > 
> > > > Recently upgraded to 1.4pre5
> > > > 
> > > > Apache 1.3.19, MySQL
> > > > 
> > > > During the upgrade I halted the freeside-bill cron job (I had created
> > for
> > > 1.3)
> > > > 
> > > > Upon successfully getting 1.4pre5 up and running I ran freeside-bill
> and
> > 
> > > > received the following output:
> > > > 
> > > > Name "main::opt_p" used only once: possible typo at
> > /usr/bin/freeside-bill
> > > line 
> > > > 63.
> > > 
> > > I wouldn't worry about this.
> > > 
> > > > 10355 at /usr/lib/perl5/site_perl/5.6.0/FS/cust_main.pm line 1005.
> > > 
> > > Or this.
> > > 
> > > > Error billing,  customer #110:Error reval-ing part_pkg->setup pkgpart
> > 50:
> > > 
> > > > at /usr/bin/freeside-bill line 60.
> > > 
> > > You should be worried about this; the customer was not charged the setup
> > > fee.  Whether or not *I* should worry about it depends on what's in your
> > > pacakge definition.  :)
> > > 
> > > Would you do:
> > > 
> > >   SELECT setup FROM part_pkg WHERE pkgpart = 50
> > > 
> > > and send the results, please?
> > > 
> > > > Should I be worried about this?
> > > > 
> > > > I reviewed cust#110 and found no setup date(it was NULL), but had a
> next
> > 
> > > > billing date of 11/22. I added the setup date manually into the table
> > > record.
> > > > 
> > > > Upon fixing cust#110, I re-rean freeside-bill and the output message
> was
> > 
> > > > reduced to:
> > > > 
> > > > Name "main::opt_p" used only once: possible typo at
> > /usr/bin/freeside-bill
> > > line 
> > > > 63.
> > > 
> > > -- 
> > > _ivan
> > 
> > -- 
> > _ivan
> 
> -- 
> _ivan

-- 
_ivan