ID75

Stale Inventory

Output Type: Email & SSRS Report

This report is meant to identify inventory items that were not used on Service Calls, Sales Orders, Purchase Orders, etc. in the last Variable Y number of days specified and only show items with an average cost exceeding Variable X. The report sends automatically monthly and can also be run on-demand via your CEO Juice SSRS Reports.

This report should be run manually each month for all items/warehouses so you can write-off (devalue) those dead items over your fiscal year instead of taking a big hit at the end of the year. This alert/SSRS Report looks for usage from the specified warehouses selected only (the alert runs for all warehouses by default).

Usage is determined as any of the following transaction types: Sales Invoice, Sales Credit/Debit Memo, Service Invoice, Service Credit Memo, Purchase Order Receipt/Return, Sales Fulfillment, Inventory Assembly or Inventory Refurbishment.

Links

Related Alerts