Skip to Content
Dette spørgsmål er blevet anmeldt
salescrmquoteautomaticopportunity
2 Besvarelser
3868 Visninger
Avatar
Samuel Rutter

Hello everyone!

I'm new to Odoo. I am trying out Odoo Community v15 on a local machine for my enterprise. With the CRM and Sales modules, I have learnt that Sales Quotes can be created directly from the Opportunity details screen. However, when creating a quotation, the expected revenue does not change to it's final price, and my employees have to change it manually.

I can't seem to find a way to have that field update automatically, based on the total sum of costs from both quotes and confirmed orders. Is there a configuration I may have missed? Or should I implement that function with code? If so, how would I do that?

Thanks in advance.

Avatar
Kassér
Avatar
abraham vega
Bedste svar

You can totally do it, with automatization rules. Im using this rule in Odoo v17 Entrepice.

1. Model: Sale Order
2. Activate: When saving
3. Match: all.
4. Apply: in all.
5. Update: non.

*Acctions*

Execute code:

today = datetime.datetime.today()

quotation_domain = [('state', 'not in', ('cancel',))]

for so in records:

    company_currency = so.opportunity_id.company_currency or env.company.currency_id

    lead = so.opportunity_id

    sale_orders = lead.order_ids.filtered_domain(quotation_domain)

    sale_amount_total = sum(

        order.currency_id._convert(

            order.amount_untaxed, company_currency, order.company_id, order.date_order or today

        )

        for order in sale_orders

    )

    lead.write({'expected_revenue':sale_amount_total})



Let me know if you need further explanation.

Avatar
Kassér
Avatar
CandidRoot Solutions Private Limited
Bedste svar

Hello, 

No, There is no any kind of setting or configuration that based on quote amount, It will update the Expected Revenue field.

You have to manually put the Expected Revenue into Opportunity.

Thanks & Regards,

​

CandidRoot Solutions Pvt. Ltd.

Mobile: (+91) 8849036209
Email: info@candidroot.com
Skype: live:candidroot
Web: https://www.candidroot.com
Address: 1229-1230, Iconic Shyamal, Near Shyamal Cross Road, Ahmedabad, Gujarat

Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
Opportunity name in sale order and invoice ?
crm invoice quote opportunity
Avatar
Avatar
1
apr. 20
3934
Opportunity for a certain product
sales crm product opportunity
Avatar
Avatar
Avatar
Avatar
3
okt. 15
6478
Generate CRM opportunity from sales quotation
sales crm
Avatar
Avatar
Avatar
2
aug. 25
4930
CRM Phone and Email Updates
crm opportunity
Avatar
0
dec. 24
1770
lock CRM
crm opportunity
Avatar
0
sep. 24
1808