[Managing multiple companies ]Filter Items in Sales Order Item table based on the company selected

Frappe Framework Customization
1

Hello Team

I have created one custom field ‘Company’ wherever applicable to separate different companies I’m managing through one instance and then I apply user permission for company to restrict the access.

This custom field is also added in other DocTypes such as Item, Customers, Suppliers etc.

However, in the case of the users who have no such restrictions, there are some issues regarding which I need some help:

When I select the ‘Company A’ in the Sales Order, I expect the Items to get filtered based on it. (as the same custom field is there in the Item DocType too). But it lists out all the items in irrespective of the company previously selected.

Thanks & Regards
Satish

2

If i understood correctly. Below is the solution. Kindly give the “Default Company” in the Item Master (Item Defaults Table)

05%20PM
05%20PM1188×676 30 KB

3

I have multiple companies .for that i want to add filter on item basis of company .

4

If you have different Item Master for each company means you have to do this.

5

I have only one item master with the same

6

Can you share any example?

7

Try it.

get_query
get_query848×166 15.7 KB

1 Like
8

Yes, when i create a sales order in that select company & in that one table items in that item table i want to add filter and display the item on the bases of the company…

item%20filter
item%20filter1204×509 35.2 KB

The above item filter by the company.this is i want…
This item comes in sales_order_item table.

For that i do this but it is not working

frappe.ui.form.on(‘Sales Order Item’, {
company:function(frm) {
frm.set_query(‘item_code’,function(){
return {
filters:{
‘company’:frm.doc.company
}
}
})
}
})

9

Can you please help me where to add this script?

10

Hi,
Try following code,

image
image1029×185 21.6 KB

1 Like
11

Satish_malkar, Can you help me setup specific company websites with products separated by company? Do i still need to add Company field to each dimension ie item, customer, supplier etc? I could filter by item group but i dont know how to set website settings to separate different homepage for a specific company so those product filters are a requirement?