The Physical Stock Entry for Warehouse screen allows users to add the actual physical count details of a material available in a particular warehouse.
The following tasks must be completed before the Physical Stock Entry for Warehouse transaction.
The Physical Stock Entry for Warehouse screen allows the user to enter the physical quantity details of a particular item available in the specified warehouse.
Navigation: Main - Menu → Transactions → Inventory → Inventory Entries → Inventory → Show List → Stock → Physical Stock Entry for Warehouse



The Import link allows the user to update the physical stock details for a particular material using Excel.



The Preview option allows the user to view and print the transaction details.


| SL No. | Use Case | Business Scenario | Functional Outcome in ERP |
|---|---|---|---|
| 1 | Physical Stock Entry for Warehouse | Users need to record and validate the actual physical stock available in a particular warehouse by comparing with system stock and rates. | Enables users to accurately record the physical quantity of materials in the warehouse, verify system variation, and update stock rates in ERP accordingly. |
| Steps | Checklist Item | Details / Purpose |
|---|---|---|
| 1 | Prepare stock data in the IcSoft template | Ensure stock count data is collected and formatted correctly. |
| 2 | Upload Excel template | Use the provided template to upload multiple physical stock entries. |
| 3 | Generate Physical to System Variation Report | Identify mismatches between physical and system stock for corrective action. |
| 4 | Verify item rate | Confirm rate reflects the last GRN rate (new rate). |
| 5 | Update rate as per method | Use Weighted Average or FIFO rate as applicable. |
| 6 | Match system and physical stock quantities | Ensure total physical stock matches report totals. |
| 7 | Validate SystemLive column values | Confirm system stock values align with ERP. |
| 8 | Cross-check new rate with valuation method | Verify the new rate as per the Weighted Average or FIFO logic. |
| 9 | Review stock variation with customer/user | Ensure transparency and confirmation of stock differences. |
| 10 | Match and confirm the stock entry date | Ensure transaction date consistency for traceability. |
| 11 | Validate the Batch Number from the system stock | The batch number must exist in the system, not in physical entry. |
| 12 | Check item characteristics in the system stock | Confirm characteristics exist in system before entry. |
| 13 | Enter physical stock details in ERP manually | Input stock data directly via the ERP screen for selected warehouse and material. |
| 14 | Enter Comments and Update Status | Provide relevant remarks for audit and future reference. |
| 15 | Save and confirm the transaction | Completes the entry and updates ERP with physical stock data. |
| 16 | Optional: Use Excel Import | Import stock entries in bulk with field mapping (Sheet Name, Start/End Row, Excel Positions). |