Grid Features

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

EDIT

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

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

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

User can download data in excel format.

IMPORT DATA

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

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

Note

Shortcut key is F4.

ADD NEW COLUMN

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

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

DELETE COLUMN

User can delete any user defined columns.

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

REFRESH GRID

This will reload grid clearing sort and filters.

CHOOSE COLUMNS

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

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

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

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

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

MULTI UPDATE

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

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

SHOW APPLIED FILTERS

It will show what all filters user has applied.

CREATE GROUP

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

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

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

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.

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

• 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.

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

NOT NULL COLUMNS

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