75,730
This very nicely will capture the event of leaving the item number field on the SOP Transaction Entry screen but only for a new record. How do you capture the event when leaving the item number field on an existing record?
SopEntryWindow.LineScroll.ItemNumber.ValidateAfterOriginal += new EventHandler(ItemNumber_Change);
Hi Richard
To prevent access to the field I would use the scrolling window line pre event.
In my script I would lock the field if the item number is not empty.
Regards
David
In this case that is fine. I really only need it to fire when someone leaves the item number field.
Thanks, this may prove useful.
You likely know this but just in case you don't and to save you some future issues, I just wanted to remind you that whatever you code in your ItemNumber_Change sub or function, that code will fire with each and every letter typed in the item number field.
I'm glad you have something working as you need it.
The SopEntryWindow.DisplayExistingRecord.Value will tell you if the document is existing or a new one.
In this case I have an unusual case where the client wants the LOCNCODE to always be their WAREHOUSE regardless of whether the order being entered on the sales order has other locations. They do have the IV00101.ITEMTYPE set to Sales Inventory and want to prevent any user from changing the location to anything else when the type is sales inventory. There is no item type on the SOP Detail Entry screen grid. So I need to query the IV00101 table to get the item type.
I would use caution with the Change Events as they can fire more than once depending upon the field (sometimes with values in them and other times without). When leaving fields I stick with either LeaveBeforeOriginal or LeaveAfterOriginal depending upon whether I want the opportunity to cancel the leave and keep the user in the field until valid values are entered or not.
Anyway, I use an If statement to check the value SopEntryWindow.DisplayExistingRecord.Value, If it's True, then it's an existing record and if False it is a new record.
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 (