Difference between revisions of "Available Stock Status Report"

From AutoCount Resource Center
Jump to navigation Jump to search
Line 70: Line 70:
  
  
Click on ''Preview''
+
Click on ''<span style=color:red>Preview</span>''
  
  
Line 80: Line 80:
 
'''<u>Stock Status:</u>'''
 
'''<u>Stock Status:</u>'''
  
'''<span style=color:blue>Backorder Level:''' when stock available quantity is < 0</span>
+
'''<span style=color:blue>Backorder Level:''' <span style=color:blue>when stock available quantity is < 0</span>
  
'''<span style=color:blue>Critical Level:''' when stock available quantity is < Min. Qty (Stock Item Maintenance)</span>
+
'''<span style=color:blue>Critical Level:''' <span style=color:blue>when stock available quantity is < Min. Qty (Stock Item Maintenance)</span>
  
'''<span style=color:blue>Reorder Level:''' when stock available quantity is ≥ Min. Qty and < Reorder Level (Stock Item Maintenance)</span>
+
'''<span style=color:blue>Reorder Level:''' <span style=color:blue>when stock available quantity is ≥ Min. Qty and < Reorder Level (Stock Item Maintenance)</span>
  
'''<span style=color:blue>Low Level:''' when stock available quantity is ≥ Reorder Level and < Normal Level (Stock Item Maintenance)</span>
+
'''<span style=color:blue>Low Level:'''<span style=color:blue> when stock available quantity is ≥ Reorder Level and < Normal Level (Stock Item Maintenance)</span>
  
'''<span style=color:blue>Healthy Level:''' when stock available quantity is ≥ Normal Level and < Max. Qty (Stock Item Maintenance)</span>
+
'''<span style=color:blue>Healthy Level:''' <span style=color:blue>when stock available quantity is ≥ Normal Level and < Max. Qty (Stock Item Maintenance)</span>
  
'''<span style=color:blue>High Level:''' when stock available quantity is ≥ Max Qty (Stock Item Maintenance)</span>
+
'''<span style=color:blue>High Level:''' <span style=color:blue>when stock available quantity is ≥ Max Qty (Stock Item Maintenance)</span>
  
  

Revision as of 08:21, 30 March 2018

Available Stock Status Report

This is used to view/print stock status report.

Go to Stock > Stock Status Report


SS1.png


Basic Filter

Stock Item: choose either No filter, Filter by range or Filter by multi-select. For 'Filter by multi-select', you may Press F3 to launch Item Search function.


More Options


Filter Options: Filter 1

Stock Group: choose either No filter, Filter by range or Filter by multi-select

Stock Item Type: choose either No filter, Filter by range or Filter by multi-select

Stock Location: choose either No filter, Filter by range or Filter by multi-select

Item Active Options: define whether to print only active items or include inactive items.

Stock Control Options: define whether to print stock control items or include non-stock control items


Filter Options: Filter 2

Stock Item Brand: choose either No filter, Filter by range or Filter by multi-select

Stock Item Category: choose either No filter, Filter by range or Filter by multi-select

Stock Item Class: choose either No filter, Filter by range or Filter by multi-select


Other Options:

Show By Location: to show location

Show Batch No: to show batch no

Show Outstanding Consignment: to include outstanding consignment transaction

Include Zero Balance: to include zero balance transaction

UOM Options: to show report in Multi-UOM, Default Report UOM or Smallest UOM


Report Options

Group by: choose one of the following options: None, Item Group, Item Type, Item Brand, Item Category or Item Class

Show Criteria in Report: to show selected options in report


Inquiry: to refresh and show the result of filter options and report options.

Preview: to preview report to be printed

Print: to select printer and print report

Hide Options: to hide the Options portion so that the screen has more space for details. Click on Show Options to show it again.

Close: close the screen


Click on Preview


SS2.png


Stock Status:

Backorder Level: when stock available quantity is < 0

Critical Level: when stock available quantity is < Min. Qty (Stock Item Maintenance)

Reorder Level: when stock available quantity is ≥ Min. Qty and < Reorder Level (Stock Item Maintenance)

Low Level: when stock available quantity is ≥ Reorder Level and < Normal Level (Stock Item Maintenance)

Healthy Level: when stock available quantity is ≥ Normal Level and < Max. Qty (Stock Item Maintenance)

High Level: when stock available quantity is ≥ Max Qty (Stock Item Maintenance)


Balance quantity = On Hand quantity, or physical stock quantity.

Available quantity = On Hand quantity - Outstanding S/O quantity + Outstanding PO quantity + Stock Assembly Order quantity (finished goods) - Stock Assembly Order quantity (raw materials)

Available quantity after Consignment = Available quantity - Sales Consignment quantity + Purchase Consignment quantity


Also refer to: Other Options in Stock Status