Skip to main content

Hi all,

 

I’ve synced to a remote warehouse where there are 6 parts in stock. This shows correctly in the DB viewer.

 

 

 

Also the record shows up in inventory_part table too.

System logs too show that it has found data to sync

The part is still missing in My Stock

 

Synced, and app restarted but no change. Appreciate if you know why. I’m on the latest app version but noticed this in the previous version too.

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?

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,

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.

Reply


Terms & ConditionsCookie settings