Skip to content

Searching

Search Functionality Guide

In Merciglobal Cloud ERP, users can efficiently filter data within Entry Modules and Reports by leveraging flexible search expressions. These expressions are entered directly into the top row of the data grid (highlighted with a pale yellow background).

Search Types & Syntax

🔢 Type of Search 📝 Syntax 🔍 Description 📌 Example Matches
Any Value RAM Finds rows where the column contains the value anywhere. To search blank values, leave the input blank or insert a space. Siyaram, Radheshyam, Ramayan
Greater Than or Equal >= value Filters rows where the column value is greater than or equal to the input. >=100 → matches 100, 105
Less Than or Equal <= value Filters rows where the column value is less than or equal to the input. <=75 → matches 75, 70
Less Than < value Filters rows where the column value is strictly less than the input. <80 → matches 79, 60

Tips for Effective Searching

  • Use partial keywords to match any part of the text.
  • Numeric comparisons (>=, <=, <, >) work best on numeric fields.
  • Combine searches across multiple columns for refined filtering.
  • Leave the input cell blank to search for empty or null values.

Usage in Merciglobal Cloud ERP

The search functionality enhances user experience across multiple modules in Merciglobal Cloud ERP, including:

  • Invoice or Sales Entry modules
  • Master Data lists (e.g., Customers, Products)
  • Financial and Operational Reports

🔍 Empower your workflow with precise filtering — save time and focus on what matters most.

For more help, consult the Merci Developer Support Team or visit the official documentation.

Tick-List Filter (Excel style)

Every column of the yellow search row now has a small filter icon at its right edge. Use it to pick one or more exact values from a list, just like the filter drop-down in Excel.

How to use it

  1. Open any list view (for example a master list or an entry list) and click the filter icon in the yellow row of the column you want to filter.
  2. A list of all values in that column opens, with the number of records for each value. (Blanks) stands for empty values.
  3. Untick (Select All), then tick only the values you want. Type in the Search values box to find a value quickly.
  4. Click OK (or press Enter). The list shows only the records with the ticked values, and the record count at the bottom is updated.
  5. The cell shows how many values are selected (for example 2 selected) and the icon is highlighted. Click the icon again to change the selection, or click Clear filter to remove it.

Notes

  • Tick filters work together with the other search cells - for example, tick two categories and type >=20 in another column.
  • The value list always respects the filters already applied on other columns.
  • When a column has more than 500 different values, the first 500 are listed; type in the search box to find the others.
  • For a few calculated columns the list shows the values of the rows loaded on the current page.
  • Press Esc or click outside the box to close it without changes.

Searching inside the value list

When you type in the Search values box, the list shows only the matching values. Clicking OK while a search is typed applies only the values you ticked in that search result - values hidden by the search are not included, just like Excel.

  1. Click the filter icon of the column.
  2. Type the value you want, for example 70.
  3. Untick (Select All), then tick only the value you want (for example 70).
  4. Click OK. Only the records with that value are shown.

To pick values from different searches together, tick them all without a search typed (clear the Search values box before clicking OK).

Using the value list with the keyboard

You can work the tick-list filter without the mouse.

  1. Click the filter icon of the column. The cursor is in the Search values box.
  2. Press the Down arrow to move into the list. Use the Up / Down arrows to move between values; the current value is highlighted. Home and End jump to the first and last value.
  3. Press the Spacebar to tick or untick the highlighted value (on (Select All) it ticks or unticks every value).
  4. Press Enter to apply the filter. Esc closes the list without changing the filter.

Pressing the Up arrow on the first value takes you back to the Search values box, so you can search, arrow down to the result and tick it.

Master Search (all columns)

Use the Master Search box in the toolbar of any entry list when you don't know which column holds the text. It checks every column of the list together, so you don't have to type into each column filter.

How to use it

  1. Type a word in the Search all columns… box (party name, item, bill no., city, remark…).
  2. Press Enter or click the search button. The list shows only the rows where any column matches, and the footer shows the new row count.
  3. Click × or press Esc to clear it and get the full list back.

Notes

  • More than one word narrows the result: karwa kcpl shows rows that contain both words, in any columns.
  • Dates can be typed as 12-10-2026 (dd-mm-yyyy).
  • It works together with the column filters. For example, search KARWA and also filter the Date column to see only that day's KARWA entries.
  • On a mobile phone, tap the 🔍 icon in the toolbar to open the search box.
  • You can use up to 5 words (100 characters). The search only covers the branch/year data you can already see.

Where the Master Search box sits

To keep more rows on screen, the Search all columns… box now sits in the filter row of the list, in the empty cell of the first (action icons) column, just left of the first column filter. The toolbar at the top no longer carries it.

  • It works exactly as before: type, press Enter (or click the arrow), and press Esc or click × to clear.
  • If you scroll the list sideways so that the first column goes out of view, the box moves back to the toolbar for that time. It returns to the filter row when you scroll back.
  • On a mobile phone it stays behind the 🔍 icon in the toolbar, because the first column is too narrow there.

Searching the Account (group) column in reports

Reports that are grouped by a column, such as O/S Receipt / Payment Report grouped by Account, have a Search Account… box in the filter row of the first column. The box takes the name of the group column, so it may read Search Party… or Search Item… in other reports.

It searches the whole report, every page, not only the rows on the screen. Ctrl+F in the browser only finds what is already loaded on the current page. A party on page 2, for example SHIV SAREES, is not found that way, but this box finds it.

How to use it

  1. Type part of the name, for example shiv sarees or yash.
  2. Press Enter or click the arrow. While it searches, the button shows Searching…. The report then shows only the matching groups with all their rows, and the footer shows the new row count.
  3. Press Esc or click × to clear the search and get the full report back.

Notes

  • More than one word narrows the result. shiv sar finds groups whose name contains both words. You can use up to 5 words.
  • If nothing matches, a message says so and the footer shows Rows: 0. Clear the search to return to the report.
  • On a mobile phone, the search opens in a pop-up window with a large input box.
  • Entry lists, as opposed to reports, keep the Master Search box described above.

Picking values from several searches

When a column has more than 500 values (for example Taka numbers), the list shows the first 500 and you search to reach the rest. You can pick values from different searches in one go:

  1. Click the filter icon of the column.
  2. Type the first value, for example 1907, untick (Select All) and tick 1907.
  3. Change the search to the next value, for example 1970, and tick 1970.
  4. Click OK. Records with either value are shown, and the filter box shows 2 selected.

Values you tick by hand in an earlier search of the same list are kept when you click OK. Values that were already in the filter before you opened the list are replaced by your new choice, as before - to add to an existing filter, tick the old values again or pick all of them in one go.