[freeside] Change Requirments on SS field

Jeff Garner Jeff.Garner at trw.com
Fri Dec 10 15:50:25 PST 1999


Thanks I got it :)

I think your program is going to work great!

Any plans in the future to add a browse invoices?

That would be a nice feature...

Thanks again!

----- Original Message -----
From: "ivan" <ivan at 420.am>
To: <ivan-freeside at sisd.com>
Sent: Friday, December 10, 1999 4:29 PM
Subject: Re: [freeside] Change Requirments on SS field


> You want to edit the `check' subroutine in FS/FS/cust_main.pm, and then
> reinstall the perl modules.  The section you want to edit is:
>
>   if ( $self->ss eq '' ) {
>     $self->ss('');
>   } else {
>     my $ss = $self->ss;
>     $ss =~ s/\D//g;
>     $ss =~ /^(\d{3})(\d{2})(\d{4})$/
>       or return "Illegal social security number: ". $self->ss;
>     $self->ss("$1-$2-$3");
>   }
>
> The
>   $ss =~ s/\D//g;
> command removes all non-numeric characters, so you will want to change or
> remove that, and the
>   $ss =~ /^(\d{3})(\d{2})(\d{4})$/
> regular expression will need to be rewritten, as will the assignment:
>   $self->ss("$1-$2-$3");
>
> On Fri, Dec 10, 1999 at 02:42:10PM -0700, Jeff Garner wrote:
> > I want to change the Social Security field to an Accound ID field...
> >
> > I only want to change the name on forms.  I was able to do this, but I
guess
> > the field is expecting numbers and not a word
> >
> > Any idea where I can change this requirment
> >
> > The cust_main database key ss looks like it will just take any character
> > upto 11 chars...
> >
> >
> > Thanks
> >
> >
> > ----- Original Message -----
> > From: "ivan" <ivan at 420.am>
> > To: <ivan-freeside at sisd.com>
> > Sent: Thursday, December 09, 1999 4:28 PM
> > Subject: Re: [freeside] Need more Options!!!
> >
> >
> > > This information is contained in the cust_bill table in the database.
> > >
> > > Freeside does not include any reporting tools, but you can, for
example,
> > > use MySQL and MyODBC to access the database from your favourite
ODBC-aware
> > > reporting tool.
> > >
> > > On Thu, Dec 09, 1999 at 04:20:22PM -0700, Jeff Garner wrote:
> > > > Thanks for the feedback
> > > > Is there a way I can have the billing email me the incoice or a
summary
> > of
> > > > all invoiced billed when it runs.
> > > >
> > > > Also is there a way I can have lists of invoiced by month or a total
> > > > incomming $$$ per month  and so on..
> > > >
> > > > Thanks
> > > >
> > > > ----- Original Message -----
> > > > From: "ivan" <ivan at 420.am>
> > > > To: <ivan-freeside at sisd.com>
> > > > Sent: Thursday, December 09, 1999 4:16 PM
> > > > Subject: Re: [freeside] Need more Options!!!
> > > >
> > > >
> > > > > On Wed, Dec 08, 1999 at 11:06:18PM -0700, Jeff Garner wrote:
> > > > > > You need a way to take back refunds I hit my refund button
twice..
> > =
> > > > > > oops..
> > > > >
> > > > > You can edit the database directly, in this case.  Remove the
refund
> > from
> > > > > cust_refund and adjust the customer's balance in cust_credit.
(You
> > may
> > > > > also want to remove the credit in cust_credit).
> > > > >
> > > > > Of course, if you've taken action on the refund, like refunding
> > charges on
> > > > > a credit card or cutting the customer a check, then you shouldn't
> > remove
> > > > > them from the database.
> > > > >
> > > > > > Also in the billing a pay my check option would be nice...
> > > > >
> > > > > Sure, it would be nice if you paid my check too.
> > > > >
> > > > > Use "Billing" for customers who wish to pay by check.
> > > > >
> > > > > > Also in the service type area how about some more basic types of
=
> > > > > > services  right now there is dialup, domain and domain e-mail
> > > > > > I would also like services for web page design, also mb of
trafic =
> > > > > > transfered..  mabey a generic option...
> > > > >
> > > > > You can edit the service types in the adminstration section on the
> > main
> > > > > menu.
> > > > >
> > > > > --
> > > > > _ivan
> > > > >
> > > > >
> > > >
> > >
> > > --
> > > _ivan
> > >
> > >
> >
>
> --
> _ivan
>
>




More information about the freeside-users mailing list