325
This Lock items during count parameter doesn't actually lock anything on our system, everyone is still able to; post, update and transfer items when the items are in a counting Journal. Is there another setting that has to be enabled for his function to work ?
*This post is locked for comments
Hi,
We have tomorrow counting of stock. Does this parameter lock all inventory transactions except the counting journal itself? The parameter is off and the counting journal already created.
J.
" Go to Inventory Management > Parameters > General
In the counting you must have the "Lock items during count" checked."
Go to Inventory Management > Parameters > General
In the counting you must have the "Lock items during count" checked.
When a line in the invent journal trans table is inserted (the counting journal), a line is created in the table InventItemLocationCountingStatus. This table checks if for an item / dimensions the counting is active. For this functionality to work it is necessary that a record in the InventItemLocation table exists, which is created during the creation of an item or when you assign an inventory location for the specified item. The last option works best because you specify exactly that a specific location for an item is blocked.
Can you check in your case if a record exists in the mentioned table? You can also check this by going to the item master and select warehouse items from the inventory tab. In the form that opens on the general tabpage you will find a checkbox indicating if counting is started.
If you find the checkbox checked (or a record in the table mentioned) you know that the counting is started and inventory movements on that specific inventory location should not be possible.
Hope this helps. If you have checked this and it is still not working, please let me know.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (