Skip to Content
This question has been flagged
multicompanycompany_idcompanydependent
4 Replies
5094 Views
Avatar
Aadeel S. Puri

Hello Dear Odoers,

I need some help I have created a related field in my model 

location_dest_id = fields.Many2one('stock.location', string='To', domain="[('usage', '=', 'internal')]", required=True)

Currently it shows stock locations from the company assigned to a user, I want to show all records in stock location for user selection.

Please help.

Avatar
Discard
Avatar
Aadeel S. Puri
Author Best Answer

I have found a solution by changing the field from many2one to selection and computing selection records. with that, I can able to select stock location from other companies as well.

def _location_selection(self):
    domain = [('usage', '=', 'internal')]
    locations = self.env['stock.location'].sudo().search(domain)
    return list(map(lambda location: (str(location.id), ', '.join([location.complete_name, location.company_id.name])), locations))
location_dest_id = fields.Selection(
    selection=lambda self: self._location_selection(),
    string="To",
    help="Destination Stock Location.",
    required=True
)


Avatar
Discard
Avatar
Adil Akbar
Best Answer

Hi, 

You can see following for this, it has complete explanation for company_dependent fields alongwith access restriction and python code:

https://youtu.be/GkNgc-fZO-I

Hope it helps,

Thanks

Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

Add "check_company=False" in your code

location_dest_id = fields.Many2one('stock.location', string='To', domain="[('usage', '=', 'internal')]", required=True, check_company=False)

Regards

Avatar
Discard
Aadeel S. Puri
Author

Hi,
Thanks for your response, I have added check_company=False no difference. user has to select both companies in order to get locations.
I want user to select location from B Company regardless of allowed company to the user.
I am using 13 CE.

Avatar
jjjaberi0n
Best Answer

Hi, im trying understand your code. Can you tell me what is the purpose of the model that has field 'location_dest_id'?

That model has many-to-one relationship with model 'stock.location', right? So how does this relationship help with your object that is showing all records in stock location?

Avatar
Discard
Aadeel S. Puri
Author

Thanks for your response.
I have built inter warehouse stock transfer module. Which is working flawlessly, but there is a problem. In my case we are working with a multi-company environment.

Suppose
User A assigned to -> Company A
User B assigned to -> Company B
User C assigned to -> Company C

Stock.Location
WH/Stock1 | Company A
WH/Stock2 | Company B
WH/Stock3 | Company C

Now User A has logged in and open the form which contains mainy2one stock.location field
He can able to see in many2one selection WH/Stock1, Until unless I give him all the companies access, and he selects all companies he won't be able to see other locations.

I want him to able to see all locations in that particular many2one field all the available locations regardless of companies he is assigned.

Currently Odoo has a very ridiculous approach in terms of inter companies stock transfer, It didn't have branch management so we are using companies as branches. I have built this module inspired by the Microsoft Dynamics RMS stock transfer mechanism, which is way more easier to work, less prone to user mistakes, and highly flexible on reporting.

Hope you understand my pain :(

Related Posts Replies Views Activity
How to get current company in xml?
xml company_id companydependent
Avatar
Avatar
5
Jun 20
5816
Domain for sale.order.line to show only products that belongs to selected company_id Solved
sale.order.line sale.order.form multicompany company_id
Avatar
Avatar
1
Mar 16
12555
Clarification on Creating Companies and Users in the Odoo Database
multicompany
Avatar
Avatar
Avatar
2
Jul 25
1726
Multi Company set up
multicompany
Avatar
Avatar
Avatar
3
Jul 25
2115
How many levels of sub-entities does the multicompany functionality of the accounting software support? Solved
multicompany
Avatar
Avatar
1
Jul 25
1462