Reports & Documentation
Chapter 3 — Activity Reports

Customer activity

Complete & Continue Next Lesson Learn More

LESSON INFO

Audience

  • Warehouse operators reviewing what happened to a customer’s inventory during a period.
  • Billing staff doing a pre-invoice activity check.
  • Customer service representatives preparing period summaries for customers.

Prerequisites

  • You can access the Themis-Trace web app.
  • Your role can access Reports and view the target customer/customers.
  • You know the period start and end dates you want to review.

Skills you’ll build

  • Run a period-based activity report for one or more customers.
  • Read the receiving detail table.
  • Interpret the Activity Summary breakdown.
  • Identify when totals do not “balance” and what to do next.

LESSON OUTLINE

Concept

  • Customer Activity is the primary “period audit” report.
  • The report has two parts:
    • Activity Summary: a compact grid showing Opening / Receiving / Transfers / Shipping (Truck) / Shipping (Rail) / Closing by customer, facility, and product type.
    • Details: A comprehensive table documenting every item received during the period.
  • Quick sense-check:
    • Opening + Receiving + Transfers In - Shipping - Transfers Out = Closing

Run a Customer Activity report

  1. Open Reports.
  2. Select Customer Activity.
  3. In the parameter form:
    • Set Start date and End date.
    • Select the Customer (or Customers).
    • 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.

Review the output

  1. Review the Activity Summary.
    • Use the sense-check equation to confirm the period balances.
  2. Review the receiving detail section first.
    • Spot-check that expected items and receiving BOLs appear.

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 a period does not balance, do not “force” an invoice:
    • First confirm that the period dates and filters are correct.
    • Then investigate the specific mismatch (missing receive/ship finalization, unexpected transfer, or a boundary-timing issue).

Verification

  • Opening (this period) matches Closing from the prior period’s Customer Invoicing Detail (same filters).
  • Closing matches the row count in Customer Inventory Listing for the last day of the period (same filters).

COMMON QUESTIONS

    • Likely cause

      • A receive/ship event sits on the boundary of the period, or activity was finalized after the prior report was run.

    • Checks

      • Compare the item IDs that differ between periods.

      • Check for activity on the first/last day of the period.

    • Fix

      • Correct the underlying record timing/finalization issue, then rerun.

    • Likely cause

      • Receiving detail shows only items received during the period; an item can transfer in this period but have been received earlier.

    • Checks

      • Look for the item in invoicing detail transfers or item history.

    • Fix

      • Use transfers sections for movement investigation; don’t expect transferred items to appear as new receives.