Re: Expanding ITNBR Field length

Phillip, I would be very interested in working with Crane to develop
Crystal-based reports.

So far, I have done a pilot project using the MAPICS-AR application (The
ugliest D/B in MAPICS). Most of the Crystal Reports work can be done
remotely in your test environment. So, I believe that we can work out some
very attractive rates.
----- Original Message -----
From: "Philip Freimann" <PFreimann@cranecams.com>
To: "'MAPICS ERP System Discussion'" <mapics-l@midrange.com>
Sent: Friday, January 24, 2003 4:30 PM
Subject: RE: Expanding ITNBR Field length


> Thanks.  I've been asking that question for months in many places - and
one
> has been able to say anything but, "... well, in theory you should be able
> to ..." etc.  I've asked sales people for Crystal Reports, business
> partners, and even Crystal discussion groups.  "You're the man!"
>
> Keep warm this weekend.
>
> -----Original Message-----
> From: Bob Tenney [mailto:bobtenney@earthlink.net]
> Sent: Friday, January 24, 2003 9:41 AM
> To: MAPICS ERP System Discussion
> Subject: Re: Expanding ITNBR Field length
>
>
> Phillip, Yes you can. Crystal has a feature called subreports that lets
you
> extract data from two or more unrelated databases and then combine the
data.
> You get the illusion of one report. Of course, notrhing is free in a
> computer system and it takes longer to generate reports because you are
> really running two reports and then combining them.
>
> Subreports also let you link databases that are not normally linkable. For
> example you can link COM's numeric customer number with IFM's character
> Entity ID without resorting to a macro.
>
> Bob Tenney
> Bob Tenney Solutions, LLC
> MAPICS - FRx - Crystal Reports
> 828-526-8976
> Visit www.tenneypubs.com for books about
> IFM, FRx, COM, Cost Accounting,
> General Ledger Interfaces, and
> Info WorkPlace
>
> ----- Original Message -----
> From: "Philip Freimann" <PFreimann@cranecams.com>
> To: "'MAPICS ERP System Discussion'" <mapics-l@midrange.com>
> Sent: Friday, January 24, 2003 8:52 AM
> Subject: RE: Expanding ITNBR Field length
>
>
> > That's interesting.  Can you use Crystal Reports with AS/400 data?  That
> > opens a lot of possibilities.  If so, can you use Crystal Report to
access
> > data on both the AS/400 and the Microsoft network - in the same report?
> >
> > -----Original Message-----
> > From: Bob Tenney [mailto:bobtenney@earthlink.net]
> > Sent: Thursday, January 23, 2003 12:26 PM
> > To: MAPICS ERP System Discussion
> > Subject: Re: Expanding ITNBR Field length
> >
> >
> > Bryan, Using an Item Master user field or the COM item cross-reference
are
> > the logical starting points for working around the 15 character item
> number.
> >
> > Once you do this, you still have to use the expanded item number in your
> > dealings with Corporate and other plants. You might consider using
Crystal
> > Reports as a way of providing this info.
> >
> > Bob Tenney
> > Bob Tenney Solutions, LLC
> > MAPICS - FRx - Crystal Reports
> > 828-526-8976
> > Visit www.tenneypubs.com for books about
> > IFM, FRx, COM, Cost Accounting,
> > General Ledger Interfaces, and
> > Info WorkPlace
> > ----- Original Message -----
> > From: "Burns, Bryan" <burnsbm@Echoincorporated.com>
> > To: "'MAPICS ERP System Discussion'" <mapics-l@midrange.com>
> > Sent: Thursday, January 23, 2003 11:03 AM
> > Subject: RE: Expanding ITNBR Field length
> >
> >
> > > Great! Now we don't have to do it!  The request came from our
corporate
> > > parent.
> > >
> > > Needless to say, this is something that would be impossible for us to
do
> > > ourselves correct?
> > >
> > > -----Original Message-----
> > > From: pgroeber@bellsouth.net [mailto:pgroeber@bellsouth.net]
> > > Sent: Thursday, January 23, 2003 10:00 AM
> > > To: MAPICS ERP System Discussion
> > > Subject: Re: Expanding ITNBR Field length
> > >
> > >
> > > Bryan,
> > >
> > > As a former MAPICS employee, I can almost guarantee that there are NO
> > plans
> > > to increase this field size.  It would require a massive undertaking
of
> > not
> > > just IM, EPDM applications, but COM/CSM, MRP, MPSP, PUR, etc.
> > applications.
> > > Customers would have to reorder forms or change programs, history
files
> > > would be affected - it would be huge.  On top of that, if there were
any
> > > requests from customers for this change, there were only a few.  This
> > change
> > > would be a huge impact for minimual gain for both the customer and
> MAPICS.
> > >
> > > In other words, don't look for it to change in MAPICS software.  Hope
> this
> > > helps.
> > >
> > > Paola Groeber
> > > MAPICS Consultant
> > >
> > >
> > > >
> > > > From: "Burns, Bryan" <burnsbm@Echoincorporated.com>
> > > > Date: 2003/01/23 Thu AM 10:17:55 EST
> > > > To: "'MAPICS-L@midrange.com'" <MAPICS-L@midrange.com>
> > > > Subject: Expanding ITNBR Field length
> > > >
> > > > Does anyone if there are plans by MAPICS to expand the field length
of
> > > ITNBR
> > > > beyond 15 in a future release?
> > > >
> > > > We are on XAR5.5.
> > > >
> > > >
> > > > Thanks in advance for any replies.
> > > >
> > > >
> > > > Bryan Burns
> > > > System Operator
> > > > ECHO Incorporated
> > > > Lake Zurich, Illinois
> > > > 847-540-8400 ext. 493
> > > >
> > > > _______________________________________________
> > > > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > > > To post a message email: MAPICS-L@midrange.com
> > > > To subscribe, unsubscribe, or change list options,
> > > > visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
> > > > or email: MAPICS-L-request@midrange.com
> > > > Before posting, please take a moment to review the archives
> > > > at http://archive.midrange.com/mapics-l.
> > > >
> > > >
> > >
> > > _______________________________________________
> > > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > > To post a message email: MAPICS-L@midrange.com
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
> > > or email: MAPICS-L-request@midrange.com
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/mapics-l.
> > > _______________________________________________
> > > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > > To post a message email: MAPICS-L@midrange.com
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
> > > or email: MAPICS-L-request@midrange.com
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/mapics-l.
> > >
> >
> > _______________________________________________
> > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > To post a message email: MAPICS-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
> > or email: MAPICS-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/mapics-l.
> > _______________________________________________
> > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > To post a message email: MAPICS-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
> > or email: MAPICS-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/mapics-l.
> >
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
>