TIMO Console Inventory Reports: In Store

• Access TIMO Console at: https://timo-console.px-prd9105.tke.t-mobile.com
• Login using your NTID and password. (Note: You must be on the T-Mobile network or using VPN to access TIMO Console.)
• TIMO Console works best in Chrome on a desktop or laptop computer.
• TIMO Console is also accessible on REMO, listed under Tasks.
• Power BI Reports are accessible via TIMO Console or can be accessed directly from Inventory Reporting Landing - PowerBI.

• Review PI Count Schedule:
  • Allows you to see when and what type of Physical Inventory Counts are scheduled for your store.
• Review Dashboard Notification:
  • Displays the current notifications on a store’s TIMO Dashboard.
  • Also provides past or expired TIMO Dashboard notifications.
• Review STO:
  • Allows you to view open (in-transit) Store-to-Store and Store-to-DC STOs, with serial number and license plate numbers detail. This also includes STOs created by your store.
  • Note: Once an STO is received, it will no longer display on this report.
• Review Misshipment:
  • Provides visibility to Misshipment Claims filed against your store.
• Carrier Tracking:
  • Allows you the ability to search incoming & outgoing shipments.
  • Provides additional status and visibility of a packages location that is not available when using the consumer facing UPS website.
• Stock on Hand Report:
  • Shows both sellable and non-sellable Stock-on-Hand at both a SKU and/or Serial Number level without retail hierarchy.
    • For SKU Level only visibility, select “SKU Level” at the top of the report.
    • For IMEI level, select “Serial Number Level” at the top of the report.
  • Warranty Fulfillment devices show in their own column of the report as “Sellable – Warranty” because these devices are sellable, but only to a specific customer. Defective and Canceled Warranty devices are non-sellable and show in the “non-sellable” column of the report.
  • Visibility to another store’s Stock-on-Hand at a SKU level within this report.
  • Run the report:
    • Go to the Stock on Hand report in TIMO Console.
    • Enter the SKU number or SKU description into the input field to view a specific material.  Or select Serial Number to view all Serial Numbers within your Stock-on-Hand or enter a specific SKU to view all related Serial Numbers.
  • Read the report:
    • Default view displays material quantities in store.
    • Material line item includes:
      • SKU
      • SKU description.
      • Stock-on-Hand qty.
      • Stock In-Transit qty.
      • Mandatory Return icon & due date (if applicable)
    • Report can be filtered to include zero quantity SKUs.
• Expected Returns Report:
  • Shows all items in a non-sellable inventory state that need to be transferred and shipped back to the Return Center.
  • This report should match what is in a store’s return bin and provides aid to Field Leaders in identifying exactly what a store needs to transfer back to the Return Center.
• Serialized Item History Report (Real-Time):
  • Provides visibility into a Serialized Items current location and history real-time related to that Serial Number.
  • The Real-Time version updates instantly with new events and provides a specific Serial Number’s Inventory Status, Process, System used, Sellable/Non-Sellable status, Posting Dates, and User IDs associated.  (Note: This report does not show Customer Account, MSISDN, STO or DO info.)
• PI Overview Report:
  • Provides a high-level overview of when a store performed a PI Count, what type of count was performed, and the total variance/difference qty. of that count.
• PI Variance Detailed Report:
  • Provides a detailed view of variances for a specific PI Count at the SKU level and Serial Number level (IMEI or License Plate) of Positive and Negative Adjustments posted during a PI Count.
  • Note: Use the PI Adjustment Report when trying to identify the true Positive and Negative Variance Dollar Amounts posted by a store as the dollar amounts listed within the PI Variance Detailed Report reflect SAP $ values which are not correct.
  • Run the report:
    • Go to PI Variance Detailed Report in TIMO Console.
    • Select date range for requested PI variance summary followed by Search.
  • Report includes:
    • Count Type
    • PI Group
    • SKU
    • SKU description.
    • Counted Qty.
    • Expected SOH
    • Difference Qty.
    • Value Difference
    • Count Date
• PI Error Notifications:
  • Displays any IMEI counted during a store’s PI that was not added to inventory.
  • These units need to be researched to determine their origin, and then managed correctly to return to DC or connect with a customer order.
• Stock on Hand (SKU) w/ Hierarchy:
  • Displays stock on hand at a SKU level, for a single SKU or multiple SKUs, across all stores, with store hierarchy included in the report.
  • Report has a 15-minute delay.
