Workflow State = Approved Filter of Project in the Saes Order Doc Type

ERPNext Project Management
1

Team,

Can anyone assist me with a client Script where in the Sales Order Doc Type under the Accounting Dimensions, it should filter the Project with the Workflow state = Approved only, and now it is showing all the status. I have implemented the Workflow in the Project Module

image
image1807×792 64.9 KB

2

Hi @jitendra,

Please apply the client script for Sales Order.

frappe.ui.form.on('Sales Order',  {
    refresh: function(frm) {
        frm.set_query("project", () => {
          return {
            "filters": {
              "workflow_state": "Approved"
            },
          };
        });
    }
});

Then reload and check it.

Reference: Overriding Link Query By Custom Script

Thank You!

1 Like
3

Appreciate for your Reply and immediate help @NCP,

But I have tried the same Client Script

image
image1899×801 65.6 KB

But still, it shows All the Workflow State

image
image1906×732 67.4 KB

4

Hi @jitendra,

Please check it.

Project:

image
image1818×549 73.3 KB

Sales Order:

image
image1822×892 103 KB

Thank You!

5

OK @NCP, Thanks again for your kind and immediate attention for my queries

6

@NCP, I have checked it is happening for 1 Trigger but again it shows all the Workflow States.

7

Please check it @jitendra,

Thank You!

1 Like
8

Thanks again for your sincere efforts. I will check again and will get back to you.

9

@NCP, Thanks a TrillionTons. It is working now.

10

@NCP, Yes you are an amazing one! In this era, no one works without any bounty of fees, but you always help with selfless and I am proud of you for being a great contributor.

1 Like