RE: Stock count Variance Report -BC
Hi There - By variance I understand it's a difference between what the inventory is seen on the system v/s what you actually have on the shelf.
The process of how one should correctly use Phys Invt Journal to calculate variance is below:
1. Navigate Phys Invt. Journal. Click Calculate Inventory
2. Lines will generate. From actions, print the report and hand it over to the counting personnel. The report has a column which is blank with an underline. It is there so that the personnel who is counting the stock can enter his count
3. The personnel will handover the filled-in sheet to you. Key the values on each line in Phys Invt. Journal with the value present on the sheet (handed over to you by the counting personnel)
4. You can then export the journal out in excel and subtract the 2 columns : Qty Caculated & Qty Phys Inventory, to get the variance number manually
5. Else, you can post these lines from Phys Invt Journal. Navigate to Item Journal and Calculate the adjustment. The item journal will show you the value of the variance directly
