Dear Experts, I want to show only searched customers name in the table. Eg, If i text ABC and enter then i should view only that customers name list (May be ABC Traders, ABC investments, etc) I couldn't achieve this requirement using below codes. Pls see below codes. [#Part: EI BaseInfo] Add : Line: Before : EI Consignee : BA EI Consignee [Line: BA EI Consignee] Fields : Simple Prompt , BAR Cus Search Local : Field : Simple Prompt: Info : $$LocaleString:"Customer Search :" Local: Field : Simple Prompt: Width: 14 [Field:BAR Cus Search] Use: Name Field Width: 20 Border: Thin Box Variable : ABsCust [Variable: ABsCust] Type : String [#Collection: Invoice Ledgers Extract ] Filter : MyCustomer [System : formula] MyCustomer :$Name contains ##ABsCust
Use this as it provide quick contents. [System : formula] MyCustomer :$Name contains #BARCusSearch plz revert back the status
U cn use this also [#Field: EI Consignee] Delete: Table : Party Cash Ledgers Extract Delete: Table : Invoice Ledgers Extract Add: Table: Parties of Custom [Table: Parties of Custom] Type: Ledger Title: $$LocaleString:"Ledgers Align : Right FullHeight : Yes Fetch: Name, Narration Format: $Name, 30 Format: $Narration, 10 Belongs To: Yes Filter : MyCustomer [System : formula] MyCustomer :$Name contains #BARCusSearch u had not declared variable in systemn variable definition in ur code, try to use that also