Turning Off Serial/Lot in IM

[milhouse314]

Does anyone know an easy way to turn off serial/lot in IM when you already items that have have serial/lot info. We want to just disregard all this info and not have to zero out everything manually.

 

[dgillz]

There are several steps to this, and I may have missed some, but the following is a good start:

1) Initialize the following tables:
IMLSMST - Lot Serial Master
IMLSTRX - Lot Serial Transaction
IMTAGSUB - Lot Serial Tags

2) Change the lot-serial flag on the item master record to 'N'. I would do this with a SQL update query.

3) Change IM Setup page 3 to unclick 'Use Serial Lot', change serial lot issue method to N-Not in use and blank out the serial no assignment and lot no assignment fields.

4) Change the lot_ser_cd field in OEORDLIN_SQL to 'N'.

Good Luck.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[kscheeler]

It would depend on what's open for those items. If you went behind the scene and flagged the item master records IMITMIDX_SQL (ser_lot_cd) as 'N' for the serial/lot flag, you would also have to do so in the order line table OEORDLIN_SQL (ser_lot_cd) and I believe there's a similar field (ser_lot_fg) in the shop order detail table SFDTLFIL_SQL. You would then also change the IM control file to not use serial/lot information.

Though there would be information in the serial/lot master and serial/lot transaction tables, they wouldn't be used by the system.

Kevin Scheeler

 

[milhouse314]

Thanks guys these worked perfectly.