Skip to main content
Solved

Extending SOINvoiceFitler


Forum|alt.badge.img

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.

 

Best answer by darylbowman

I believe perhaps you could override ApplyAdditionalFilters method to include your custom filter and perhaps avoid redefining the data view and delegate

 

View original
Did this topic help you find an answer to your question?

2 replies

darylbowman
Captain II
Forum|alt.badge.img+13
  • 1728 replies
  • Answer
  • November 14, 2023

I believe perhaps you could override ApplyAdditionalFilters method to include your custom filter and perhaps avoid redefining the data view and delegate

 


Forum|alt.badge.img
  • Author
  • Varsity I
  • 71 replies
  • November 14, 2023

Hi Daryl,

 

Thanks so much for taking the time to read and respond to my question.  I didn’t even know there was such a thing as ApplyAdditionalFilters.  Looks perfect will give it a go and confirm the above works.

 

Thanks,

John.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings