Grid Features

User may insert/delete/update data in a grid using buttons at the bottom of the grid

Grid View

EDIT

Edit Mode

All the input tables are editable, user may edit any row by double clicking that row or selecting a row and press ‘F2’ upon it.

INSERT

Insert Mode

User can add a new row, a blank row as shown in figure below is present in all input tables at the bottom. User can fill this blank row and hit Enter to insert the data.

DELETE

Delete Icon User may delete single row or multiple rows using delete button. This feature is available only for input tables. User needs to first select rows and then click on Delete button.

EXPORT DATA

Export Icon User can download data in excel format.

IMPORT DATA

Import Icon User can upload excel in same format as it was downloaded, this will replace all the existing data with excel data, sheet name of the excel should be same as table name.

Note

With every import system will replace existing data.

SHOW SUMMARY

show_summary_icon This will add a summary row for the table calculating totals where applicable.

Note

Shortcut key is F4.

ADD NEW COLUMN

add_new_col_icon User may add user defined column in any input table which can be used for reporting.

add_new_col_panel
User needs to specify column name and column type (text/numeric).

DELETE COLUMN

del_col_icon User can delete any user defined columns.

del_col_panel
System will provide list of user defined column for the respective table, user may choose one column at a time to delete.

REFRESH GRID

refresh_icon This will reload grid clearing sort and filters.

CHOOSE COLUMNS

hide_col_icon User may choose columns to show/hide using this option. User may also reorder columns using this option.

hide_col_panel
User may select on “-“ button in the right pane to hide columns and “+” button in the left pane to show columns. User may also drag column bars vertically for display order.

Note

Do not hide underlined (mandatory) columns.

DECREASE DECIMALS

dec_deci_icon User may choose to hide decimals for any numeric column. User needs to select column by clicking on column header and then click on “>” button.

INCREASE DECIMALS

inc_deci_icon User may choose to show hidden decimals using this option. User needs to select column by clicking on column header and then click on “<” button.

MULTI SELECT

multi_sel_icon User may select all rows or select/deselect specific rows to delete or update the table.

MULTI UPDATE

multi_update_icon User may use this option to update multiple rows with same values. User first need to select the column and then click on multi update button. User may also choose to select rows on which update operation applies.

APPLY FILTERS

apply_filters_icon User may apply custom filter based on different column and different conditions.

apply_filters_panel

SHOW APPLIED FILTERS

show_filters_info_icon It will show what all filters user has applied.

show_filters_info_panel

CREATE GROUP

create_group_icon It will create group for the selected rows, it is applicable only for item and location tables.

create_group_panel
User needs to specify group name and group type. For item table, it will have only one group type. For location table, it will have Facility and Customer as group type.

THOUSAND SEPARATOR

thousand_sep_icon User may choose numeric column and use this feature to display values with thousand separators. User needs to select column by clicking on column header and then click on ’ button.

PAGE SUMMARY AND TOTAL ROW COUNT

page_summary
User can see total record counts in the display below and may navigate to other pages using this feature.

GRID FILTERS

User can search or filter records in table in three ways:

  • Quick Search: User can search for a string in any column, it is not case sensitive.

col_search_filter

  • Filter Values: User can choose any column and select one or multiple values from the LOV.

col_specific_filters

  • Custom Filter: User can choose custom filter to apply filters like “begin with”, “ends with”, “greater than”, “less than” etc.

All the three types of filters can be applied at the same time.

GRID SORT

User may sort the data in ascending/descending order based on any column.

order_by
To sort, user needs to click on highlighted button as shown in image above.

NOT NULL COLUMNS

not_null_cols
User will notice underlined columns in each table, these are NOT NULL columns and it is mandatory to fill data in these columns.

Define Constraint

define_constraint_icon It will create group for the selected rows, it is applicable only for item and location tables.

define_constraint_icon
User may select SKU/Brewery/Market or it’s categories from the provided frontend to build constraints for a group of SKU/Brewery/Market