In my previous post, I talked about a macro that I had created that checked for where pallets were being dropped in the picking area, and about the modifications I made to it.
Today, I think I finally worked out all of the bugs in it, and I have it working now. Instead of it taking about 30 seconds to complete this task as it did with the old methods, it now takes a fraction of a second, and is really reliant only on one AS400 program. This will solve several problems at once (not to mention reducing the AS400's workload).
So far (fingers crossed), it's working beautifully.
Now I just need to get someone to pay me to do this sort of thing full time.... Shyeah, right.