Migrating an old WMS RF application is not a matter of resizing pages for a phone. The RF client is a warehouse execution endpoint that directly changes inventory, task, and device state. It must handle identity, warehouse isolation, concurrent task claims, uncertain networks, and physical hardware. …

An order-status dashboard worked in the test environment but showed zero for every inbound, outbound, and workflow counter in production. The page list contained many orders, and read-only database checks confirmed recent activity. Zero was not the business result; it was the value left behind when …

Company, operating organization, project, and warehouse often appear together in login context, business documents, and query filters. They all seem to describe data ownership, but they represent different dimensions and should not be used interchangeably.

I derived their meaning from master-data …

A newly created outbound order could be found by its exact order number, but it did not appear when the default order-status dashboard opened. The API returned no authorization or warehouse-scope error, so the behavior initially looked like a missing SQL condition or stale cache.

Comparing the two …

A wave planning list in a WMS application took about six seconds to return one page of results. This note records the investigation path and the evidence behind the final optimization direction.

Identifiers and environment details have been anonymized. The SQL shape, measurements, and decisions are …