Skip to main content
Question

Is it possible to amend Lot Batch No

  • May 17, 2021
  • 7 replies
  • 442 views

Forum|alt.badge.img+18

It has just been reported that a lot_batch_no has been e ntered incorrectly for 1 order.   Is is possible to amend the lot_batch_no.

 

I don’t believe it is possible as material transactions exit but thought I would ask.

This topic has been closed for replies.

7 replies

Rasika Lakmal
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • 214 replies
  • May 17, 2021

@johnw66 Once you receive the lot batch, you cannot amend it. You may need to do a data repair to fix it or use below workaround.

  1. Go to Count per inventory part window
  2. Count out the Lot Batch
  3. Count in Correct Lot Batch

Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • 368 replies
  • May 17, 2021

@Rasika Lakmal Thank you very much for your advise. 

Can you advise the steps for a data repair?

Thanks

 

John


Rasika Lakmal
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • 214 replies
  • May 17, 2021

In order to propose a data repair script, the issue needs to be investigated. If you can create a IFS case, it will be investigated.

Can’t you follow the suggested workaround?


Rajitha Herath
Sidekick (Partner)
Forum|alt.badge.img+7
  • Sidekick (Partner)
  • 27 replies
  • May 17, 2021

Hi @johnw66 

 

A data repair would be possible. 

But there are few tables you might need to consider like INVENTORY_PART_IN_STOCK_TAB,  LOT_BATCH_MASTER_TAB etc.

It would be better if you could dispatch an investigation task for IFS consultingfor further investigations in order to look in to the possibility of a Data repair. 


Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • 368 replies
  • May 17, 2021

@Rasika Lakmal Unfortunately,  lot batch no’s were used on a Shipment and the Packing List has been printed.  Count Out/Count In wouldn’t update the Shipment, Picking List etc.,

 

John

 


Rasika Lakmal
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • 214 replies
  • May 17, 2021

You can undo the customer order to release status once you create the picklist and then do the count out.

  1. Go to Report Picking of Picklist lines window
  2. Set quantity pick as “0”

 

  1. Right click on the line/ Report Picking from the selected location
  2. Then customer order line will be released 
  3. You can Count Out and Count In

Note: I recommend you to do this in your Test environment first before doing it in Production.

But If you still go with the data repair option, please create a IFS case. As you have already proceed the order, it’s required to investigate possibility of data repair. 

 


Björn Hultgren
Hero (Employee)
Forum|alt.badge.img+25
  • Hero (Employee)
  • 1061 replies
  • May 17, 2021

Maybe you can issue this lot/batch no to a repair shop order and receive it back with another (correct)lot/batch no to stock?