Find with Conditions
Find in TallyPrime | List of field names | FAQ |
You can find within specific master types, fields, or voucher types, and refine results using specific operators. Use AND, OR, NOT to include or exclude results, and operators like >, <, or = to find values above, below, or equal to a specific number or date.
Logical operators such as AND, OR, and NOT can be used directly with keywords. Numerical and string operators must be used with field names. You can view the List of field names here. When using field names, make sure there are no spaces or special characters in the query. The correct syntax is Fieldname: value. For example, ledgeramount: 10000 or stockitem: Television.
Find Using AND, OR, NOT
| Symbol | Operator | Result | Example |
| & | AND | All transactions and masters with both keywords | Type: Steel & Cement Displays all transactions and masters that contain Steel and Cement; in any order |
| | | OR | All transactions and masters that contain any one of the keywords | Type: Repairs | Services Displays all masters and transactions that contain Repairs, Services, or both. |
| ! | NOT | All transactions and masters that do not include the entered keyword | Type: Repairs ! Replacement Displays transactions and masters that contain only Repairs; excludes those with Replacement, both Repairs and Replacement. |
Find Names with Equal To and Not Equal To
| Symbol | Operator | Result | Example |
|
= |
Equal to |
All transactions and masters that have exactly matched entries as the specified value. |
Type: Name=Samsung, Ledgername=John Similarly, it displays transactions in which the field Ledger Name contains an exact match for John. |
|
!= |
Not equal to |
All transactions and masters that do not have matching entries as the specified value. |
Type: Name!=Samsung |
Find Numbers or Dates with Greater Than
| Symbol | Operator | Result | Example |
|
> |
Greater than |
All transactions and masters that have any field value greater than the specified value. |
Type: Ledgeramount>50000, actualquantity<120kg Displays transactions where actual quantity is less than 120 kg. |
| Similarly, you can use >= (Greater than equal to), < (Less than), <= (Less than equal to) | |||
Find Exact/Similar Matches
| Symbol | Operator | Result | Example |
|
~ |
Similar to |
All transactions and masters that have any field value with approximate similarity and exact matches. |
Type: Name~Sourav, Address~Bangalore Similarly, displays transactions and masters where the address like Bangalore or Bengaluru both exist. |
| Similarly, you can use !~ (Not Similar to) to view all masters and transactions without exact and similar matches. | |||
|
” “ |
Double quotes |
All transactions and masters that have any field value with exact matches of the words in any order. |
Type:“Sourav Traders” |
|
‘ ‘ |
Single quotes |
All transactions and masters that have any field value with exact matches of the words in any order. If you choose to include similar spellings result will show both similar and exact matches. |
Type:‘Sourav Traders’ |
Combination of Operators
You can use multiple operators together to form complex conditions.
|
Type |
Result |
|---|---|
|
stockitemname=Refrigerator & actualquantity>30 vouchertypename:Sales & ledgername:Bhagya |
Displays transactions with item name Refrigerator and quantity is greater than 30. |
|
ledgername:bhagya & itemname:samsung |
Displays transactions where ledger name is bhagya and item includes samsung. |
|
ledgername:bhagya | itemname:samsung |
Displays transactions where ledger name is bhagya or item includes samsung. |
| (vchtypename = payment & narration: ‘cash paid’) & amount > 25000 |
Display all the payment voucher where the narration is mentioned as cash paid and amount is greater than 25000. |
Using Incomplete/Invalid Query
If the query entered is not valid, it is treated as plain text, and results are displayed accordingly. A note appears below the Find Results page stating:
“The query may not be valid. However, the results are displayed based on the matching text.”
Here are a few examples of invalid queries:
Cash & – Here there is no keyword after the & symbol.
Ledger: – Here there is no keyword after the : symbol.
Narration: = cash – Here both the colon and the = symbol are used, which is wrong.
Samsung 30” – You might have created a stock item as Samsung 30” but to get the required results, the same query has to be written within single quotes i.e. ‘Samsung 30”’ or with a backward slash \ before 30 i.e. Samsung 30\”.
