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