RE: Changing Product Numbers -- SYSTEM21

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