Menu

Sage 300 Global Search: How to Quickly Find Transactions and Records

Global Search in Sage 300 is a powerful but streamlined search tool that allows you to quickly search the Sage 300 database to find transactions and records.

Industrios feature image on an article about sage 300 global search

Sage 300 Global Search is a powerful feature that lets you quickly find transactions, items, customers, vendors, G/L accounts, and journal entries across your entire Sage 300 database. Whether you’re using the desktop or web version, Sage 300 Global Search streamlines your workflow and helps you locate the information you need with just a few clicks.

How to Use Sage 300 Global Search

Sage 300 Global Search is available from the ribbon on the Desktop version as shown below. 

On Web Screens it appears on the Welcome bar

Global Search allows you to quickly search your entire Sage 300 database for any of the following:

• Transactions
• Items
• Customers
• Vendors
• G/L Accounts
• G/L Journal Entries

Note: When searching for transactions, you can specify the type of transactions you want to find.

Looking Up Information Using Global Search

Use Global Search to quickly look up transactions and records in your Sage 300cloud system.

To look up transactions and records using Global Search:

1. Click the Search icon or   

The Global Search screen appears. 

2. On the list to the left of the search field, select types of transactions or records to find.

3. In the search field, enter a word, phrase, or other text (such as an identifying number) that may be in the transaction or record you are looking for, and then click the Search button to the right of the search field.

A list of results is displayed.

By default, if you enter multiple words in the search field, transactions and records are found if they include any of the words you entered. You can refine this default behavior by using the following special formatting in the search field:

Quotation marks. To find an exact phrase, enclose the phrase in quotation marks. For example, if you search for “Office Supplies”, only transactions and records that include the exact words in this order Office Supplies will be found. Transactions and records that include variations such as Office or Supplies will not be found.

With quotations:

Without quotations:

Another use of quotation marks is to find text that includes special characters (such as hyphens). For example, to find ABC-123, enter “ABC-123” in the search field.

Plus sign. To specify that results must include a certain word or phrase, put a + before the word or phrase. For example, if you search for +20233 +”office chair” furniture, every result will include both 20233 and office chair, but may or may not include furniture.

To open a transaction or record in its primary screen, click the transaction ID or record ID in a result.

Note: There are currently some restrictions on some of the fields being searched. Some of the fields with restrictions are Invoice #, Entry Descriptions, Vendor and Customer number and name. Not searched are the amounts, item descriptions or AP Document #…..  Keep this in mind when entering information into these fields if you plan on taking advantage of this feature.

Trouble shooting:

The Global Search service must be running:  start your services, search for “GlobalSearchService” and ensure it is running.

Refreshing Search Data

The Sage 300 ADMIN user can manually refresh search data to ensure that Global Search finds results from the most current and complete data. You refresh search data by clicking the Refresh button on the Global Search screen. (Only the ADMIN user can do this.)

You can refresh search data only for the company that you currently have open. If you have multiple companies, refreshing search data for one of them does not affect search data for the others.

Refresh search data in the following situations:

• Before using Global Search for the first time.
• After using Database Load to change data in a database.
• After deleting records from a database (for example, with Clear History).
• After changing database settings, such as username, password, server, ODBC DSN, database name, or changing whether the database uses security.

Tip: After changing or adding data, it may be several minutes before your changes are reflected in Global Search results. You may be able to make changes appear sooner in Global Search results by refreshing search data.

Final Thoughts on Sage 300 Global Search

Sage 300 Global Search is an essential tool for improving efficiency and accuracy in your daily operations. By mastering Sage 300 Global Search, you can save time, reduce manual effort, and ensure you always have the information you need at your fingertips.

