Posted on

Data Grid Filter

Data Grid Filter

Data Grid Filter is an advance filter component allows you to filter your data based on [IF,AND] statements and math conditions. You can filter comparing two fields or by fields value. 

Select Field - Select the field you want to filter by

Operator - Select your wanted operator [Contains, < , >, = , != …]

Value - Type in desired value, if second Option is selected, than value is not needed.

Select 2nd Field - Select this option if you want to compare between two fields. If you change it to a field, than you don't need to input any value for the filter because it will compare values from two selected fields.

"+" Button - Click button + on lower right to add one more AND statement. You can only add AND statements.

Filter Button - Click button Filter to filter out the data.

Read More

Posted on

Data Grid Custom Math Field

Data Grid Custom Math Field

Field Name - Name of the field that will be added to Data Grid fields list 

X to P - Assign fields to variables, only one can be used if needed

Enter Formula - Enter formula with assigned variables to make calculations for your new field. Like (x+y)/2

Read More

Posted on

Data Grid Summaries

Data Grid Summaries

This component is used for adding more summaries fields.

StoreReport uses "#" in front of field name to distinguish summary field. It can be any number field from Skubana data. It can also be any custom field that you have added. When you add new summary field it will be added to the end of the Data Grid Fields list. From there you can drag to the front and place between other summary fields, and hit Refresh Data Grid button.

 Be sure to add only line item fields.

Posted on

Data Grid

Data Grid

This component is used for displaying data. It is main view of StoreReport. What you make of Data Grid is what you get in export for Excel.

StoreReport uses Advance Data Grid for displaying data. Most custom work was done for the Orders View as we identified that it is where StoreReport is most useful, dealing with Orders issue and Orders Export.

Read More

Posted on

Data Grid Fields

Data Grid Fields

This component is used for arranging the Data Grid display. The way Data Grid component is displaying data.

StoreReport gives you access to all the data provided by Skubana. To make it easier to work with huge amounts of information tied to one line of data, we made this advance list component. In the top list we show all the data visible in Data Grid, in bottom list we show all the available fields from Skubana with additional helper fields that we setup - StoreReport fields.

Read More

Posted on

Loading Purchase Orders

Load Purchase Orders

Purchase Order Number - Input PO numberLoadPO

Status - Use Dropdown selector to choose status

Created Date - Search Skubana PO creation date From - To

Modified Date - Search the modification of PO date From - To

Read More

Posted on

Loading Inventory

Loading Inventory

Product ID - Input product ID, or more separated with ","LoadInventory

Product SKU -  Input product SKU, or more separated with ","

Stock Location Name - Search by Stock location name

Warehouse ID - Search by warehouse location ID

Created Date - Search the Product created date From - To

Read More

Posted on

Loading Products

Load Products

Product SKU  - Input product SKU, or more separated with ","

Product UPC - Input product UPC, or more separated with ","

Stock Location  - Search by Stock location ID

Warehouse ID - Search by warehouse location ID

Created Date - Search the Product created date From - To

Modified Date - Search the Product modified date From - To

Read More

Posted on

Loading Orders

Load Orders

Loading Orders component for working with Skubana Orders API.

Order Number - Input order number, or more order numbers separated with ","

StoreReport Load Orders User Interface
Order Date - Search From - To date.

Created Date - Search Skubana Order creation date From - To

Modified Date - Search the modification of Order date From - To

Shipped Date - Search the Order shipped date From - To

Payment Date - Search the Order payment date From - To

Read More