This custom report ages your inventory by warehouse using the date the items were received in that warehouse (see days in stock).
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters | Best Practices & Tips | Related Alerts |
Overview
Overview
This custom report ages your warehouse by using the date the items were received into that warehouse. The cost is pulled from the cost pools associated with the item/warehouse.
Run Schedule:
Type of Output: On-Demand Crystal Report
* * *
Sample
Sample
Shows the value of the item based on total quantity as well as % of this item in this warehouse compared. This percentage can be used when trying to balance out or see at a glance % of specific items spread % throughout warehouses.
Includes serial number information as well as whether hosting item.
* * *
Variables
Variables
This alert has no variables.
* * *
Alert Functionality
Alert Functionality
1. This custom report ages your warehouse using the date the items were received into that warehouse. The cost is pulled from the cost pools associated with the item/warehouse.
2. The report shows the value of the item based on the total quantity, as well as the percentage of the item in the warehouse. This percentage can be used when trying to balance out, or see at a glance, the percentage of specific items spread throughout the warehouses.
3. The report includes the serial number information as well as whether the item is a host
4. You can select whether to show In Stock or Available (On Hand) quantity. In Stock is everything not billed (regardless of whether on order or service call not yet invoiced). Available is everything not already billed for or listed on an unbilled sales order or service
* * *
OnDemand Report Filters
OnDemand Report Filters
Various filters are available with advanced filter options:
You can select whether to show In Stock or Available (On Hand) quantity. In Stock is everything not billed (regardless of whether on order or service call not yet invoiced). Available is everything not already billed for or listed on an unbilled sales order or service call:
* * *
Best Practices & Tips
Best Practices & Tips
For more information on how to handle dead inventory, see this post on best practices.
* * *
Related Alerts
Related Alerts
ID75 - Dead Inventory Report
ID694 - Tech Stale Inventory Items
ID772 - Inventory Management Power BI
* * *
0 Comments