I added a custom field UsrHoldForPaymentProcess to the Bills and Adjustments screen.  This field gets created in the APRegister table.  It is a checkbox to indicate that we do not want to show this bill on the Approve Bills for Payment screen.

On the Approve Bills for Payment screen, I want to only show Bills that do not have the UsrHoldForPaymentProcess field set to true.

One problem I see is that the select statement for the Approve Bills screen pulls from APInvoice, not APRegister.

To adjust what gets displayed in the grid, I want to override this method in the APApproveBills graph

private static Type getAPDocumentSelect(bool groupBy = false)
 

I cannot seem to get the override correct as I get an error that the signature does not match.

public delegate Type getAPDocumentSelectDelegate(bool groupBy = false);
ePXOverride]
public static Type getAPDocumentSelect(bool groupBy, getAPDocumentSelectDelegate baseMethod)
 

I tried to do what would seem like the EASY approach by adding a Where to the View in the initialize, but it does not have any impact.

Since the APDocumentList view uses the APInvoice table for the select, for testing, I created another extension field in the APInvoice table with the same Usr field name as in the APRegister table.  In SQL, I updated one record so that the field is set to true.  But the bill still shows in the grid.

public override void Initialize()
{
    this.Base.APDocumentList.WhereAnd<Where<TenFedAPInvoiceExt.usrHoldForPaymentProcess, IsNull, Or<TenFedAPInvoiceExt.usrHoldForPaymentProcess, Equal<boolFalse>>>>();
}
 

I think if I can get the signature figured out, I can do the join from APInvoice to APRegister and restrict the returned query to remove the records where my Usr field is true.  It means copying a lot of Acumatica lines and making a couple tweaks, but I think that would work.

Help!  :-)