• Stock on Hand (Serial) w/ Hierarchy:
  • Displays stock on hand down to IMEI or license plate level, for a single SKU or multiple SKUs, across all stores, with store hierarchy included in report.
  • Report has a 15-minute delay.

• Serialized Item History Report (1 Hr. Delayed):
  • This report is very similar to the Real-Time version; however, it provides greater visibility into a Serial Number and the specific events or history associated.
  • This greater visibility includes being able to review a Serial Number’s STO or DO’s associated, Tracking Numbers, Customer BAN & MSISDN info, etc.
  • Note: This report is delayed and takes up to 1 hour to show any new events posted towards a Serial Number.
  • This report has a 90-day version and a full history version. The full history version has up to 2 years of history.
• Dual Stack PI Adjustment Report (1 Hr. Delayed):
  • Provides visibility to the SKUs and Serial Numbers for which a store posted Positive or Negative Variances.
  • Note: Stores may continue to see RMS Stack adjustment data until all chargebacks have been processed.
• Operational Compliance Dashboard (1 Hr. Delayed): 
  • Provides compliance overview and details down to store level in operational metrics such as Mandatory Returns and Stock Rebalance.
• PI SOX Compliance Report (1 Hr. Delayed): 
  • Provides SOX compliance details down to store level for Physical Inventory counts.
• Inventory Movement Report (1 Hr. Delayed):
  • Provides SKU level details on daily inventory movements, including but not limited to, inventory receiving, sales, returns and adjustments. Where applicable, serial number detail is also provided.
• Inventory Receiving Report (1 Hr. Delayed):
  • Provides a detailed view of inventory receiving/receiving compliance, stock in transit and product at risk of being assumed received.
• Inventory Returns Report (1 Hr. Delayed):
  • Provides an overview and detailed view of inventory returns, reversals, blind receipts and store to store transfers.
  • Provides details on in-store DASH Return Compliance and CCR Returns.
• Expected Returns Report (1 Hr. Delayed): 
  • Provides an overview and details down to serial number level, on non-sellable product in store inventory that needs to be returned to the DC.
• Device Condition Dashboard (1 Hr. Delayed):
  • Provides a detailed view of Device Condition compliance, chargeback and overrides (where applicable).
• Inventory Health Dashboard (1 Hr. Delayed):
  • Provides a variety of views and details on inventory health at product, SKU and multiple hierarchy levels, down to store level.
• Mis-Shipment Visibility Report (1 Hr. Delayed):
  • Provides details on active and canceled overshipment and undershipment claims, down to store and serial number level.
• Remorse Return Report (1 Hr. Delayed):
  • Provides an overview and detailed view of Device and Accessory Remorse Returns, including overall return rate and return reasons.
• Manual Entry Report (1 Hr. Delayed):
  • Provides details on all serial numbers that have been manually typed into inventory and POS transactions.
• UPS Claim Dashboard (1 Hr. Delayed):
  • Provides details on UPS claims filed via the Inventory Operations SharePoint, including the status of the claim and the month in which approved claims will reflect in the OPEX Shrink Dashboard or the Authorized Retailer Expense file for credit.

To export a TIMO Console Report, click the Export to Excel button at the top right of the report to generate an excel version of the report.

To export a Power BI report, click the three dots for More options at the top right of the table / visual in the report or use the export functions at the top left of the report.

See below for store reporting field names and a brief description of each:

• Days - Number of days since a transfer was shipped.
• Delivery Number - Begins with 810XXXXXX and is used to receive shipments. It is found on the Automatic Shipping Notification (ASN) and through the Stock in Transit Report.
• Document Date - Date a transfer was created.
• Goods Issue Date - Date a shipment left the distribution center.
• Inter-Plant Transfer STO - Transfer from another store.
• Issuing Plant - Location that created a transfer or shipment (store or distribution center).
• Mandatory Return item - SKUs identified as a mandatory return which require a transfer to the DC by a specified due date. Mandatory returns are identified by an MR icon in TIMO.
• Material - SKU of an item which generally begins with 6102, SUPA, SUPM, TMOA, TMOM or MYT.
• Material Group - Group of SKUs arranged by category type (e.g., ACC or KIT).
• Material Number - SKU of an item that generally begin with 6102, SUPA, SUPM, TMOA, TMOM or MYT.
• Movement Type - Type of transaction you are researching (e.g., Received, Sold, Returned).
• Physical Inventory Document - Begins with 01000XXXXX and can be used to filter report results or reprint a specific section of a monthly inventory. Each physical inventory document has a document number.
• PI Session - PI count type selected on TIMO.
• Plant - Store number. (Example: 8499)
• Posting Date - Date that a transfer was created.
• Receiving Plant - Location that is receiving a transfer or shipment (store or distribution center).
• Reclaim item - Mandatory return SKU identified as a Reclaim with an RC icon.
• Replenishment STO - Normal shipment from a distribution center.
• Selection Date - Date or date range in question.
• Shipping Plant - Location that created a transfer or shipment (store or distribution center).
• STO Document Number - Order number that begins with 600XXXXXXX.
• UPS Tracking Number - Tracking number provided from UPS to identify a shipment. (Example: 1ZV4Y4279097882592)
• Username - Person who executed a movement in SAP.

