Stock Report
Stock Count
Inventory module> Reports> Reports List
Report displays a list of items which show what quantity is on hand currently and a space where the person counting can indicate the quantity actually counted.
Generally a count is done without giving what the quantity is on hand, however if you want to see the quantity on hand, remove the tick off the option called "Ignore system quantity"
| Code from |
Select the from item in your list, This looks at the code in order to determine the from and to |
| Code To |
Select the to item in your list, From and to is based on code sort |
| Warehouse | Select a specific warehouse for printout |
| WIP (Work in progress) |
Run the count for working progress items, On Shelf, All, Invoice, Sales Orders, Jobs and Bill of Materials. Most counts are done on the on shelf option |
| Sort by | Select a sort option by Code, Description, Group Code or Bin Location |
| Sub sort by | Select a sub sort by Code, Description, Group Code or Bin Location |
| Priority level | Count based on the Priority level of marked items |
| Disable bin range |
Disable bin range is on by default which means the order is by code. Enable this which allows you to print count by bin location from and to |
| Bin location from | Print by bin location from |
| Bin location to | Print by bin location to |
| Show inactive | Show inactive items on printout (Default option is off) |
| Group selection |
Print a selected group selection of your group codes This is defined in the group code setup which allows you to count for specific groups automatically |
| Ignore system Qty |
This option is on by default to ignore the system quantity on report. if you want the system on hand value, remove the tick |
| Decimal places | View up to nine decimals for stock items quantity |
| Ignore if quantity zero | |
| Use group codes |
When selecting this option, group codes will be visible and allow the user to |
| Available group codes | Displays a list of available group codes |
| Selected group codes | Shows the list of selected group codes for the report |
| Show barcode | Show the barcode on the printout |
| Batch number | Display the batch number of the stock item |
| Expiry Date | Display the default expiry date of the item |
Print count with on hand quantity
To print the report with the displayed on hand quantity, remove the tick for "Ignore system quantity" on the criteria
Report with count, showing on hand quantity
Stock Count Sales Analysis
Inventory module> Reports> Reports List
Stock Control Report
Inventory module> Reports> Reports List
This report shows stock values per warehouse and WIP
Stock Count Sales Analysis
Inventory module> Reports> Reports List
| Customer | |
| Sales Rep | |
| Count Date | |
| Last Count Date | |
| Copy Last Count Date |
Stock Control Report
Inventory module> Reports> Reports List
This report shows stock values per warehouse and WIP
Stock Count Sales Analysis
Inventory module> Reports> Reports List
| Customer | |
| Sales Rep | |
| Count Date | |
| Last Count Date | |
| Copy Last Count Date |
Stock Movement Per Month
Inventory> Reports> Report List
| From Year | |
| From Period | |
| Invoice | |
| GRV | |
| Stock Level Adjustment | |
| Other | |
| To Year | |
| To Period | |
| Credit Note | |
| Return to Supplier (RTS) | |
| Stock Take |