Report Part Activity Report

This report prints a report that shows the activity history for a part or all parts, as well as which user performed the activity. Note: UOM changes only show correctly when all Location Groups are selected.

The Modify Report button allows the following report filters to be customized:

OPTIONAL TAB

Date Range - Enter the desired dates to see activity for. The date range looks at the EventDate on the INVENTORYLOG table in the database, meaning the date the transaction happened.
Group By - Select whether to group the report information by Location Group or by Part Number.
Order By - Select whether to order the report information by Order of Events or Event Date.
User - Select a user to see transactions for. Leave this field blank to run for all users.
Location Group - Choose a specific location group to run the report for. Leave this field blank to run for all location groups.
Location - Choose a location to run the report for. Leave this field blank to run for all parts.
Part Number - Choose a part number to run the report for. Leave this field blank to run for all parts.
Tag Number - Enter a specific tag number to see activity for. Leave this field blank to run for all tags.
Tracking Info - Enter a specific tracking number (serial #, lot #, etc.) to see activity for. Leave this field blank to run for all tracking.
Adj Decrease - Choose to show/hide cycle count transactions that decreased quantity by checking/unchecking this checkbox.
Adj Increase - Choose to show/hide cycle count transactions that increased quantity by checking/unchecking this checkbox.
Adj Scrap - Choose to show/hide scrap inventory transactions by checking/unchecking this checkbox.
Adj Tracking - Choose to show/hide part tracking adjustments (for example, changing a Lot # from 5 to 6) by checking/unchecking this checkbox.
Adj UOM - Choose to show/hide UOM changes on parts by checking/unchecking this checkbox.
Adjust - Choose to show/hide transactions of changing the location group assigned on a specific location by checking/unchecking this checkbox.
Consume - Choose to show/hide transactions of raw good consumption on a work order by checking/unchecking this checkbox.
Disable Tracking - Choose to show/hide disable part tracking transactions by checking/unchecking this checkbox. Only shows on the report if the part has inventory quantity.
Enable Tracking - Choose to show/hide enable part tracking transactions by checking/unchecking this checkbox. Only shows on the report if the part has inventory quantity.
Receiving - Choose to show/hide purchase order receipt transactions by checking/unchecking this checkbox.
Shipping - Choose to show/hide sales order ship transactions by checking/unchecking this checkbox.
Show Active - Choose to show/hide parts that have an Active status by checking/unchecking this checkbox.
Show Inactive - Choose to show/hide parts that have an Inactive status by checking/unchecking this checkbox.
Transfer - Choose to show/hide inventory move transactions from the Consignment module with "Transfer" selected as the type by checking/unchecking this checkbox.
Void Receipt - Choose to show/hide void receipt transactions by checking/unchecking this checkbox.
Yield - Choose to show/hide inventory move transactions from the Inventory module by checking/unchecking this checkbox. If Yield shows Yield S50004 this means the items were moved by the picking transaction.
Format Report for Exporting - Removes the page breaks and displays the report on one long page for exporting to CSV, Excel, and other formats.

PRINTER TAB - Allows a default printer to be specified for the report in each location group.