Receipts by Invoice or Vendor

Summary/Use Case

Report Summary

The Receipts by Invoice or Vendor report provides a detailed view of parts receipts, organized by invoice number and vendor. This report helps fleet managers track parts acquisition, ensuring accurate accounting and inventory management for each purchase and vendor transaction.

Use Case

  • Track parts received by invoice or vendor over a specified date range.

  • Monitor vendor activity and ensure compliance with purchase agreements.

  • Verify part costs against invoices for accurate accounting.

  • Identify high-cost items and prioritize inventory spending.

  • Review and reconcile invoice totals for auditing and budget control.

Location: Where to Find It

Reports > RTA Standard Reports > Parts > Receipts by Invoice or Vendor

image-20241111-165304.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.

Data Filter List

image-20241111-165416.png

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Purchase Order Facility

Is Between

1 - 99999

1 to 2

Date Range

Is Between

Any Date Range

1 Month Previous to Current Day

Vendor Range

Is Between

0 to 999999999

0 to 999999999

Invoice Range

Is Between

blank to zzzzzzzzzzzzz

blank to zzzzzzzzzzzzz

Report Output and Data Elements

The Receipts by Invoice or Vendor report displays detailed information about each parts receipt, sorted by invoice number and vendor. Users will see each item’s invoice number, vendor, part number, description, quantity, and individual and total costs, with grand totals for invoice and vendor sections.

Report Output

Report Data Elements

Column Number

Column Title

Data Notes

Column Number

Column Title

Data Notes

1

Invoice #

Unique identifier for each invoice related to the part received.

2

Vendor

Unique identifier for each vendor providing parts.

3

PO-Num

Purchase order number associated with each part receipt.

4

Date

Date the part was received.

5

Part Number

Identification number for each part received.

6

Description

Description of the part received.

7

ST

Status of the part (active, inactive, etc.).

8

Qty

Quantity of the part received.

9

Part-Cost

Cost per unit of the part.

10

Total-Cost

Total cost for each item (quantity multiplied by unit cost).