Extending SOINvoiceFitler

Hi,

I’m wanting to extend SOInvoiceFilter on Process Invoice and Memos (SO505000) to enable filtering on Customer Class.  Have made a start and think I’m mainly on the right track but have a problem I can’t quite crack.  Think the answer to this should be relatively simple.

So far,

I have extended SOInvoiceFilter  as shown below to add a selector for Customer Class:

Have added the new Customer Class selector to the Form with Commit Changes = True

Have extended the graph:

The above is all the changes I have made so far.  What is happening is on changing any of the fields in the filter, I get:

I think that the issue must be that BQL in the graph extension is not correct, but I can’t spot the issue.

Any help would be greatly appreciated.  

Also, I’m not 100% sure on what other steps will be required to get the extended filter to work on the grid so any pointers on that would also be helpful. 

My thinking was I would need to override GetInvoices() so that it returns records based on the SOInvoiceList variable in the Graph extension as opposed to the SOInvoiceList variable in the base graph.  The below shows the definition of SOInvoiceList in the base class

In the base class we have GetInvoices()

However, if this code is pasted into the Graph extension and you attempt to rework it such that it used the new SOInvoiceList variable you run into issues around needing to reference protected and private variable sin the base class.  So maybe I’m not on the right track here?

Thanks,

John.