Announcements
Hi
In our Sl2011 FP1 the Sales Order form (40.100) is elongated to the right with a lot of empty space beyond the data area. If we attempt to resize the screen the entire data port moves to the left so that there is always that empty space. I can not seem to change this in customization mode
Are others seeing this too? Can this be changed?
Thank you
Tom D
*This post is locked for comments
Thank you Butch and Cindy and Rick... Please excuse my delay in responding I have been out a bit but I really really appreciate your responses. I took Butch's path and was able to determine that it is a customization issue and now I will follow Cindy and Rick's suggestion and seek it out as we have the SL7 system still running.
Thank you all very much
Tom
There is another route you can take if you are comfortable running the SQL Management Studio and executing some queries. It sounds like the problem might be limited to one user who has, at one point in time, pulled the right edge of the screen over to the right and then did a save upon exit. If you open up SQL Management Studio (assuming you have rights to that), select the system database and execute the following query
select * from customvba where screened = '4010000' and entityid = the user id having the issue
if the query returns any rows then you know this user has some personal customizations. I would then suggest the following query
update customvba set entityid = the user id plus another character where screened = '4010000' and entityid = the user id (for example, if the user is John then set entityid to johnx
This will, temporarily, remove that customizations from this user. have the user open the screen again and see if the problem went away. If it did, I would suggest you execute the following query
delete from customvba where entityid = 'johnx' (or whatever you used above) and then, if that user needs some personal customizations, do those over again. this approach saves the customizations to that screen for all the other users.
If the renaming of the entityid does not solve the issue you can always run another update query to change the entityid back to the original user id.
The other thing you might try is to export the customizations from the version 7 screen, delete them from SL2011, and reimport.
If you double click "Self" in the status bar in SL and change it to standard in the dialog that comes up, you will get the same effect.
If things look good after that, you know you have a customization that didn't make the upgrade. I would plan on recreating the customizations by hand. You can burn a lot of time fiddling with it.
One last thing you can try is to export the customization from your V7 db if it is up and running and importing into the v2011 one.
Hi Cindy
Thank you very much for the feedback. There are multiple customizations for the screen , some are all users and some user specific... it does seem that all users see the elongated screen though. I don't know if this helps but as I mentioned to Butch this is a migration from SLV7 to Sl2011 and it does not happen in SLV7
Tom
Hi Butch
I thought that I could do it via the form gui but I did not go the route of manually deleting the records (being somewhat new to SL there is just so much that I don't know ...sorry). If i wanted to test could I copy the records, then delete them and test... and if need be just import them back into CustomVBA to restore everything?
I should mention that this is a migration from SL V7 to SL2011 and it looks ok in V7.
Thanks again Butch
Tom, I have a client with lots of customizations on this screen and do not have this issue. Have you looked to make sure there are not multiple customizations (e.g., a self, and an all users)?
How did you do that? Did you delete the records related to the screen from CustomVBA
HI Butch
Thanks for the reply.... I tried that but it did not work.. the screen is still elongated
Tom
Sometimes it is just easier to clear any customizations and start from scratch when it starts doing strange stuff like that.
#1
Community Member
136
#2
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
#3
REUser
8
Share
Report
All responses (
Answers (
