Skip to main content

Stock Report

Stock Count

Inventory module> Reports> Reports List{{@270}}

ReportOriginal displaysContent aClick 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"

image.pngHere

Original

ContentClick
Code from

Select the from item in your list, 

This looks at the code in order to determine the from and to{{@135}}

CodeHere

To

Select the to item in your list, 

From and to is based on code sort

WarehouseSelect 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.{{@142}}

MostOriginal countsContent areClick done on the on shelf option

Sort bySelect a sort option by Code, Description, Group Code or Bin Location
Sub sort bySelect a sub sort by Code, Description, Group Code or Bin Location
Priority levelCount 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.Here

Enable this which allows you to print count by bin location from and to

Bin location fromPrint by bin location from
Bin location toPrint by bin location to
Show inactiveShow inactive items on printout (Default option is off)
Group selection

Print a selected group selection of your group codes{{@1412}}

ThisOriginal isContent definedClick in the group code setup which allows you to count for specific groups automaticallyHere

Ignore system Qty

This option is on by default to ignore the system quantity on report.{{@151}}

ifOriginal youContent wantClick the system on hand value, remove the tickHere

Decimal placesView 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
manipulate them by using the arrows for selection

Available group codesDisplays a list of available group codes
Selected group codesShows the list of selected group codes for the report
Show barcodeShow the barcode on the printout
Batch numberDisplay the batch number of the stock item
Expiry DateDisplay 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

image.png

Report with count, showing on hand quantity

image.png


Stock Count Sales Analysis


Inventory module> Reports> Reports List

image.png

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 

 

image.png


Stock Count Sales Analysis


Inventory module> Reports> Reports List

image.png

Customer 
Sales Rep
Count Date
Last Count Date
Copy Last Count Date 


Stock Movement Per Month


Inventory> Reports> Report List

image.png

From Year 
From Period
Invoice
GRV
Stock Level Adjustment
Other
To Year
To Period
Credit Note
Return to Supplier (RTS)
Stock Take