Posted on

Chart

Chart

Chart component will display in Chart view whatever is in Orders view.

It works only in Orders Tree View with grouped values. It charts the in Column chart two Columns per item.
It is showing [Sales Revenue, Cogs] as one column and [Tax, Shipping Revenue, Discounts and Sales Revenue + COGS]

chart view

 

 

Slider on left - Save StoreReport file format

Bottom scroll - Scrolls the displayed data.

Read More

Posted on

Menu

Menu

Save File - Save StoreReport file format

Load File - Load saved StoreReport file

Load aggregated data - Add new StoreReport data to already loaded data

Export data - Export data in CSV format for EXCEL or other software

Data Grid Layout - Save and Load your Data Grid layouts.

Read More

Posted on

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

Posted on

Error View

Error View

This component is searching for errors in Skubana data. The type of errors are some common ones we found in our usage scenario. Error View can help you clean your data and make better reports. Works only in Orders View.

Remove- Remove selected Items. It can remove items from data set, like removing wrong orders, test orders or anything that is making wrong calculations.

Change - Change any field on selected Item / Items [Multiple selection with SHIFT or CTRL + CLICK]. Mostly used to change currentCost field from zero, so we get accurate COGS report.

Today Cost - Used when Current cost is null. Meaning there was no Cost found on the day of the order. This will try to fetch the today data, so it gets the cost if it is added later, after order is placed.

*Merge with Parent - Used for fixing the Split Order issue. It will merge the selected item with its parent, that will fix the COGS report for that order. Still in test phase.

Read More

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