Telecommunications logistics company advances its custom application

A primary concern for Tellworks was inventory variances between their counts and those of their largest client, T-Mobile. The inventory variances between Tellworks’ counts and T-Mobile’s counts were very different. Our team’s first recommendation was to focus on cleaning up key workflows so that Tellworks could gain better insights on their inventory across customers, in order to stabilize the inventory counts. Due to the complexity of their processes, our team needed to understand what was attributing to the inventory variances, why the variances were happening and build new workflows to address the variances between locations. Miles IT also continued to build new processes to help Tellworks and T-Mobile understand where parts of their inventory are located within the NDC.

T-Mobile works with various other providers to build the inventory required to assemble the “tower kits”. To provider better and more responsive services, Tellworks worked with Miles IT to build integrations to third party companies in order to streamline their critical processes.

An integration was created with SAP’s ARIBA system to share purchase order details with Tellworks, so that orders and inventory could be properly reconciled accurately, as they are received in the warehouse. In order to be efficient, this integration would let Tellworks know when they could expect to receive the inventory using Advanced Shipment Notifications (ASN).

An integration was created to a customer asset tracking system (CATS). The function of this application was to track each asset’s exact location from within the warehouse. Tellworks and Miles IT built this integration so that Tellworks could understand where it was located, whether it’s on a truck, sitting on the dock or forklift, or accounted for in order to reconcile it to a count.

An integration was created to streamline the processing of picking Bill of Materials (BOMs). This integration automatically sends a list of BOMs to the Tellworks system so that they are added to a Pick Schedule for order fulfillment. It allows pick schedules to be created on-demand, in real-time, as the truck loads are being prepared for pick-up. The planner can now create smaller and more specific pick plans for each truckload, optimizing the picking process and making it more efficient. This improvement in planning ensures that the right items are picked and loaded onto each truck, saving time and resources.

TMO Digital Layer is responsible for capturing information related to receipts, fulfillment, and associated assets. Once this data is collected, it will be transferred from the TMO Digital Layer to specific systems within the TMO, namely SAP and CATS. The integration aims to replace the current method of sending Goods Receipts, Shopping Cart details, Goods Issues, and Adjustments to TMO’s SAP application using flat files and SFTP transmission. Instead, the TMO Digital Layer will handle this data transfer more efficiently. The confirmation files from SAP will still be received in a flat file format and sent back to the Tellworks system.

The integration helps facilitate communication between the Tellworks system and the CATS database by comparing the data in the CATS File that is sent to Tellworks. This process will ensure that the two systems remain in sync and enable smoother data exchange between them.

FourKites Software provides tracking of shipment information for end-to-end visibility across the supply chain and real time freight tracking. The integration between FourKites Software and the Tellworks system seamlessly provides comprehensive tracking of shipment information throughout the supply chain. Through each transaction, FourKites sends instant updates through the API, to the Tellworks system for data storage.

This integration expands the Tellworks system’s capabilities by including more transportation carriers within its carrier EDI framework. To achieve this, the project involves configuring the EDI integration for Mack Transportation and setting up the necessary file transmission process for sending and receiving EDI files. The two types of EDI files involved in this project are 214 and 990. This enhancement will improve the overall efficiency and effectiveness of freight transportation operations for Tellworks and its partners.

Tellworks wanted to integrate a helpdesk solution into their application and Resale Recycle (RR) portal. This integration will allow Tellworks’ clients to easily submit support requests from within their application navigation menus. This also allows Tellworks to enhance customer support for their clients, making it easier for them to seek assistance and access support resources

The intention of these API endpoints was to expand the capabilities of the Tellworks system to perform various actions related to trucking operations. The following actions were created:

• Request Trucks: Sends the necessary information to the designated Transportation Company for requesting a truck using an EDI Request (204).
• Cancel Truck Request: Sends the required information for canceling a load request from AIMS Plus to AIMS. This ensures that any unnecessary or no longer needed load requests can be promptly canceled, saving time and resources.
• Update Truck Request: Tellworks can now update specific details such as comments or pallet information on a load. This flexibility enables users to make necessary adjustments and keep load information accurate and up-to-date.
• Add/Remove Pick to Load: The new API EndPoint allows users to add or remove Pick Authorization to a designated truck. This enables efficient load management and ensures that the right items are picked and loaded onto the truck.
• Deploy Truck: Tellworks will be able to update the status of Pick Authorization on a truck to “Deployed” and the status of the load to “Shipped.”