Navigation:  Warehouse Management > Reports >

Stock Statement

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

Main Menu > Warehouse Management  > Reports > Stock Statement

Stock statement or Stock Register shows the summary figures of transaction and stock in hand of all Stock Items.

Buttons in the Stock Statement Report:

Buttons are explained in Using Reports (Register). Buttons specific to “Stock Statement” are discussed here:

F8 Analysis

Press F8 or click this button to see Stock Report in Analysis view from Statement View and vice versa.

-O Option

Press ALT + O or click this button to open Stock Statement option.

Stock Report Option

Valuation Method

Actual Rate: It will valuate on actual rate on whatever selected in valuation rate option MRP, Cost Price or Sale Price.
Average Rate: It will valuate on average rate on whatever selected in valuation method option MRP, Cost Price or Sale Rate.
Last Rate: It will valuate on last rate of purchase/last product child entered in transaction on whatever selected in valuation method option.

Valuation Rate

Cost Price: It will valuate on product cost price.
MRP: It will valuate on product MRP.
Sale Price: It will valuate on product sale price.

Report Type

Analysis: To see report in analytical view.
Statement: To see report in statement view.

Show Stock on Challan Date

Set  “Show Stock on Challan Date = Yes” in the Stock Statement then Purchase Challan date will be treated as actual stock in date else set No then Purchase Invoice date will be treated as actual stock in date. Stock aging will be calculated accordingly.

Stock Ledger Option

Scan Field

Default: Use this if you want the input code to be searched on default i.e. internal Product Code  of  4 or 11 digit or UPC EAN Code.
User Defined Code: It will search the product with User Defined Code.

-U Alt. Qty

Press ALT + U or click this button to see stock report as per Alternate Unit and Quantity.

^U Actual Qty

Press CTRL + U or click this button to see stock report as per Actual Unit and Quantity.

^D Item Det

Press CTRL + D or click this button to see item child wise stock report.

^S Item Summ

Press CTRL + S or click this button to see item wise stock report after summarize child quantity and amount.

^T Transfer

Press CTRL + T or click this button to copy the selected entry row as a whole to Stock Transfer Voucher. This will work only in Item Child Wise Report, if a particular Location and Warehouse is selected. In the following cases the button will not work;

Item Summary Report
Combined Location Report
Combined Warehouse Report

 

Note:

You may select and copy one or more item entry row.

^B Barcode

Press CTRL + B or click this button to print bar-code of selected Item entry row. Number of bar-code print out will be same as item quantity in the selected row. You can select one or more item rows and print them together.  This will work only in Item Child Wise Report.

-A Aging

Press ALT + A or click this button to see stock aging report. It will show the periods since then the items are kept in store/warehouse.

^E Set Age

Press CTRL + E or click this button to set the age or range of period. You can set multiple ranges of periods.

For more detail please visit:

How to see stock age along with amount?

 

Related Faq:

Displaying of Balance Quantity as Cartoons and Pieces together in Stock Statement
How to add 'day of the week' in the sale register?