User Tools

Site Tools


aged_inventory_report

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
aged_inventory_report [2019/04/29 13:49 (5 years ago)] – created hshockleyaged_inventory_report [2019/04/30 14:29 (5 years ago)] (current) hshockley
Line 1: Line 1:
-**Aged Inventory Report**+====== **Aged Inventory Report** ======
  
-Preconditions:  Available in most versions of System 5. + 
 + 
 +** 
 +Preconditions:**  Available in most versions of System 5. 
    
  
-Use Case: As a User I need to analyze the aging value of my inventory so I can proactively clear out low performing stock before it devalues or simply so that I can free up that value to purchasing higher performing stock. +**Use Case:** As a User I need to analyze the aging value of my inventory so I can proactively clear out low performing stock before it devalues or simply so that I can free up that value to purchase higher performing stock. 
  
  
-Summary: This report is created via our design inventory report, and can be saved for repeated use.+**Summary:** This report is created via our design inventory report, and can be saved for repeated use.
  
  
-Steps to recreate:+** 
 +Steps to recreate:**
  
 1.  From navigator.  Reports > Inventory Reports > Design Inventory Reports  1.  From navigator.  Reports > Inventory Reports > Design Inventory Reports 
 +
 2.  Input name in “Report Name” Field pictured below 2.  Input name in “Report Name” Field pictured below
  
-{{:aged_inventory_step_2.png?nolink&400|}}+{{:aged_inventory_step_2.png?nolink&600|}}
  
    
 3.  Apply selections for Category, supplier, Brand, filter, and options as needed for further customization for client. 3.  Apply selections for Category, supplier, Brand, filter, and options as needed for further customization for client.
 +
 4.  In Column tab chose identifiers for inventory as pictured below. For this example, selected is category, part number, description, and supplier.  4.  In Column tab chose identifiers for inventory as pictured below. For this example, selected is category, part number, description, and supplier. 
 +
 5.  To apply the aged values, select columns for “Stock age”. Each “Stock age title” represents a value range that can be applied for the report.  Adding “Stock age”, will also add an additional tab for “Stock age” where the details will be input.  5.  To apply the aged values, select columns for “Stock age”. Each “Stock age title” represents a value range that can be applied for the report.  Adding “Stock age”, will also add an additional tab for “Stock age” where the details will be input. 
    
-{{::aged_inventory_step_5.png?nolink&400|}}+{{::aged_inventory_step_5.png?nolink&600|}}
  
 6.  Select the “Stock age” tab and input the day range for each “Stock age” column as desired.  6.  Select the “Stock age” tab and input the day range for each “Stock age” column as desired. 
    
-{{::aged_inventory_step_6.png?nolink&400|}}+{{::aged_inventory_step_6.png?nolink&600|}}
  
 7.  Save 7.  Save
Line 32: Line 39:
 8.  Note saved Inventory Reports designed can be accessed via Inventory reports > Print Inventory Reports 8.  Note saved Inventory Reports designed can be accessed via Inventory reports > Print Inventory Reports
  
- {{::aged_inventory_step_8.png?nolink&400|}}+ {{::aged_inventory_step_8.png?nolink&600|}}
  
aged_inventory_report.1556570957.txt.gz · Last modified: 2019/04/29 13:49 (5 years ago) by hshockley