The Part Audit Trail Report prints sales, receipts, and adjustments for every part number.
If you print this report to the screen, you can double-click on part numbers to drilldown to the part details such as repair order and purchase order numbers and dates.
Report Criteria
You can select the following report criteria:
- Department Group
- Department
- Supplier
- Sort Order: Part No, Alternate Number, Description, Line Code
- Group On: No Grouping, Supplier, Department, Location, Line Code
- Line Code: A specific line code can be entered
- Parts marked for stocking
- Parts marked for non-stocking
- Parts marked for consigned
- Do not consider On Hands
- Parts that are On Hand
- Parts with no On Hand
Report Sample
The Part Audit Trail Report does not group parts by any category. Each row is a part that matches the search criteria.
Report Information
| Column | Description |
|---|---|
| Part Number | |
| Line | |
|
|
Quantity Adjusted using the Adjustments feature in Inventory |
| P.O. Receipts & Transfers | Quantity received on a Purchase Order or the quantity transferred in or out on a Parts Transfer |
| Receipts | Quantity received using Post Receipts or AP Detail Post to Inventory |
| R.O. Sales | Quantity sold on repair orders |
| Total In/Out | Total Quantity adjusted |
| Total Cost | Total In/Out * Part Cost |
| Total Price | Total In/Out * Retail Price |
Drilling Down by Part Number
Double-clicking a part number on the Part Audit Trail Report opens the drilldown toolbar with the part number selected. The report on the window shows all activity for that part number.
Click the Main Report button in the drilldown toolbar to see the main summary report and click another part number.
Report for One Part Number
| Column | Description |
|---|---|
| Part Number | |
| Line | |
| Adjustment Type | |
| R.O. # | Sold on a repair order |
| P.O. # | Received on a purchase order or Transfer |
| Receipt | Received using Post Receipts or AP Detail Post to Inventory |
| Adjustment | Adjustment quantity |
| Adjust Reason | Adjustment reason selected |
| Date | Close Date of the repair order |
| Cost | Parts Cost (Average Cost) |
| Retail | Retail Price |
| Adjust | The quantity adjusted |
| Adj. Cost | Adjust * Cost |
| Adj. Price | Adjust * Price |