Making a physical inventory I’ve detected problem with many of our items that are found in the warehouse and should be reported as new stock where previous level is zero (Calculated Qty = 0).
The problem is, the item is not picked up by the Calculate Inventory batch report, even running it with “Items not on Inventory” tick ON. The items found had no single movement in the past so no journal exist (which is why I think this fails).
So we try adding the line to Physical Inventory Journal and update the Physical Quanity but there comes the error:
“Phys. Inventory must be Yes in Item Journal Line Journal Template Name=“PHYS.INVE”, Journal Batch Name=“DEFAULT”, Line No.=…”
I find this very annoying as I think it is correct to update Inventory using the Inventory journal and to avoid workaround of going through Item Ledger and Positive adjustment.
This link www.mibuso.com/…/viewtopic.php
suggest to use Calculate Inventory where Item No. is specifically enetered and “Items not on Inventory” option selected. This does not work for me, the new line is not added.
So now I know I can make the “Phys Inventory” Boolean fiedl editable and let user set it manualy to pass the check, but this does not “feel” like an elegant solution…
What would be your recomended best way to solve this?