![johndanter](/community/data/avatars/m/11/11172.jpg?1590187253)
johndanter
Legendary Poster
Hi folks
I've been asked to look at a way of ensuring values entered to LOTN are always numeric....without modifying JDE E1 objects
So they must have values 0 - 9.
The reason I've been asked is there are some weird LOTNs on our system that contain special chars, like # ~ { etc.
We think they came from an import during copy and paste.
I am playing with DD items, using the following in the Edit Rule tab
Range 0 -9 - fails if left blank so I may need to add ' ' and doesn't always work anyway
Value, but this only works Y N 1 0. I'd love to know how to change this, seems to look at F9201.FROER1
My own BSFN but I am at a loss to see how the values are passed like AN8 calls IsColumnInAddressBook. this works magically wherever you have an AN8, so is something I want to replicate.
Seems to use this BF szBEHAVIOR_EDIT_STRING [BHVREDTST]
Any ideas please? Other than modding the input screen
Thanks
John
I've been asked to look at a way of ensuring values entered to LOTN are always numeric....without modifying JDE E1 objects
So they must have values 0 - 9.
The reason I've been asked is there are some weird LOTNs on our system that contain special chars, like # ~ { etc.
We think they came from an import during copy and paste.
I am playing with DD items, using the following in the Edit Rule tab
Range 0 -9 - fails if left blank so I may need to add ' ' and doesn't always work anyway
Value, but this only works Y N 1 0. I'd love to know how to change this, seems to look at F9201.FROER1
My own BSFN but I am at a loss to see how the values are passed like AN8 calls IsColumnInAddressBook. this works magically wherever you have an AN8, so is something I want to replicate.
Seems to use this BF szBEHAVIOR_EDIT_STRING [BHVREDTST]
Any ideas please? Other than modding the input screen
Thanks
John
Last edited: