Export Data

Export Data

What you see is what you get exported. It is exporting the current Data Grid view. If you want flat data, switch to Flat View before exporting. In Tree View be sure to expand the nodes you want to see exported. The export data will be the same you are viewing, so be sure you are seeing all you want to see in export. Export data is in "Tab separated format" .tsv meaning it uses "TAB" to separate values during export. In Excel create new table, and just drag drop your .tsv file.

Read More

Data Grid Current Cost

Data Grid Current Cost

Get current cost for product. Crucial for COGS report, and crucial to populated with number value. This works in Orders, Products and Inventory view.

Skubana "currentCost"  field is value that is stored in Vendor Product or FIFO from your Purchase Orders. First it checks if there is a PO for the product to get the latest FIFO price, if there is no PO it checks for Vendor Cost in your Skubana store. 

This field is crucial for calculating COGS, and COGS report will not be available until you have all the Current Cost populated. 

Read More

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

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

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.

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

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