Re: Expanding ITNBR Field length -- MAPICS-L

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.
>