mWO 24.5.1219.0 part missing in My Stock

Hi

Can you please check the following?

Check if the required part is visible in the below two tables in the local database (device database).

1. inventory_part
2. inventory_part_in_stock (check if the quantity available is greater than 0)

You can access the local database via Settings > Developer Tools in the App. If the Developer Tools option is not available in the client, it can be enabled via,

 Thanks

Sampath

Thanks, Sampath.

I couldn’t see Developer Tools in mWO, so I enabled the above setting in the web client. Do I have to initialize to make the Developer Tools appear on mWO? If I do initialize, think the part is going to show up anyway. Trying to figure it out without initializing.

This is what I see when I go to Settings:

Yes, you will probably want to init the device to see the Developer Tool option after enabling it in backend. 

If the part shows up after init, that means some data that is required to show the part in My Stock has not been synced to mobile before. 

Is it a brand new part (not connected to mobile user part assortments or user assigned work task)? If that is the case, you will probably want to run the scheduled database task “Refresh All Inventory Parts” and then sync the two entities “InventoryPart” and “InventoryPartInStock” (via Sync Now option in Sync Rules screen in web).

If the problem still persists, please create a support ticket for further investigations. 

Thanks

Sampath 

It is not a new part. I first thought it wasn’t in the part assortment and realized it was already added in there. The part was transferred to his van last Friday - so there was many instances of batch syncs since then, yet the part didn’t show up in My Stock. “Refresh All Parts” happen twice daily, “Refresh Purchase Parts” happen daily, and entities such as InventoryPart, InventoryPartInStock etc gets synced every hour. It is not a part in a job, but his objective is to add it to a job as a new planned part and then issue it out (he can still do it as per the images, but he wasnt aware as he was checking the My Stock waiting for the part to turn up).

I know it is not only his device showing the symptom, as the above screenshots are from my test device. I’ve just added my test user to his remote warehouse, and ran the sync tasks to sync my test device and user to his stock.

Going to run an initialize on my device now. I will return with some feedback. Thank you for your help so far.

Have initialized and the part has turned up in My Stock.

Hi @skullk 

You mentioned that “If the part shows up after init, that means some data that is required to show the part in My Stock has not been synced to mobile before. ”

What do you think I’m missing? What other sync entities should I run?

Regards

Asanka

Hi Asanka,

To view the part in my stock what you need is the followings,

1. Part should be available in the Inventory_Part table in the device. Data is received to this table via InventoryPart entity which syncs in Batch sync and data is filtered by mobile_user_inventory_part data. So the data must have been written to mobile_user_inventory_part via the Refresh All Inventory Parts database job first.
2. Part stock should be available in the Inventory_Part_In_Stock table in the device. Data is received to this table via InventoryPartInStock entity which syncs in Batch sync. User should have been connected to the warehouse to receive the stock. 

If you can see the data only after an init, that means one of above entities were not updated/synced before the init.

Try this out and if the issue still persists, please report a support ticket for further investigations.

Thanks

Sampath

Thanks Sampath,

Like I mentioned those entities and bg jobs have been running for the past few days, yet the part didn’t appear in My Stock. The part was still able to be issued if added to a job on the device - so that indicates that the device database has the quantity in stock updated somewhere - just not in My Stock page. This is what I can’t work out. I would create a case for IFS - but the issue is I need to push these errors through as they are field devices and can’t hold them till IFS can remote on to it.

Cheers,

Asanka

@skullk Hi Sampath, have noticed the issue again, but this time had the db viewer enabled. The records turn up in both tables. Please see the thread