User Tools

Site Tools


aged_inventory_report

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
aged_inventory_report [2019/04/29 13:49 (5 years ago)] hshockleyaged_inventory_report [2019/04/30 14:29 (5 years ago)] (current) hshockley
Line 1: Line 1:
-**Aged Inventory Report**+====== **Aged Inventory Report** ====== 
  
  
Line 6: Line 7:
    
  
-**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. 
  
  
Line 16: Line 17:
  
 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 35: 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.1556570986.txt.gz · Last modified: 2019/04/29 13:49 (5 years ago) by hshockley