Case: Get mobile statistics

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.

See View Request and Response XML and Error Call Stack

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."

See Register Realtime Quantity (Liveupdate)

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: