Do Not Allow Physical Quantity Editing in Grid.
YouTube: How to Disable Quantity Editing in the Grid in Physical Stock Verification (PUV)?
How to Disable Quantity Editing in the Grid in Physical Stock Verification (PUV) ?
In this tutorial, we will learn how to use the "Do Not Allow Physical Quantity Editing in Grid" feature in the Physical Stock Verification of Purchase Voucher module. This feature prevents users from manually editing the Physical Quantity field in the verification grid, ensuring that stock quantities are updated only through barcode scanning or the designated verification process.
Objective of This Feature
Prevent manual editing of physical quantities.
Ensure stock verification is performed through barcode scanning.
Improve inventory accuracy.
Minimize manual entry errors.
Maintain reliable physical stock verification records.
Access to the Physical Stock Verification Configuration
Open the Physical Stock Verification of Purchase Voucher module.
Click on Configuration.
Locate the option labeled as:
"Do Not Allow Physical Quantity Editing in Grid"
Enabling this option locks the Physical Quantity field and prevents manual modifications within the grid.
Observe the Default Behavior
Before enabling the feature, let's review the default behavior.
Action
Select the required Voucher Type.
Choose the Purchase Voucher for physical stock verification.
Scan the item barcode or enter the physical quantities.
Observation
The system allows physical quantities to be updated in two ways:
By scanning the item barcode.
By manually entering or modifying the value directly in the Physical Quantity grid.
Since the feature is disabled, the Physical Quantity field remains fully editable.
Now, let's observe the behavior after enabling the feature.
Return to the Configuration window.
Enable the option: "Do Not Allow Physical Quantity Editing in Grid"
Save the configuration.
Observe the Functionality
Manual Entry Test: Try entering or modifying the Physical Quantity directly in the grid.
Result: The Physical Quantity field is now locked and does not allow manual editing.
Barcode Scanning Test: Scan the item barcode to update the physical quantity.
After scanning, try modifying the updated value directly in the grid.
Result
The physical quantity is updated successfully through barcode scanning. However, the system does not allow any manual modification of the scanned quantity in the grid.
Key Benefits
Prevents unauthorized manual quantity changes.
Ensures stock verification is performed through barcode scanning.
Improves the accuracy of physical stock verification.
Reduces data entry errors.
Enhances inventory control and audit reliability.
Best Practice Tips
Enable this feature when barcode-based stock verification is part of your standard workflow.
Ensure barcode scanners are properly configured before beginning physical verification.
Use manual editing only when business processes specifically require it.
Regularly review verification records to ensure accurate inventory reconciliation.
Final Outcome
When "Do Not Allow Physical Quantity Editing in Grid" is enabled, Logic ERP locks the Physical Quantity field during Purchase Voucher Physical Stock Verification. Quantities can still be updated through barcode scanning, but users cannot manually edit them in the grid, ensuring a more accurate, secure, and controlled stock verification process.
Last updated