Reports: frequently asked questions

We’ve put together a list of frequently asked reporting questions that community members have gotten in touch with us about when working with popular reports.

Click a report below to jump to it!

Sales Reports

Inventory Reports

Sales Reports

Sales by Product Summary report

Does this report include deactivated items?

No – the Sales by Product Summary report doesn’t include deactivated items. This will impact the Cost of Goods Sold calculation in this report since your deactivated products aren’t counted towards it. 

Workaround: generate a Sales by Product Details report to include deactivated items.

  1. In the filter fields on the left side of the report, click into the Products field and then “Select products…”
  2. In the Product Selection screen, click into the Show field, select “Show All” and hit Refresh
  3. Move ALL the products in the left panel to the right panel, and hit Select then Generate Report

Sales by Product Details report

What does Sales Cost mean?

Sales Cost is the cost per unit of your product. 

How does inFlow generate the data for the Location column?

The location column displays the location that was recorded on the sales order, not necessarily where the product was in when it was sold. 

Sales Order Profit report

How does inFlow calculate the Cost column?

Cost is the product cost value + non-customer costs on the sales order.

How does inFlow calculate the Cost of Goods Sold column?

Unlike the Cost value, the cost of goods sold does not take into account non-customer costs. Please see here for a breakdown of how inFlow calculates the Cost of Goods Sold (COGS).

If you don’t have any non-customer costs on the sales order, you’ll find that the COGS and Cost values will be the same in the report.

Inventory Reports

Inventory Summary report

How does inFlow calculate Total Sales Value?

Total Sales Value is calculated based on your quantity owned, not quantity on hand (like in the Inventory Details report). 

Inventory Details Report

What does the Quantity field mean?

On this report, the Quantity field is your quantity on hand.

How does inFlow calculate Total Sales Value?

In this report, the Total Sales Value is calculated based on quantity on hand (this is different from the Inventory Summary report which calculates this value based on quantity owned). 

Historical Inventory report

How does inFlow calculate the Quantity Owned field?

This report calculates your quantity owned at end of day of the selected target date. Quantity owned is determined by shipping date if shipping is turned on, or invoice date if shipping is turned off.

In other words, the Historical Inventory Summary report records that a product is removed from inventory on the shipped or invoiced date.

Inventory Movement Summary

How does inFlow calculate the Quantity On Hand field?

This report calculates your quantity on hand at end of day of the selected target date. Quantity On Hand relies is determined by the pick date on a sales order. 

In other words, the Inventory Movement Summary report records that a product is removed from inventory on the picked date.

Inventory Movement Details

How does inFlow calculate the Quantity field? 

This report calculates your quantity on hand, which is determined by the order date.

In other words, the Inventory Movement Details report records that a product is removed from inventory on the order date.

NOTE: This report will not account for inventory that is not in a location (in transit, etc). 

 

Was this article helpful?

Yes
No

Thank you for your input, your feedback is important to us.

Thank you for your input, your feedback is important to us.  Please share some more information about why you find this article unhelpful.

  • This field is for validation purposes and should be left unchanged.