Up Next
  • The Invisible Factory: Whitepaper
    The Invisible Factory: Whitepaper
  • PlantGauge Data Sheet
    PlantGauge Data Sheet
  • Software Data Sheet
    Software Data Sheet
  • Distribution Suite Data Sheet
    Distribution Suite Data Sheet
  • Project Manufacturing Data Sheet
    Project Manufacturing Data Sheet
  • PlantCare Overview
    PlantCare Overview
  • PlantUp! Datasheet
    PlantUp! Datasheet
  • SteppingStones Overview
    SteppingStones Overview
  • Inventory Control and Costing
    Inventory Control and Costing
  • Manufacturing CRM
    Manufacturing CRM
  • Production and Scheduling
    Production and Scheduling
  • Procurement and Materials
    Procurement and Materials
  • Sales Management
    Sales Management
  • Make-to-Order Make-to-Stock
    Altron Automation Achieves Precision and Cost Savings
    Altron Automation halved purchasing costs and reached 99.5% inventory accuracy by upgrading to INDUSTRIOS ERP, enabling real-time inventory management, automated job tracking, and data-driven process improvements for scalable, efficient growth.
    Altron Automation, a leading Michigan-based systems integrator for the automotive and heavy truck industries, transformed its operations by upgrading its INDUSTRIOS custom manufacturing ERP.
    Read Success Story
    Make-to-Order Make-to-Stock
    AMPCO Sustains Growth and Efficiency with INDUSTRIOS ERP
    AMPCO doubled sales and maintained fast lead times by upgrading to INDUSTRIOS ERP, absorbing vendor cost increases, reducing production delays, and improving quoting accuracy—enabling efficient, customer-focused growth.
    American Metal Products Company (AMPCO), a Portland-based tube bending and metal forming specialist, doubled sales over three years while maintaining fast lead times and competitive pricing
    Download Success Story
    Make-to-Order
    Cam Tran Modernizes Operations, Achieves 80% Payroll Time Savings
    Cam Tran upgraded to INDUSTRIOS ERP, cutting payroll processing time by 80% and automating data tracking. Real-time production monitoring and lean-ready workflows now drive efficiency, collaboration, and scalable growth.
    Cam Tran Co. Ltd., a leading North American transformer manufacturer, modernized its payroll and production processes by upgrading to the latest INDUSTRIOS ERP.
    Download Success Story
    Make-to-Order Make-to-Stock
    Real-Time Inventory and Scheduling Power Leone Fence’s Growth
    Leone Fence increased customer satisfaction by 40% through real-time inventory visibility, automated subcontractor scheduling, and seamless ERP integration, enabling proactive purchasing, accurate order tracking, and scalable growth.
    Leone Fence, the largest commercial and industrial fence installer in the Greater Toronto Area, transformed its operations by integrating INDUSTRIOS with Sage 300 ERP.
    Download Success Story
    Project Manufacturing
    Plas-Tech Automates Job Tracking and Inventory for Greater Efficiency
    Plas-Tech Inc. improved inventory accuracy and automated job tracking with INDUSTRIOS ERP, enabling real-time material visibility, data-driven cost analysis, and streamlined reporting to support efficient, scalable growth.
    Plas-Tech Inc., a custom plastic fabrication company in Concord, Ontario, transformed its operations by implementing INDUSTRIOS ERP.
    Read Success Story
    Make-to-Order
    Pratt & Larson Unifies Inventory and Shipping with INDUSTRIOS
    Pratt & Larson unified inventory and shipping with INDUSTRIOS, enabling real-time tracking, seamless workflows, and faster order fulfillment that improved accuracy, financial clarity, and client satisfaction across artisan tile production.
    Pratt & Larson Ceramics, a premier artisan tile manufacturer, transformed its operations with INDUSTRIOS custom manufacturing ERP.
    Download Success Story
    Make-to-Stock
    SmithCo Manufacturing Automates Labor & Payroll with INDUSTRIOS ERP
    SmithCo Manufacturing automated labor tracking and payroll with INDUSTRIOS ERP, gaining real-time job cost visibility, and streamlining production management. Seamless integration boosted efficiency, accuracy, and positioned SmithCo for continued growth.
    SmithCo Manufacturing, a leading producer of side dump trailers in Le Mars, Iowa, transformed its operations by implementing INDUSTRIOS ERP. Key achievements include:
    Read Success Story
    Make-to-Order
    UMC Optimizes Shipping and Inventory with INDUSTRIOS
    Universal Motion Components (UMC) streamlined shipping and improved inventory planning with INDUSTRIOS ERP. Enhanced data access and automated purchasing enable faster, more accurate deliveries, and support operational growth.
    Universal Motion Components (UMC), based in Costa Mesa, California, is a leading supplier of drive line components for the agriculture and construction industries.
    Download Success Story
    Make-to-Stock
    Universal Stenciling Grows Efficiently with INDUSTRIOS ERP
    Universal Stenciling streamlined inventory and accelerated order fulfillment using INDUSTRIOS ERP. They now fulfill 90% of orders within 24 hours and manage over 3,000 raw materials with accuracy.
    Universal Stenciling & Marking Systems, a family-owned innovator in marking, stenciling, and coding equipment since 1904, leveraged INDUSTRIOS ERP to:
    Download Success Story
    Harnessing the power of employee engagement through real time metrics

    Explore the concept of the employee engagement and how technology can impact adoption of practices that foster employee engagement. Jacques Decarie, Vice-President of Sales and Marketing with INDUSTRIOS and Jenice Rideout, President of HR Navigation Inc. provide an overview of how to apply practices to drive your team to exceptional performance.

    What's New - Handling Order to Cash processes with INDUSTRIOS

    This webinar provides an overview of how INDUSTRIOS can help you handle business processes from the time an order is received to the point where it is converted to cash. Areas covered include: Navigation, Customers, Sales Orders, Shipping and Reporting.

    What's New - Inventory Control and Costing

    Eva DeGasperis, Principal at Industrios, and Jacques Decarie, Vice President of Sales and Marketing, take a deep dive into inventory control and costing. Hear Eva talk quantity constraints, unit tracking, cost elements, valuation methods, and much, much more.

    Webinar: How the Invisible Factory will help get you back on course

    As owner of a manufacturing company, you shouldn’t be on the shop floor. You’re needed at the helm, steering the business to where it needs to go. From software to human resources, here’s what IndustriOS’ Invisible Factory can do for you.

    Webinar: INDUSTRIOS on the Cloud

    Jacques Decarie, INDUSTRIOS, and Joe Cudzik, Expedient, explain your cloud options and address your questions about ERP. You’ll learn about accessibility 24/7 on any device, enhanced security, disaster recovery and much more.

    ERP Business Benefits for Manufacturers
    Practical Business Intelligence for Manufacturers