Skip to main content

Posts

Showing posts with the label querybuildlink

Filter value in lookup in payment journal invoice id as per customer in invoice bill using axapta

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(); }