Case: Get mobile statistics

Owned by Morten Bjørn Larsen
Last updated: Apr 11, 2024 by Johannes Sebastian Nielsen
2 min read

Case

The customer wants to gather statistics about picks, for example; how many picks are processed, how many lines per pick, and the time of each pick.


Options in NAV/BC

We have some raw data that you can use for this.

Communications - (Development and debugging)

Every request and response is stored in the table "MOB Document Queue"

Use the page "Mobile Document Queue List" to view the XML sent from and to the mobile app.


Locking - (Orders currently open)

The currently locked orders are available in the table "MOB Order Lock"

 

Order Registrations - (Data debugging and Statistics)

Data of the registrations created on the mobile device is available in the table "MOB WMS Registration".

Data is saved in this table when posting from the mobile device. If you would like to amend data to the table, you can do so in function "SaveRegistrationData" in codeunit "MOB WMS Toolbox".

Note that the field "RegistrationCreated" is the date that the registration was created on the mobile device.


Real Time Quantity - (Currently Picked/Put-Away quantity)

You can use this feature to view the quantities being Taken/Placed in real time, before posting.

This is available in the table "MOB Realtime Reg Qty."

 

Telemetry "Application Insights"

Telemetry is logged using Application Insights for all requests sent from mobile to BC.

Only generic data like the Mobile Document Types (6/10), Processing Time, and are logged. You will not find Request XML, order, nor customer data in telemetry.


The data can be queried using KQ.

For example this query shows the number of PostPickOrder requests that has been completed, per hour: 

traces
| where customDimensions.eventId startswith "ALMOB2000"
| where customDimensions.alEventName == "PostPickOrder"
| where customDimensions.aadTenantId == "..."
| where customDimensions.alCompany contains "..."
| summarize count() by bin(timestamp, 1h)

Links with additional information: