100
Hello,
Does anyone know of a setting, professional services tool mod, or 3rd party product that will allow us to make the Inventory Transaction quantity field only allow negative numbers? The only increases to our inventory will be done through the PO process, so we want to elminate the possibility of someone entering a postive quantity for a decrease transaction. We could probably do it in VBA, but would prefer a fix already done.
Thanks,
Jim
*This post is locked for comments
Good day,
I am also looking at the default value being negative, but as Richard indicated there are scenarios where the positive quantity may be used. That is in creating a kit, I am not sure if it is being dealt with in the correct manner, minus from one number and add to the kit number. I am not familiar with VBA, but can a password be added to this code?
Regards
Rosemary
I understand what you are trying to accomplish but I think you have missed some points. When your inventory values are different from the counts on the warehouse, transactions (increases and decreases) are often used to adjust the inventory. When products are given to a sales rep, a transaction is usually required to reduce inventory, then when the rep returns the item, you must increase inventory.
Are you sure you want to limit these transactions to ONLY negative numbers?
Why not a report or Business Alert or Smart List showing positive transactions to be verified, reviewed?
Hi Jim
You can write a simple VBA customization to prevent a positive quantity entered in the Inventory Transaction window.
You can add the Item Transaction Entry window to VBA and add the Quantity field to VBA and use the following code to restrict a positive quantity from being entered.
Private Sub TRXQTY_BeforeUserChanged(KeepFocus As Boolean, CancelLogic As Boolean)
If TRXQTY.Value > 0 Then
MsgBox "You cannot enter a positive quantity!", vbOKOnly + vbExclamation, "Quantity Error"
KeepFocus = True
CancelLogic = True
End If
End Sub
Hope this helps. Let us know if you need further assistance.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
