Question

Update UOM for Inventory Part

  • 8 September 2022
  • 3 replies
  • 149 views

Userlevel 4
Badge +9
  • Sidekick (Customer)
  • 58 replies

Hello,

We recently went through a migration where inventory parts were given the wrong UOM and inventory was migrated. How can we update the UOM to correct the issue. The qty is correct but the UOM is incorrect. Does this require a DB level change? 


3 replies

Badge +1

You can create a script via PL/SQL Developer to update the UoM (you can load an Excel into a custom table and then run the script to process the required changes in IFS).

 

Userlevel 5
Badge +13

Hi,

If you don’t have stock yet, you can change de UoM in Part Catalog.

Regards,

Pilar

Userlevel 5
Badge +15

You can create a script via PL/SQL Developer to update the UoM (you can load an Excel into a custom table and then run the script to process the required changes in IFS).

 

Hi Sandra,

Do you have an example of this? I’m assuming this would be an ‘execute online sql’ event action?

 

Thanks,
Bryan

Reply