75,730
If I go to Purchasing Batches and type CG and then lookup it should go to the first batch that starts with CG. It does not it goes to the first batch that starts with N.
However if I type CG0610221358 then all the CG batches show up. Something is wrong here. I suspect the index on the SY00500 table may be corrupt. Has anyone else seen this? If I run a similar query using SSMS it finds the first batch that begins with CG.
Beat, this was the same case where the client had 20,000 records in the SY00500 table. I was able to prune it down to about 1,000. A SQL trace is a good idea.
Richard,
The last reply was a missed spam post, which got posted twice. I reported and banned the user.
As for your problem, can you find out if this window is the original form or modified ? is there any code hidden behind it ? what if you change the lookup security from the SL type lookup to the original GP lookup ? does it still fail ?
Have you tried to run a SQL trace from the back-end to see what code is actually run ? could it be that there are simply too many batches in the table and GP stops processing..
Printing the edit list is not the problem. Why if I type in CG and then hit the lookup it does not go to the first batch that starts with CG? However if I type in the full batch name and then hit the look up it will land on the correct batch. Plus if I remain on the screen and type CG again and lookup it will go to the first batch that starts with CG. If I leave the screen and come back the lookup will again fail.
Go to Transaction-->Purchasing-->Purchasing Batches. 2. Select the Batch ID and click print button from right top corner to print the batch edit list.
This is one of those clients that keeps you up at night. They ask for advice, you give it to them and then they proceed to ignore it. I have told them no more. I have written a series of scripts per module that looks at all the open transaction tables. If no records are found that record in the SY00500 gets deleted. For the SOP series there are 12,891 records in the SY00500 that have no records in the SOP10100 table.
16k rows in the SY00500 table !!!???
someone clearly didn't understand the purpose of the system batch table... it's not meant to keep a history of all the possible used batches..
Empty batches should just be deleted. You may run into a query issue here.. not so much about indexing.. You can try to rebuild the index on just that table, but I doubt it will resolve the problem.
There is no Rocton SmartFill here. It actually behaves the same way in our copy of their data. I reset the Auto Complete and the problem remains. Here is an oddity. I go to the Batch Entry window and enter the complete batch ID and click lookup. It will find the first batch that begins with CG. This will continue to work until I close the Batch Entry window. Once the window is reopened I need to enter a full batch ID. This client refuses to delete empty batches. Over 20 years of posting there are over 16,000 records in the SY00500 table.
Richard,
Do you have an add-on installed like Rockton SmartFill ?
The tool is very powerful, but one of the main drawback of it is that it does the lookup on multiple fields, not just the one you're typing something in... which means that if there is another unique record that matches CG, it will pull this one in first. I've seen this many times and it drives users crazy, as they want to add a new customer card, but can't because SmartFill returns a unique default record matching the criteria, but from another field.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (