Stock reports
You will know where to read quantity on hand by product and warehouse, how the Qty Alert reorder flag works, how to export the report to Excel for a count sheet, and which other screens show stock.
The Stock Report under Reports › Transport is the inventory position: every product with Enable Stock Posting, its quantity on hand in each warehouse and in total, valued at its rate. It is the report to print before a physical count and to check after every purchase invoice or stock adjustment.
Stock figures also appear in smaller places across the app, listed below, so you rarely have to open the report just to see one item.
Stock Report columns
Column | What it shows |
|---|---|
Code | The product code |
Product | The product name |
Category / Brand | From the product’s Classification, for grouping and filtering |
Unit | The unit quantities are counted in |
Warehouse | The location, when the report is split by warehouse |
Qty | Quantity on hand: purchases plus adjustments in, minus adjustments out and issues |
Rate | The product’s Purchase Rate or last purchase rate |
Value | Qty × Rate |
Qty Alert | The reorder level set on the product; rows at or below it are flagged |
Filters and export
- Filter by Warehouse to see one location, or leave it open for the total across all.
- Filter by Category or Brand to count one shelf or one supplier’s range at a time.
- Use Excel to export the report. The exported sheet makes a count sheet: add a Counted column, fill it in the store, and the differences become your Stock Adjustment lines.
- Use print for a paper copy to walk the store with.
Qty Alert
Qty Alert is set per product under Purchase Info. When quantity on hand falls to or below it, the Stock Report flags the row. There is no separate reorder screen; the practice is to filter the report to flagged rows at the end of each week and raise purchase orders from Bookings › Quotes & Orders › Purchase Order or buy directly and receive on a purchase invoice.
Other places stock appears
Screen | What you see |
|---|---|
Purchase Invoice line | Stock column shows the quantity on hand of the product before this line |
Stock Adjustment line | Stock column shows the current quantity in the chosen warehouse |
Purchase Invoice list | Warehouse column shows where each delivery was received |
Products list | Purchase Rate and Sales Rate per product, not quantity |
Vehicles › Tyre/Asset Tracking | Serialised items by Status: In Store or Installed, which is the stock view for tyres and batteries |
Balance Sheet | Stock value as one figure under current assets |
Checking the report after a movement
- Note the Qty of the product before you save the purchase invoice, adjustment or service.
- Save the voucher.
- Reopen the Stock Report for the same warehouse; the Qty should have moved by exactly the line quantity.
- If it has not, check that the product has Enable Stock Posting on and that the voucher named the warehouse you are looking at.
Need Help?
Chat with the NShine ERP support team on WhatsApp at +91 79950 87755, or ask from inside the app. Last checked 9 November 2026 against app.nshineerp.com.