Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Sales Quotation sequence number: three different sequence number in sales quotation for three different companies(multi company)

quotation multicompany sequencenumber

3 الردود

6549 أدوات العرض

Remya

I need to configure the sequence number for my sales quotation. And also I have three companies. I want

Company1 - AAN01

Company2 - ABM01

Company3 - AZX01

What is the python code for the above requirement?

   @api.model
    def create(self,vals):
            if vals.get('sequence_name', _('New')) == _('New'):
                vals['sequence_name'] = self.env['ir.sequence'].next_by_code('sale.order') or _('New')
            res = super(sale_order, self).create(vals)
            return res

<record id="seq_sale_order" model="ir.sequence">
<field name="name">Sales Order</field>
<field name="code">sale.orders</field>
<field name="prefix">AAN</field>
<field name="padding">3</field>
<field name="company_id" eval="False"/>
</record>

Ricardo Gross

Hi Remya,

You can just go to: Settings / Technical / Sequences & Identifiers / Sequences / sale.order , and you can create separate sequences for each company (duplicate existing sequence and create one for each company).

Ricardo

Remya

الكاتب

That's ok. But I need to implement it through my customized code. Plz guide me to correct the below code

Mohammed Rida Yahla

Hi bro,

To do that you need first to create 3 sequences and define their names and prefix.

Then add this code in your class :

@api.model
def create(self,vals):
	if self.company_id and vals.get('name', '/') == '/':
		if self.company_id.name =="YourFirstCompanyName":#Company1 
			seq_id = self.pool.get('ir.model.data').get_object_reference(self._cr,self._uid,'sale_order', 'YourCompany1SequenceID')[1]
			self.name = self.pool.get('ir.sequence').get_id(self._cr,self._uid , seq_id, 'id',self._context)

		if self.company_id.name =="YourSecondCompanyName":#Company2
			seq_id = self.pool.get('ir.model.data').get_object_reference(self._cr,self._uid,'sale_order', 'YourCompany2SequenceID')[1]
			self.name = self.pool.get('ir.sequence').get_id(self._cr,self._uid , seq_id, 'id',self._context)

		if self.company_id.name =="YourThirdCompanyName":#Company3
			seq_id = self.pool.get('ir.model.data').get_object_reference(self._cr,self._uid,'sale_order', 'YourCompany3SequenceID')[1]
			self.name = self.pool.get('ir.sequence').get_id(self._cr,self._uid , seq_id, 'id',self._context)
	return super(sale_order, self).create(vals)

YourCompany3SequenceID = xml ID of the  sequence for the third company. 
Dont forget to vote positif :)

Remya

الكاتب

Very thankful for your answer. YourCompany3SequenceID = seq_sale_order

{. <record id="seq_sale_order" model="ir.sequence">}. Right???

Remya

الكاتب

Yet I didn't get any solution

Mohammed Rida Yahla

brther you have tocreate 2 more other sequences , the standard one is what you mentionned, you can use it as sequence for the first company , but you need to create 2 more sequences one for the second company and one for the third.

and it's a tested solution :) it works i promise

Remya

الكاتب

Hi, I had created 3 sequences for my three different company and mentioned as the above code. But it is not creating a sequence code.

But I will try to solve the issue in my code. Thanks for your reply

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Multiple lines in the quotation calculator quotation	0 نوفمبر 25	1166
Clarification on Creating Companies and Users in the Odoo Database multicompany	2 يوليو 25	2959
Multi Company set up multicompany	3 يوليو 25	3468
How many levels of sub-entities does the multicompany functionality of the accounting software support? تم الحل multicompany	1 يوليو 25	2554
Design Quotation Template with dynamic variables quotation	0 أبريل 25	3448

لقد تم الإبلاغ عن هذا السؤال

YourCompany3SequenceID = xml ID of the sequence for the third company.

Dont forget to vote positif :)

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!