---
title: "How do I stop duplicate POs from inflating totals in my reports?"
slug: "how-do-i-stop-duplicate-pos-from-inflating-totals-in-my-reports"
updated: 2026-10-15T01:22:47Z
published: 2026-10-15T01:22:47Z
canonical: "help.servicetitan.com/how-do-i-stop-duplicate-pos-from-inflating-totals-in-my-reports"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.servicetitan.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How do I stop duplicate POs from inflating totals in my reports?

## Problem

A custom report built on the Purchasing Line Items template shows double-counted totals when Transaction Type = All (because POs, Bills, Receipts, Returns all appear) and cannot display Service Location.

## Solution

### Show PO totals without double counting and display the PO number

1. Go to **Reports** in the main navigation menu.
2. Locate and open your report.
3. Click **Edit Report**.
4. Search for *Transaction* in the column options.
5. Select **Transaction Number** and **Transaction Type**.
6. Remove any unnecessary columns as needed.
7. After selecting columns to add, click **Apply**. Then rerun the report.
8. In the *Transaction Type* filter, select **Purchase Orders**. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/how-do-i-stop-duplicate-pos-from-inflating-totals-in-my-reports-image-l5rqjv27.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A47%3A20Z&se=2026-10-31T02%3A47%3A20Z&sr=c&sp=r&sig=scKxqMw1rDdjgERz30IMY6mIHhp%2Bgjdn5QxRvJAcuRA%3D)

When the report is run, the Transaction Number column now shows the PO number. Totals are also no longer inflated by bills and receipts, because you're only filtering for purchase orders.

Tips for this report:

- Set your **Date Type/Range** intentionally (broad “All” can pull historic duplicates created by returns/receipts/bills).
- (Optional) Filter **Vendor Name** (e.g., “contains Cool Moon”) or **Project Number**.
- To see payments made on a PO, run the same report again with **Transaction Type = Bills** (and add **Transaction Date** if available). Export both runs to Excel and reconcile by **Project Number** or **Transaction Number**.

### Prevent future inflated totals

- **Never run with Transaction Type = All** when you want PO totals; it pulls POs + Bills + Receipts + Returns → duplicates/quadruples.
- Create **saved views**:
  - “PO Totals” (Transaction Type = Purchase Order)
  - “PO Payments” (Transaction Type = Bills)
- Add **Transaction Number** to both so you can slice by specific POs.

### Get the Service (Customer) Location

- This information is not supported in the *Purchasing & Inventory → Purchasing line items* template.
- **Workaround:**
  - **Use the report drill-down:** In the report, click the **Job/Project number** to open the job; the linked **Service Location** is shown there.