NeedHelp:LotNo modified(Need to Change all PstdEntries)

ajaybabuCh · 2007-11-21

Hi

The customer requirement is "Customer wants to rename the Lot number, even though it has posted entries or transactions, Then all the entries or posted entries(ILES) related to that Lot number should be changed to the New Lot Number."

Is it fair to do this customization. They want to rename the lot number through the Lot Information Card.
Tell me what are the side effects if I do this.

The reason to change the Lot number is because of wrong lot number entered sometimes(data entry mistake).

Regards
Ajay

kine · 2007-11-22

For me it looks as not so hard task, but you need to know all the tables where the no. is used, to prevent users to rename to some existing lot no (e.g. when there is no lot no. information for that new lot no. but it is existing in the entries), what about possible printed documents including the lot no., what about some possible printed labels on the products etc.

ajaybabuCh · 2007-11-22

Is it enough If I check the

Item Ledger entry , Reservation Entry tables to modify or to check whether the lot number existed or not when they change or rename the Lot Number

ara3n · 2007-11-22

Here is a list of tables that you need to modify.

TableNo	TableName	FieldName
32	Item Ledger Entry	Lot No.
83	Item Journal Line	Lot No.
83	Item Journal Line	New Lot No.
169	Job Ledger Entry	Lot No.
210	Job Journal Line	Lot No.
307	Inventory Buffer	Lot No.
336	Tracking Specification	New Lot No.
336	Tracking Specification	Lot No.
337	Reservation Entry	New Lot No.
337	Reservation Entry	Lot No.
338	Entry Summary	Lot No.
1003	Job Planning Line	Lot No.
5767	Warehouse Activity Line	Lot No.
5773	Registered Whse. Activity Line	Lot No.
6505	Lot No. Information	Lot No.
6506	Item Tracking Comment	Serial/Lot No.
6507	Item Entry Relation	Lot No.
6509	Whse. Item Entry Relation	Lot No.
6520	Item Tracing Buffer	Lot No.
6529	Record Buffer	Lot No.
6550	Whse. Item Tracking Line	New Lot No.
6550	Whse. Item Tracking Line	Lot No.
7311	Warehouse Journal Line	Lot No.
7311	Warehouse Journal Line	New Lot No.
7312	Warehouse Entry	Lot No.
7319	Posted Whse. Receipt Line	Lot No.
7330	Bin Content Buffer	Lot No.
7341	Posted Invt. Put-away Line	Lot No.
7343	Posted Invt. Pick Line	Lot No.
99000853	Inventory Profile	Lot No.
99008501	Inbound Sales Document Line	Lot No.
99008503	Inbound Purchase Document Line	Lot No.
99008533	BizTalk Reservation Entry	New Lot No.
99008533	BizTalk Reservation Entry	Lot No.

ajaybabuCh · 2007-11-22

Hi Aran , thanq for your reply. But

Why we need to check Journal Tables and Tracking Specification.

I think Tracking Specification Table doen't contain actual entries. All the tracking entries will take place in Reservation entry only.

Even in case of Item Journals also.

Is there any specific reason to check these journal tables and tracking specification

ara3n · 2007-11-23

You never know where they've entered the lot no.

It won't hurt to search the tables the lot for that item.

NeedHelp:LotNo modified(Need to Change all PstdEntries)

Comments

Categories