Part Audit Trail Report

This report prints sales, receipts, and adjustments for every part number. This report when printed to the screen acts as a drill down report. You can double-click on part number to get more specific details such as repair order and purchase order numbers and dates.

Available Options:

• 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

The Summary report includes the following information:

Column	Description
Part Number
Line	Line Code
Adjustments	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

Drilldown Report

Selecting a part number will open up the view in a new tab. Click the Main Report button to view the summary report and select another part number.

The Detail report for a specific part number when double clicked on includes the following information:

Column	Description
Part Number
Line	Line Code
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	using the Adjustments feature in Inventory
Adjust Reason	When using the Adjustments feature
Date	Repair Order Close Date
Cost	Parts Cost (Average Cost)
Retail	Retail Price
Adjust	The quantity adjusted
Adj. Cost	Adjust * Cost
Adj. Price	Adjust * Price