Filter value in lookup in payment journal invoice id as per custmer in invoice bill public void lookup() { SysTableLookup tableLookup; QueryBuildRange rangeTransDate; QueryBuildRange VillageCode,ItemId,DistCode,TalukaCode; QueryBuildRange CropId; QueryRun queryRun; QueryBuildDataSource qbds,qbds1,qbr,qbr1,qbr2; Query q = new Query(); Query q1 = new Query(); QueryBuildLink QueryBuildLink1,QueryBuildLink2; boolean flg; ; tableLookup = SysTableLookup::newParameters(tableNum(CustInvoiceTable),this); qbr = q.addDataSource(tableNum(CustInvoiceTable)); if(LedgerJournalTrans_AccountNum.valueStr() != "" ) { qbr.addRange(fieldnum(CustInvoiceTable,InvoiceAccount)).value(queryValue(LedgerJournalTrans_AccountNum.valueStr())); } tableLookup.parmQuery(q); tableLookup.addLookupfield(fieldNum(CustInvoiceTable,InvoiceId)); tableLookup.performFormLookup(); }
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .