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.