See below for a full understanding of all RIS TIMO Console/TIMO Device Inventory Event Types (Previously referred to as “SAP Movement Types”):

• System + SOA Process = Inventory Status
• System:
  • POS Sale – Standard POS Sale
  • POS Return – Standard POS Return
  • POS Sale Void – POS Sale Trans. Voided
  • POS Return Void – POS Return Trans. Voided
  • TIMO Transfer – S2DC or S2S Transfer created using TIMO
  • TIMO State Conversion – Inventory converted to Non-Sellable or Sellable using TIMO
  • DC Transfer – DC2S Transfer
  • TIMO Receive – Items received into Inventory using TIMO
  • Assumed Receipt Job – Confirmed Delivered Shipments being Auto-Received into store
  • S2DC STO Reversal Job – Items being reversed back to store
  • TIMO PI – Items being counted during PI Counts using TIMO
  • TIMO Demo Conversion – Items converted into Demos using TIMO
  • QVXP Warranty Order Canceled – Warranty Exchange Order being canceled
• SOA Process:
  • DC2S Transfer – Shipment created from DC to store
  • Receipt – Items being received into Inventory
  • Over-Shipment – Receiving unexpected items into Inventory
  • Under-Shipment – Receiving less than what was expected into Inventory
  • Over-Shipment Reversal – Unexpected items Over-Shipped being reversed out of store Inventory
  • Under-Shipment Reversal – Previous Under-Shipment being reversed placing item back into store Inventory
  • S2DC Transfer Creation – Return Transfer being created from store to Return Center
  • S2DC Transfer Reversal – Previously transferred items to DC being reversed back to store Inventory
  • DC Blind Receipt – Unexpected item arrived to Return Center from store
  • S2S Creation – Shipments created from 1 store to another via S2S Transfer
  • S2S Blind Receipt – Unexpected items arriving to store from a S2S Transfer
  • S2S Transfer Reversal – Receiving store reporting did not receive item previously transferred by Shipping store
  • Adjusted In – Items being brought back into store Inventory, sometimes resulting in a “Positive Variance”
  • Adjusted Out – Items not being counted during store PI Counts causes them to adjust out of Inventory, sometimes resulting in a “Negative Variance”
  • Sale – Items being sold via standard POS Sale
  • Return – Items being returned via standard POS Return
  • Sale Void – POS Sale Trans. being Voided
  • Return Void – POS Return Trans. being Voided
  • Converted to Sellable – Item being converted from Non-Sellable to Sellable status
  • Converted to Non-Sellable – Item being converted from Sellable to Non-Sellable status
  • Physical Inventory Count – Item being counted during PI Count
  • Demo Conversion-Initial – Demo Conversion processed for “Initial Demo not received”
  • Demo Conversion-Damaged – Demo Conversion processed for “Damaged Demo”
  • Demo Conversion-Lost/Stolen – Demo Conversion processed for “Lost/Stolen Demo”
  • Warranty Order Canceled – Warranty Exchange Order being canceled
  • Warranty Exchange Cancellation – Warranty Exchange Order being canceled after 14 days
• Inventory Status:
  • In-Transit – Shipments in route from either DC2S, S2DC, or S2S Transfers
  • Received – Item being Received into store Inventory
  • Adjusted In – Item being brought back into store Inventory from previously being Adjusted Out
  • Adjusted Out – Expected item being removed from store Inventory, usually due to stores not counting during PI Count
  • Sold – Item sold through standard POS Sale
  • Returned – Item being returned through standard POS Return/POS Trade-In
  • Received In DC – S2DC shipment being received at Return Center
  • Demo Converted – Item converted to Demo via Demo Conversion processed
  • Warranty Canceled – Warranty Exchange Order in Canceled status needing to be sent back to Return Center

• TIMO devices: In-Store

MFA_Expanded_To_TIMO_TIMO_Console_GnG.pdf

SOH Reporting Tableau.pdf