Loopkup filter  based on another field  in SYSQUERY form 

The requirement is to filter one lookup field value based on another field selection in SysQuery form.

Follow the below steps to filter VendorAccount field based on legal entities selection

Example:

1. Create a new Query called DESVendorSpendReport having DataArea as Root and VendTable underneath it.

create a relation under VendTable like DataArea.id == VendTable.DataAreaid

2. Set AllowCrossCompany property of the Query to true.

3. Write the below code in SysQueryForm > Range(DataSource) > RangeValue(field) > Lookup method

public void lookup(FormControl _formControl, str _filterStr)

{

   CompanyInfo          companyInfo;

   Query                query;

   QueryBuildDataSource qbds;

   SysTableLookup       lookup;

   SysDictField         sysDictField;

   VendTable            vendTable;

   TmpSysQuery          tmpSysQuery;

   TmpSysQueryCompanyRange tmpSysQueryCompanyRange;

   Container               selectedCompanies;

   

   ;

   sysDictField = new SysDictField(Range.Table_Id, Range.Field_Id);

   if (sysDictField.label() == "Vendor account")

   {

        recordsMarked = CompanyRanges_DS.recordsMarked();

        lastIndex     = recordsMarked.lastIndex();

        for (tmpSysQueryCompanyRange = CompanyRanges_DS.getFirst(); tmpSysQueryCompanyRange ; tmpSysQueryCompanyRange = CompanyRanges_DS.getNext() )

        {

            if (tmpSysQueryCompanyRange.IsCompanySelected == NoYes::Yes)

            {

                selectedCompanies = conIns(selectedCompanies, 1, tmpSysQueryCompanyRange.CompanyId);

            }

        }

        if (selectedCompanies)

        {

            lookup = SysTableLookup::newParameters(tableNum(DESVendorSpendReport),                      _formControl);

            lookup.addLookupfield(fieldNum(DESVendorSpendReport, AccountNum));

            lookup.addLookupfield(fieldNum(DESVendorSpendReport, Id));

            query = new Query();

            qbds = query.addDataSource(tableNum(DESVendorSpendReport));

            qbds.addRange(fieldNum(DESVendorSpendReport, id)).value(con2Str(selectedCompanies));

            lookup.parmQuery(query);

            lookup.performFormLookup();

          }

      else

      {

        SysLookup::lookupRange(_formControl, range, sysQueryForm.query());

      }

   }

   else

   {

     SysLookup::lookupRange(_formControl, range, sysQueryForm.query());

   }

}

Parallel compile through command prompt 

1. change the directory to the path where axbuild.exe file exits

Eg : cd E:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin

2. Run the following command

Eg: E:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin>axbuild.exe xppcompileall /aos=01 /altbin="E:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin" /workers=6

To Export a model using command prompt:

1. Open command prompt as run as administrator

2. change the directory to management utilities 

for ex: if the managementUtilities are present in E:\Program Files\Microsoft Dynamics AX\60\ManagementUtilities

3. change directory to E drive using cd E:

4. once the directory is changed enter the command E:> E:\Program Files\Microsoft Dynamics AX\60\ManagementUtilities

5. E:\Program Files\Microsoft Dynamics AX\60\ManagementUtilities> axutil export /model:DES /file:BPCheck (where DES is the existing model and BPCheck is the filename we need to export) 

Finally the model will be exported to E:\Program Files\Microsoft Dynamics AX\60\ManagementUtilities.

To Find the phone number of the customer:

    LogisticsElectronicAddress LogisticsElectronicAddress;

    DirPartyLocation DirPartyLocation;

    int contactPhoneCounter = 0;

    while select Locator from LogisticsElectronicAddress exists join DirPartyLocation

    where

    DirPartyLocation.Party == _custInvoiceJour.custTable_InvoiceAccount().Party

    &&

    DirPartyLocation.location == LogisticsElectronicAddress.location

    && LogisticsElectronicAddress.type == LogisticsElectronicAddressMethodType::Phone

    {

        contactPhoneCounter++;

        if (contactPhoneCounter==1)

        {

                cachedCompanyContactPhone1 = LogisticsElectronicAddress.Locator;

        }

        else if (contactPhoneCounter==2)

        {

            cachedCompanyContactPhone2 = LogisticsElectronicAddress.Locator;

        }

        else

        {

            break;

        }

    }

Code to find Dimension Name:

public name hsGetDepartmentName(DimensionDefault  _dimensionDefault)

        {

             str                                 name;

              DimensionAttributeValueSetItem      valueSetItem; 

              DimensionAttribute                  dimAttribute; 

              DimensionAttributeValue             dimAttributeValue; 

            //Getting the Department name for the record.

              select DimensionAttributeValueSet from valueSetItem 

                    where valueSetItem.DimensionAttributeValueSet == _dimensionDefault 

                            join RecId from dimAttributeValue 

                                where valueSetItem.DimensionAttributeValue == dimAttributeValue.RecId 

                                    join RecId from dimAttribute 

                                        where dimAttributeValue.DimensionAttribute == dimAttribute.RecId 

                                              && dimAttribute.Name == enum2str(sysdimension::Department);

        

             name = DimensionAttributeValue::find(dimAttributeValue.RecId).getName();

        

            return name;

        }

To import demo data in AX 2012 R3:

1.       Install Test data transfer tool
2.       Open command prompt as administrator and then  cd\ C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)
3.       Then type dp.exe import C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta) servername\axinstance name

Job for generating parm methods:

static void CreateAxBCParmMethod(Args _args)

{

    axGenerateAxBCClass axGenerateAxBCClass;

    axGenerateAxBCClass = AxGenerateAxBCClass::newTableId(tablenum(PurchReqLine));//tablenum can be the table                                                                                   //for which we want to generate                                                                                 //parm methods

    axGenerateAxBCClass.run();

}