Modify drop-list of SUGAR on Revenu Line item

Hello,

I need to know if it is possible to add a new choice in the "sales_stage_dom" drop-down list, and another one in the sales_probability_dom on the "Revenu line item" module.

Because, we can't create a new Opportunity and revenu line items anymore since i modified theses drop-down liste :
- Sales_stage_dom
- sales_probability_dom

The changes in orange i made in our instance Sugar : 

Sales_stage_dom Clé[libellé]

sales_probability_dom Clé[libellé]

Stand by[Standby]

Standby[10%]

Prospection[Prospection]

Prospecting[10% 25%]

Proposal / Price Quote[Devis/proposition]

Negoctiation/Review[65% 75% ]

Negociation / Review[StandbyEtude]

Proposal/Price Quote[80% 50%]

Close Won[Gagné]

Closed Won[100%]

Close Lost[Perdu]

Closed Lost[0%]



Here is the screenshot when I try to create : 


Here is the message d'error :  


The others users have the same problem as me.

I downloaded the sugarcrm.log, i've founded this :
Mon Dec 9 10:01:23 2024 [3890][be7d586d-bf9e-4d76-ad5e-0807bb33db13][FATAL] An exception occurred while executing a query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') THEN 1 ELSE 0 END is_closed FROM revenue_line_items LEFT JOIN revenue_line_ite' at line 1; Query: SELECT revenue_line_items.service_start_date, CASE WHEN sales_stage IN () THEN 1 ELSE 0 END is_closed FROM revenue_line_items LEFT JOIN revenue_line_items_cstm revenue_line_items_cstm ON revenue_line_items_cstm.id_c = revenue_line_items.id WHERE (( revenue_line_items.team_set_id IN (select /*+ SUBQUERY(MATERIALIZATION) */ tst.team_set_id from team_sets_teams tst
INNER JOIN team_memberships team_membershipsrevenue_line_items ON tst.team_id = team_membershipsrevenue_line_items.team_id
AND team_membershipsrevenue_line_items.user_id = 'be7d586d-bf9e-4d76-ad5e-0807bb33db13'
AND team_membershipsrevenue_line_items.deleted = 0) ) AND ((revenue_line_items.opportunity_id = ?) AND (revenue_line_items.service = ?) AND (revenue_line_items.sales_stage IS NULL OR revenue_line_items.sales_stage NOT IN (NULL)))) AND (revenue_line_items.deleted = ?) ORDER BY is_closed ASC, revenue_line_items.service_start_date ASC LIMIT 1; Params: array (
0 => '8bca9c60-b614-11ef-8bfd-9d219e74a29c',
1 => 1,
2 => 0,
)

Can you have me to resolve the problem please ? Without this, we can't continue to create news opportunities yet.

Many thanks, 

Best regards, 

Phuong

Parents Reply Children
  • The new message SQL error when i've tried to create recently : 

    Mon Dec 9 16:21:48 2024

    [2236][edfc65e7-94e4-4fde-88b1-9cf19a3d2e01][FATAL] An exception occurred while executing a query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') THEN 1 ELSE 0 END is_closed FROM revenue_line_items LEFT JOIN revenue_line_ite' at line 1; Query: SELECT revenue_line_items.service_start_date, CASE WHEN sales_stage IN () THEN 1 ELSE 0 END is_closed FROM revenue_line_items LEFT JOIN revenue_line_items_cstm revenue_line_items_cstm ON revenue_line_items_cstm.id_c = revenue_line_items.id WHERE ((revenue_line_items.opportunity_id = ?) AND (revenue_line_items.service = ?) AND (revenue_line_items.sales_stage IS NULL OR revenue_line_items.sales_stage NOT IN (NULL))) AND (revenue_line_items.deleted = ?) ORDER BY is_closed ASC, revenue_line_items.service_start_date ASC LIMIT 1; Params: array (
    0 => 'b073a252-b649-11ef-a493-0254ccb004a7',
    1 => 1,
    2 => 0,
    )

  • Hi  ,

    For some reason, all of your statuses are classified as 'Open' (Ouvert) statuses. Click on the pencil icon for 'Closed Won' and 'Closed Lost' and changes the status to the corresponding 'Closed' status:

    Once you make those changes, save the entire list and see if the SQL error still occurs.

    Chris