PO Received Transactions

Summary/Use Case

Report Summary

The PO Received Transactions report lists part receipt activity from purchase orders, grouped by your chosen primary field (Date, Part, PO Number, or Vendor). Fleet managers can use it to reconcile receipts against invoices/POs, analyze landing costs (part cost + freight + tax), and validate vendor activity by facility.

Use Case

  • Reconcile AP invoices and PO receipts by vendor and date

  • Audit that all items on open POs were actually received and posted

  • Review landed cost components (part cost, freight, tax) to spot anomalies

  • Summarize receipts by part to identify top purchased items over a period

Location: Where to Find It

Reports > RTA Standard Reports > Purchase Orders > PO Received Transactions

image-20251218-135302.png

Data Filter Prompts

You will be prompted for filtering of the Data to specify and narrow down the data that will be pulled. See Data Filter List Below for Options

Parameter List

image-20251218-135356.png

Parameter Name

Value (Default)

Value (Notes)

Please select Date, Part, PO Number, or Vendor for primary grouping

Date

Determines the first-level grouping of results. Options: Date, Part, PO Number, Vendor.

Data Filter List

image-20251218-135431.png

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Value (Notes)

Facility

Is Between

Low: 1; High: 99999

Low: 1; High: 99999

Use a single facility or a range; current default spans all.

Transaction Date

Greater Than Or Equal To

Any valid date

60 Days Ago

Start date of receipts included.

Parts

Is Between

Low: blank; High: zzzzzzzzzzzz

Low: blank; High: zzzzzzzzzzzz

blank and “zzzz…” represent the first and last possible values for this field (full range).

PO Number

Is Between

Low: 0000000000; High: 9999999999

Low: 0000000000; High: 9999999999

Full numeric PO range.

Vendor

Is Between

Low: blank; High: zzzzzzzzzzzzzzzz

Low: blank; High: zzzzzzzzzzzzzzzz

blank and “zzzz…” represent the first and last possible values for this field (full range).

Report Output and Data Elements

Report Output

The PO Received Transactions report shows each receipt line with date, part, PO number, whether the line is marked received, related WO/line (if applicable), invoice number, account, quantity, and cost components (part cost, freight, tax) with an extended total. Results are grouped by your selected parameter (default: Date) and by Vendor within Facility. Vendor and/or facility subtotals are provided, including totals of Qty, Part Cost, Freight, Tax, and Total.

image-20251218-135705.png

Report Data Elements

Column Number

Column Title

Data Notes (the purpose of that datapoint)

1

Date

Receipt posting date

2

Part

Part number received

3

PO Number

Purchase order associated with the receipt

4

Rcvd?

Indicates whether the PO line is flagged as fully received (Y/N)

5

WO # (Ln)

Work order and line tied to the receipt, when applicable

6

Invoice #

Vendor invoice reference used for AP reconciliation

7

Account

GL/account or charge code applied to the receipt

8

Qty

Quantity received on that transaction line

9

Part Cost

Extended cost of parts only (Qty × unit cost)

10

Freight

Freight cost applied to the receipt line

11

Tax

Tax applied to the receipt line

12

Total

Landed cost for the line (Part Cost + Freight + Tax)