Blog

Customizing Grids in Syspro Avanti

This tutorial demonstrates how to customize grids within SYSPRO Avanti. You will learn to customize a grid today.

Go to 10.88.78.245

01

Introduction

Introduction

Video content

Jump to this step in video

02

Open Sign In Menu

Enter your login credentials to begin accessing your SYSPRO Avanti account.

Open Sign In Menu

03

Confirm Sign In

Click the Sign in button to proceed with logging into SYSPRO Avanti.

Confirm Sign In

04

Access Home Menu

Click the hamburger menu to navigate to the Menu in SYSPRO Avanti.

Access Home Menu

05

Open Program Search

Click the Search for a program field to locate specific modules within SYSPRO Avanti.

Open Program Search

06

Enter Customer Query

We will use Customer Query today to customize a grid.

Enter Customer Query

07

Pause

Pause

Video content

Jump to this step in video

08

Navigate to Customer Query

Click the specified area to open the Customer Query section in SYSPRO Avanti.

Navigate to Customer Query

09

Enter Customer Code

Enter your customer code to filter customer records in the query.

Enter Customer Code

10

Choose Customer

Select your customer from the list to view detailed information.

Choose Customer

11

Open Movements Tab

Selec the Movements tab to review transaction history for the selected customer.

Open Movements Tab

12

Pause

Pause

Video content

Jump to this step in video

13

Access Additional Options

Click the indicated area to reveal more options in the Customer Query interface.

Access Additional Options

14

Add Custom Columns

Click Add Custom Columns to customize the data displayed in your query results.

Add Custom Columns

15

Open Column Selection

Click the selection dropdown to choose columns to add to your query view.

Open Column Selection

16

Select Stock Code Column

Select the stock code column to include product identifiers in your query results.

Select Stock Code Column

17

Select Size Column

Select the size column to display product size information in the query.

Select Size Column

18

Select Look Ahead Window

Click the Look ahead window option to adjust the data range for your query.

Select Look Ahead Window

19

Pause

Click add column and you can see that your custom column has been added.

Pause

Video content

Jump to this step in video

20

Open Marketing Tab

You can rearrange columns by a simple drag and drop

Open Marketing Tab

21

Reopen Marketing Tab
Reopen Marketing Tab

22

Select Invoice Date

Click the Invoice date field to filter transactions by date.

Select Invoice Date

23

Access Filter Options

Click the three dot to open filter options for refining your query.

Access Filter Options

24

Choose Equality Filter

Click Is equal to to set the filter condition for your query.

Choose Equality Filter

25

Open Filter Input

Click the indicated area to enter filter criteria.

Open Filter Input

26

Enter Filter Criteria

Enter your filter criteria to narrow down query results.

Enter Filter Criteria

27

Click to Proceed

Click the three dots again to advance in the query interface.

Click to Proceed

28

Open Conditional Formatting

Click Conditional Formatting to customize how data is visually displayed.

Open Conditional Formatting

29

Select Sales Order Column

Click the Sales order column to include order details in your query.

Select Sales Order Column

30

Select Unit Price Column

Click the Unit price column to display pricing information in the query results.

Select Unit Price Column

31

Click to Continue

Click the indicated area to proceed with formatting options.

Click to Continue

32

Click to Confirm

You can customize column colors to easily find your data.

Click to Confirm

33

Apply Changes

Click Apply to save and implement your formatting changes.

Apply Changes

34

Click to Proceed

Click the save button to save your changes.

Click to Proceed

35

Click to Continue

You can export your data to PDF

Click to Continue

36

Click to Finalize

Or you can export to a CSV file.

Click to Finalize

Closing Out the Year Strong: 5 ERP Moves to Make Before Q4 Ends

The year-end rush is a stress test for your ERP. Orders spike, inventory counts loom, and finance is already thinking about close. For manufacturers and distributors, Q4 shows you which parts of your system are carrying the business and which are quietly holding it...

Manage Supplier Data And Transactions In Syspro Avanti

01 Sign In To Syspro Avanti Hello, today we're going to talk about Syspro Avanti, master data, and how you can view, edit, and add new suppliers into your Syspro Avanti system. First, we'll enter our credentials and hit sign in. Video content Jump to this step in...

Personalizing your Epicor Kinetic Home Screen

You will learn how to navigate the Home page and access key features within the Epicor ERP system. 01 Log In To Home Page Click the Log in button on the Home page to access your account and begin the process. 02 Click Navigation Link Click the 3 dots to access the...

Syspro Avanti Login and Dashboard Customization

This tutorial guides you through accessing SYSPRO Avanti and customizing your dashboard. 1. Introduction First let's login to your Syspro account by entering your credentials. Video content Jump to this step in video 2. Complete Sign-In Click "Sign in" to submit your...

epicor Kinetic Overview

As Epicor transitions away from the traditional client, all users will be working on the Kinetic web interface. The web version provides the same core functionality you're familiar with, but with a modern browser-based experience that can be accessed from anywhere...

5 Ways Better ERP Processes Can Help Reduce Phantom Stockouts

Phantom stockouts are one of the most frustrating inventory challenges manufacturers and distributors face because the inventory appears available in the system but cannot actually be found, allocated, or shipped when needed. The result is often production delays,...

Crawford Software to Attend Epicor Insights 2026 as Gold Sponsor

LONDONDERRY, N.H., April 13, 2026  -- Crawford Software, announced today that it is a Gold sponsor of Epicor Insights 2026, the cloud ERP company's annual global customer conference held this year May 18 – 21, 2026 at Gaylord Opryland Resort & Convention Center in...