Like operator in AX

static void Job1(Args _args)

{

    TrvExpTrans trvexp;

    ;

    while select trvexp where  trvexp.Description like "Ai??are"

    {

        info(trvexp.ExpNumber + "------" + trvexp.Description);

    } 

}

Job to create unreconciled expense by using service class in AX2012

Creating unreconciled expense by using service class

static void CreateunreconciledExpense(Args _args)

{

    TrvUnreconciledExpenseRecord newRecord;

    TrvUnreconciledExpenseService service = new TrvUnreconciledExpenseService(); 

    newRecord = new TrvUnreconciledExpenseRecord();

    newRecord.parmCostType('Car Rental');

   // newRecord.parmMerchantId('Bad car rental place');

    newRecord.parmTransactionCurrencyAmount(600);

    newRecord.parmTransactionCurrencyCode('EUR');     

    newRecord.parmTransactionDate(DateTimeUtil::date(DateTimeUtil::addDays(DateTimeUtil::utcNow(), -1228)));

    newRecord.parmUserNetworkAlias('XXXXX'); // pass the username

    newRecord.parmUserNetworkDomain('XXXXXXXXXX'); // Pass the network domian 

    service.createRecord(newRecord);

    info("record created");

}

Job to create expense record by using service classes

Here is the sample job to create expense record  by using service class.

static void createExpLine(Args _args)

{

    TrvExpenseService            expService;    //  Service class

    TrvExpense                   trvExpense;      // Expense Document object

    TrvExpense_TrvExpTable       expenseTable;  // Expense Header data object

    TrvExpense_TrvExpTrans       expenseTrans;  // Expense Line data object

    AifEntityKeyList             entityKeyList; // Entity key list

    TrvExpNumber                 expNum;

    ; 

    // Create the service instance

    expService =  TrvExpenseService::construct(); 

    // Create the document object

    trvExpense = new TrvExpense(); 

    //create the Expense header

    trvExpense.createTrvExpTable();

    expenseTable    = trvExpense.parmTrvExpTable().addNew();

    expenseTable.parmCreatingWorker("000131"); 

     // Create the Line

    expenseTrans    = new  TrvExpense_TrvExpTrans();

    expenseTrans.parmCostType("Car Rental");

    expenseTrans.parmExpType(TrvExpType::CarRental);

    expenseTrans.parmPayMethod("CASH");

    expenseTrans.parmTransDate(today());

    expenseTrans.parmAmountCurr(10);

    expenseTrans.parmProjId("10001");  

    expenseTrans.parmAdditionalInformation("Free Text");  

    expenseTable.createTrvExpTrans().add(expenseTrans);

     // Create Customer

    entityKeyList = expService.create(trvExpense);

    expNum = entityKeyList.getEntityKey(1).parmKeyDataMap().lookup(fieldnum(TrvExpTable, ExpNumber));

    info(strfmt("Created Expense: Exp Number: %1.", expNum)); 

}