Re: Changing Product Numbers

["Eric Daniel" <edaniel@xxxxxxxxxxxxx>]

Dear All,

In response to Dan's post, I believe that the Technical Reference is bundled
with System 21 Explorer.  It should be available in the June 99 release or
later.  If you are on an earlier version of Explorer or are interested in
the Technical Reference alone, you should contact your GEAC Enterprise
Solutions Project Manager and request it (Explorer should be free of charge,
as it is the standard GUI for System 21).  Of all of the PC utilities JBA
have written, the Explorer package (including the Technical Reference) is
one of the most impressive.

Regards,

Eric Daniel
Technical Consultant
Viking Consulting

----- Original Message -----
From: "Dan Thomas" <DThomas@lpw-mdi.com>
To: <JBAUSERS-L@midrange.com>
Sent: Friday, August 11, 2000 8:22 AM
Subject: RE: Changing Product Numbers


> If you want to look at all the fields, use the JBA Technical Reference
> database.  It's in MS Access format and includes every field in the system
> and how it's used.  I can't vouch for the accuracy of the information, but
> if it is complete, this is an awesome tool that hasn't been pushed enough
by
> JBA.  They include certain front end Access programs to use the data, but
if
> you're familiar at all with Access you can do much more.  You do have to
ask
> JBA to get this, but at one time it was free of charge.
>
> Dan Thomas
> Sr. VP Information Systems
> MDI
> 4500 Progress Blvd.
> Louisville, KY  40218-5058
> Phone (502) 454-9013 ext. 120
> www.mdiweb.com
>
>
> -----Original Message-----
> From: Neil Thursby [mailto:neil.thursby@whessoe-vapour.com]
> Sent: Friday, August 11, 2000 3:41 AM
> To: JBAUSERS-L@midrange.com
> Subject: RE: Changing Product Numbers
>
>
> I think the SA rebuild only does the SAP20 & 70 files.  You would still
have
> to check all the other SA files - forecasts, report definitions etc.
>
> I don't see any way of doing this task without manually analysing every
file
> concerned and writing the necessary code.   If you can get the file
> definitions into a database or spreadsheet, it would be worth searching on
> CATN* PNUM* ITEM* PRNT* COMP* and any other derivations you can think of,
> plus checking out all the 15 char fields.  At least that would show you
the
> potential size of the task.
>
> Good luck,
>
> Neil.
>
> -----Original Message-----
> From: owner-jbausers-l@midrange.com
> [mailto:owner-jbausers-l@midrange.com]On Behalf Of Doug333@aol.com
> Sent: Thursday, August, 10 2000 18:37
> To: JBAUSERS-L@midrange.com
> Subject: Re: Changing Product Numbers
>
>
> Aren't there rebuilds in some applications like sales analysis.  Once the
> invoice record is changed, the rebuild would be run using the new part
> number.  This would eliminate the analysis and fix program.  I'm not 100%
> sure.
> Doug
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
>
>
> Whessoe Vapour Control Limited
> Tel 44 (0)1325 301100
> Fax 44 (0)1325 300840
> Registered in England No. 3783765
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
>

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---