[Dan Cantley]

?#AX2012
I created a Display method attached to the SalesTable.  First one I have done.  I added it to the grid in SalesTableListPage to test it out and it works great.??

Now I want to add it to a Batch Job for invoices as one of the field to use in the selection criteria for the SalesTable.  I tried to find it in the discussions, but when not knowing what key words to search on for this, it can be a little hard to figure it out.

I was hoping that adding the display method to the salesTable would be it, but I am guessing there is more to it than that, because when I bring up the search criteria in the Invoicing batch job and bring up the salesTable, it isn’t one of the fields I can select.

Can someone point me in the correct direction please?  Is there a Class I need to add to, or a query to get this as one of the fields?

It is probably an easy thing to setup, once you know the correct way to do it, but finding that correct way can be a pain.

Thanks,

——————————
Dan Cantley
Systems Analyst
Bedrock Manufacturing Co, LLC
Detroit MI
——————————

[Michael Gonzalez]

I ran it by one of my experts. 

Display methods can’t be used as fields in the search criteria in batchJobs but it’s possible create your own parameters in your Batch Job, and use similar logic in your custom parameters

1. Use runBaseBatch class     Refer to: https://docs.microsoft.com/en-us/dynamicsax-2012/developer/walkthrough-extending-runbasebatch-class-to-create-and-run-a-batch     Don’t forget override the pack method for saving parameters.     Refer to Pack-Unpack Design Pattern: https://docs.microsoft.com/en-us/dynamicsax-2012/developer/pack-unpack-design-pattern      2. Modify you class to add Parameters     Override the dialog method.     Override the getFromDialog method.      3. It’s possible to generate custom parameters with advanced logic

protected Object dialog() {     Object ret;     FormStringControl           control;

    ret = super();

    control = myDialog.control();     control.registerOverrideMethod(methodStr(FormStringControl, myCustomLookup)..          return ret; }     Refer to: https://docs.microsoft.com/en-us/previous-versions/dynamics/ax-2012/system-classes/gg850443(v=ax.60)

4. Create the body of the custom LookUp      public void myCustomLookup(FormStringControl _control) {     Query                   query = new Query();     QueryBuildDataSource    queryBuildDataSource;     QueryBuildRange         qbr;     SysTableLookup          sysTableLookup = SysTableLookup::newParameters(tableNum(SalesTable), _control);

    sysTableLookup.addLookupField(fieldNum(SalesTable, FieldName));

    queryBuildDataSource = query.addDataSource(tableNum(SalesTable));     qbr = queryBuildDataSource.addRange(fieldNum(SalesTable,…     qbr.value(..

    sysTableLookup.parmQuery(query);

    sysTableLookup.performFormLookup(); }

——————————
Michael Gonzalez
Account Executive
Dynamics Resources
Venon Hills IL
——————————
——————————————-

[Dan Cantley]

Thanks – this is what I was looking for – guess it couldn’t be as easy as creating a display method.  I will try it out and let you know if it solves.  Now I just need to find the proper class for the Invoice Batch.

——————————
Dan Cantley
Systems Analyst
Bedrock Manufacturing Co, LLC
Detroit MI
——————————
——————————————-