Hello, ive found a bug in sugarcrm, well not a bug but a workflow error i guess.
i got an issue with the following:
i created an account and on the account overview page i had sub-panel for quotes.
i have multiple quotes per opportunity so that i can track how negotiations go(price 1, price2...final agreement)
i wanted to be able to sort quotes by opportunity name so if i have multiple opportunities with multiple quotes i can clearly see how each one goes.
first issue: sugarCRM failed to display opportunity name per quote on the account overview page!
can you please give me clue how to do that!
second issue and here is the real show-stopper problem i found:
i got the column opportunity name in the sub-panel Quotes, and even no info inside because of the issue one, i've clicked on sort by name.
after finally giving up on my desired idea for viewing opp. names i removed that column from the Sugar Studio. and the i got FATAL ERROR when trying to view the account overview page.
this was due to the saved ordering and "ORDER BY opportunity_name" left in the query from before removing that column. finally i figured that out and created a new dummy account with no opportunities and quotes and clicked on order by something else in the quote sub-panel so that i can reset that "ORDER BY opportunity_name" chunk from the query.
I propose a fix to the sugarCRM. if you remove a column in the Sugar Studio. you gotta check if that field is still in use for other queries. that would fix the issue that probably somebody else will have in the future.

Sorry i got too detailed on the explanation but i want to help improve the software.

and please if you could tell me how to get opp. name per quote that would be great also. tnx