Lot Serial No.

Hi,

I need to change the Lot Serial No. Length to be changed from 12 to 20
Since I am entering Newspaper Reel No. in the Lot no. field. If I change
that through data dictionary is there any implications elsewhere? Also
I need to change the field name to Reel No/ Pallet No in all inventory /
manufacturing programs. What is the best way do it ?

Kindly advise and send me the log id.

Thanks

Benoy.

You can change it in the data dictionary however the databases may not be
set to accept that large of a field as well as the screens already developed
in JDE>.. It might be more trouble than it's worth. A possibility is adding
another file to keep that information and then add it to the screens that
are necessary or the reports that you might need... just an idea. thanks,
Bobby

here is the same advice you will hear from others:

DON"T CHANGE LENGTHS OR DATA TYPES ON EXISTING FIELDS!

It is a MAJOR mod to make the change you are talking about - involving identification and updates of all objects using that DD item. Not to mention multiple custom table conversions . . . Plus you get to do it all over again with ESUs and Updates and Upgrades . . .

Sorry but I don't know of any easy way to handle this for a situation such as LOT NUMBER which is called out in all inventory transactions as well as appearing in tables such as Sales Orders, etc. Perhaps someone else has dealt with this before and will share their words of wisdom.

I completely agree with Larry Jones' response. I thought the same thing
when I first saw the post ... DON'T change the lengths or data types on
existing fields. Especially something like lot number (LOTN) that's used in
over 100 different tables!!!



Michelle Dulay
OneWorld Xe, SP 18.1, Update 2
Windows 2000 Deployment / Enterprise
SQL 2000

Benoy

Like the others say, don't chamge the length. However, with LOTN, you will
not need to change it as it is defined as 30 anyway.

Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:[email protected]

OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K

Re: RE: Lot Serial No.

How Funny! Good catch Marty!

RE: RE: Lot Serial No.

Larry

Not sure what you mean by this. I hope you are not suggesting that I am
purposely trying to give erroneous information. In our system LOTN IS 30. I
have been here since we went live with OneWorld 5 years ago on B731 and
along with all the other developers here am unaware of us modifying the dd
length.

Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:[email protected]

OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K

Dear All,

Thanks for all those who responded. though the dd says it is 30, you
will get only 12. You have to set the flag 'Non-coesitence Lot
Processing' in System constants in the inventory setup.

It works now

Thanks

Benoy

Re: RE: RE: Lot Serial No.

Marty,

I was complimenting you on catching what should have been obvious to the rest of us. here we (I) were, making a mountain out of a molehill, until you point out the field is already 30 characters long. It just struck me as funny, and, it WAS a good catch on your part.

RE: RE: RE: Lot Serial No.

Larry

Thanks for the clarification. My apologies for taking this the wrong way.
Your email arrived at the end of a bad day and I thought that you might be
winding me up - Not a good idea yesterday

Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:[email protected]

OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K