× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MAPICS-L
  3. January 2003

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.