2,040
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
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.
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
Anyone can help?
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,309
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
