Limit items based on customer name

[mulyadi-agtechsg]

Hi

Is it possible to limit item list based on customer when we want to do a purchase order?

This means when we select the customer, only the allowed items are allowed to show in the child table.

I have read the following:

Re-populate child table on customer selection

Hi Pawan, thanks for the reply. I think you are referencing “add_fetch” if I am not mistaken. Does add_fetch work for table type link, in Customer? have you used add_fetch for fetching data to populate a table? I would appreciate it Thanks

But is it possible to do this without touching ERPNext and Frappe backend code?
Thanks!

Regards

[Pawan]

Maybe the below steps might help you

1. Create a Custom Doc Type, which holds a mapping of Customer to Item Codes.

2. Add a link field for Item on the pages where you want this. Assuming these pages would have Customer ID as well.

3. Write custom JS using frappe.ui.form.on along with filters to do this.

Thanks

[mulyadi-agtechsg]

Hi @Pawan

Thank you very much for the prompt response!

Will try and feedback if it works.

Thanks!

Regards

Mulyadi

[CoffeeHolic]

Hello Mulyadi, yes Pawan’s reply is spot on, I did create a custom Doc type, with a mapping, My code will fetch customer profile when I select the customer in the order module.in my case it is 1 to many profiles relationship so it had to be a table with a link to the customer.

[mulyadi-agtechsg]

Hello @CoffeeHolic!

Thank you for the details! Appreciate it!