Dynamics Community Forum Thread Details

Default dimension business unit dialog form lookup

Hi For BankAccountTrans there is a relation defualt dimension , now i am using a query names (CashBook)

and given relation as well , but dont know howto create lookup for business unit as well as i have to give range in this query for business unit as well . i already have created a dialog for bankaccount code , can i create lookup for business unit using these methods ..please help

 query buildQuery()
    {
       
        QueryBuildDataSource	qbdsBankAccountTable, qbdsBankAccountTrans;
        Query query				= new Query(queryStr(CashBook));
        qbdsBankAccountTable    = query.dataSourceTable(tableNum(BankAccountTable));
        qbdsBankAccountTrans	= query.dataSourceTable(tableNum(BankAccountTrans));
        
        qbdsBankaccountTrans.addRange(fieldNum(BankAccountTrans, TransDate)).value(queryRange(fromDate, toDate));

        //Bank Code
        BankAcc = con2Str(BankAccCon);

        if(BankAcc)
        {
            BankAcc = strReplace(BankAcc,';',',');
            qbdsBankAccountTable.addRange(fieldNum(BankAccountTable, AccountID)).value(BankAcc);
        }
        return query;
    }

    public boolean getFromDialog()
    {
        boolean ret = super();

        fromDate	= dfFromDate.value();
        toDate		= dfToDate.value();

        //Bank Account
        if (multiBankAccCtrl)
        {
            BankAccCon = multiBankAccCtrl.getSelectedFieldValues();
        }
        return ret;
    }

    /// 
    /// dialog
    /// 
    /// dialogLocal
    Object dialog()
    {
        #file

        DialogRunbase dialogLocal ;
        
        dialogLocal = super();
      
        dfFromDate	= dialogLocal.addFieldValue(extendedTypeStr(FromDate), fromDate,"@SYS5209");
        dfToDate	= dialogLocal.addFieldValue(extendedTypeStr(ToDate), toDate,"@SYS14656");

        fbscMultiBankAcc  = dialogLocal.curFormGroup().addControl(FormControlType::String, 'Bank Account');
        fbscMultiBankAcc.label('Bank Account');
       
        return dialogLocal;
    }

    /// 
    /// DialogPostRun
    /// 
    /// Dialog
    public void dialogPostRun(DialogRunbase dialog)
    {
        FormRun						formRun;

        super(dialog);

        formRun = dialog.dialogForm().formRun();

        if (formRun)
        {
            //Bank Account
            fscMultiBankAcc = formRun.design().control(fbscMultiBankAcc.id());
            multiBankAccCtrl = SysLookupMultiSelectCtrl::construct(formRun, fscMultiBankAcc, querystr(OABCashBookBankAcc));
            
        }
    }

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL