mWO Service Engineer records missing in My Stock (v. 24.6.1242.0) Cloud 23R2

Hi,

Could you please check the values for attributes QuantityAvailable , QuantityOnHand and ShowFullyReservedParts in inventory_part local table and values for attributes QtyAvailable, QtyOnhand and ShowFullyReservedParts in inventory_part_in_stock local table?

Hi Dileepa,

Thanks for your response, mate.

From inventory_part --->

QuantityAvailable = 0

QuantityOnHand =0

ShowFullyReservedParts = couldn’t find the column :/

From inventory_part_in_stock -→

QtyAvailable = 6

QtyOnhand = 6

ShowFullyReservedParts = couldn’t find the column in here either

Okay, so seems like inventory_part didn’t see the stock but inventory_part_in_stock did?

• The parts arrived to warehouse at 2.31pm (inbound transaction)
• Batch sync ran at 2.59 syncs both inventorypart and inventorypartinstock. It should have captured the new stock.

  

  In fact the log too says it found the new values for 022507 part 

  

Is it because the inventorypart is sitting ahead in the entity list compared to inventorypartinstock - therefore it didn’t see the increase of qty?

By the way, the user could still issue the part out by creating a new planned part on the work task - which recognized that there are 6 parts in stock. However, Quick Issue and My Stock both didn’t show records. 

Hi,

No it won’t be an issue since those attributes were derived from InventoryPartInStock and added to the offline logic SU3 onwards. Can I know your SU version?

Application service update: 23.2.0

Framework service update: 23.2.0

IFS Cloud Web version: 23.2.0.20231109163909.0

IFS OData provider version: 23.2.0.20231106032842.0

Hi,

Thanks for the information.
Can I know the values for

• WarehouseId,Contract(User_Warehouse_Connection local table)

• Warehouse(inventory_part_in_stock local table)
• Site(inventory_part local table)

Hi Dileepa, the transaction was completed now with the manual planend part. Don’t think it will give you the data you’re after if I try now. If you have any suggestion to improve this, please let me know. Thank you.