Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

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

...

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default

)Value (Notes

)

Purchase Order Facility

Is Between

1 - 99999

1 to 2

blank

Date Range

Is Between

Any

date range

10/12/2024 to 11/11/2024

blank

Date Range

1 Month Previous to Current Day

Vendor Range

Is Between

0 to 999999999

0 to 999999999

blank

Invoice Range

Is Between

blank to zzzzzzzzzzzzz

blank to zzzzzzzzzzzzz

blank

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

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).