Reports & Documentation
Chapter 2 — Snapshot Reports

Customer inventory listing

Complete & Continue Next Lesson Learn More

LESSON INFO

Audience

  • Warehouse operators reconciling a physical count.
  • Billing staff verifying on-hand quantities before storage billing.
  • Customer service representatives responding to item availability questions.

Prerequisites

  • You can access the Themis-Trace web app.
  • Your role can access Reports and view the target customer(s).
  • You know the snapshot date you want to analyze.

Skills you’ll build

  • Run a point-in-time on-hand snapshot.
  • Interpret key columns (Received Date, Location Code, Gross Weight, Inventory Status).
  • Use the report to reconcile physical inventory against the system

LESSON OUTLINE

Concept

  • Customer Inventory Listing is a snapshot report.
    • It shows what was on hand **at the start of the selected date (**12AM in the selected Time Zone).
  • An item appears if it was received before that date and not shipped before that date.
  • A blank Location field usually means the item is received but has not yet been assigned a storage location.

Run a Customer Inventory Listing report

  1. Open Reports.
  2. Select Customer Inventory Listing.
  3. In the parameter form:
    • Set the Report date.
    • Select the Customer.
    • Select the Time Zone in which timestamps are displayed.
      • This parameter is set to Central Standard Time (CT) by default.
    • Optional: set Facility and/or Product Type filters.
  4. Run the report to load the embedded report.

Use the listing (common patterns)

  • Find an item
    1. Search within the output for the item identifier you have (Item ID, serial, heat number).
    2. Capture Location Code and Inventory Status.
  • Prepare for a physical count
    1. Run the report for the count date.
    2. Export/print using File in the embedded report.
    3. Use the row count as the system’s expected pieces on hand for that scope.

Export the output

  1. In the embedded report toolbar, select File.
  2. Select Export.
  3. Select Excel (or another format as needed).
  4. Save the exported file.

Safe edits

  • If an on-hand item seems to be missing, avoid assuming “the report is wrong.”
    • First confirm the item was fully received/confirmed.
    • Then confirm it has not shipped with a finalized ship date.

Verification

  • Row count matches Closing piece count from Customer Invoicing Detail for a period ending the day before the snapshot date (same filters).

COMMON QUESTIONS

    • Likely cause

      • The item was not fully received/confirmed, filters exclude it, or its receive date is after 12:00 AM on the snapshot date.

    • Checks

      • Confirm customer/facility filters.

      • Confirm the item has a completed receive date on or before the snapshot date.

    • Fix

      • Correct the underlying receive/finalization issue, then rerun.

    • Likely cause

      • The shipping order exists but shipment is not completed (no confirmed ship date).

    • Checks

      • Confirm ship date exists and shipment is complete.

    • Fix

      • Complete the associated shipment, then rerun.