Notifications
Announcements
No record found.
I got the error when running the Historical Stock Status Report, I've found this article regarding this issue, but couldn't find the table mentioned. Please help.
*This post is locked for comments
This is the link I found
mbs2.microsoft.com/.../KBDisplay.aspx
Anyone can help?
Do you have any characters in your item numbers outside of dashes? Quotes are not a good thing to put in an item number. I have seen them cause issues (more with MRP).
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
I have record this error when a single quote was included in the item number. The screen shot was not readable to me. You might try including only the error message so that it might be clearer.
Kind regards,
Leslie
I had a client with the same problem when printing the IV Lot Number Inquiry report for certain items. The same exact R-TREE error would pop up and GP would close down, regardless of which user on which workstation would try to print it. We finally figured out there was a carriage return at the end of the item description. It couldn't be seen, even in SQL, until we ran an ASCII function on each letter of the description. (We already knew the description was the problem, we just wanted to know exactly what was in there causing such trouble.) The items had been imported long ago and the ASCII character 13 had gotten in there at the end of the description. The fix was to simply delete the description ENTIRELY and re-type it. I know this is old, but I'm posting this reply to help save others some time.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
