- \n
- Sales by Product Summary report<\/span><\/a><\/li>\n
- Sales by Product Details report<\/span><\/a><\/li>\n
- Sales Order Profit report<\/span><\/a><\/li>\n<\/ul>\n
Inventory Reports<\/strong><\/p>\n
- \n
- Inventory Details report<\/span><\/a><\/li>\n
- Inventory Summary report<\/span><\/a><\/li>\n
- Historical Inventory report<\/span><\/a><\/li>\n
- Inventory Movement Summary report<\/span><\/a><\/li>\n
- Inventory Movement Details report<\/span><\/a><\/li>\n<\/ul>\n
Sales Reports<\/span><\/em><\/h2>\n\n
Sales by Product Summary report<\/b><\/h3>\n
Does this report include deactivated items?<\/strong><\/p>\n
No – the Sales by Product Summary report doesn’t include deactivated items. T<\/span>his will impact the Cost of Goods Sold calculation in this report since your deactivated products aren’t counted towards it.\u00a0<\/span><\/p>\n
Workaround: generate a Sales by Product Details report to include deactivated items.<\/span><\/p>\n
- \n
- In the filter fields on the left side of the report, click into the Products<\/em> field and then “Select products…”<\/li>\n
- In the Product Selection screen, click into the Show<\/em> field, select “Show All” and hit Refresh<\/em><\/li>\n
- Move ALL the products in the left panel to the right panel, and hit Select<\/em> then\u00a0Generate Report<\/em><\/li>\n<\/ol>\n<\/blockquote>\n\n
Sales by Product Details report<\/b><\/h3>\n
What does\u00a0Sales Cost<\/em> mean?<\/strong><\/p>\n
Sales Cost<\/em>\u00a0is the cost per unit of your product.\u00a0<\/span><\/p>\n
How does inFlow generate the data for the\u00a0Location<\/em> column?<\/strong><\/p>\n
The location column displays the location that was recorded on the sales order<\/a>, not necessarily where the product was in when it was sold.\u00a0<\/span>
\n<\/a><\/p>\nSales Order Profit report<\/b><\/h3>\n
How does inFlow calculate the Cost<\/em> column?<\/strong><\/p>\n
Cost\u00a0<\/em>is the product cost value + non-customer costs on the sales order.<\/p>\n
![\"\"](\"https:\/\/onpremise.inflowinventory.com\/support\/wp-content\/uploads\/sites\/4\/2014\/05\/39913594_1.png\")
<\/div><\/p>\nHow does inFlow calculate the\u00a0Cost of Goods Sold\u00a0<\/em>column?<\/strong><\/p>\n
Unlike the\u00a0Cost<\/em> value, the cost of goods sold does not take into account non-customer costs.\u00a0Please see here<\/a> for a breakdown of how inFlow calculates the Cost of Goods Sold<\/em>\u00a0(COGS).<\/p>\n
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. <\/span><\/p>\n
Inventory Reports<\/span><\/em><\/h2>\n\n
Inventory Summary report<\/b><\/h3>\n
How does inFlow calculate Total Sales Value<\/em>?<\/strong><\/p>\n
Total Sales Value is calculated based on your quantity owned<\/a>, not<\/em>\u00a0quantity on hand (like in the Inventory Details report).\u00a0<\/span>
\n<\/a><\/p>\nInventory Details Report<\/b><\/h3>\n
What does the Quantity\u00a0<\/em>field mean?<\/strong><\/p>\n
On this report, the Quantity\u00a0<\/em>field is your quantity on hand<\/a>.<\/span><\/p>\n
How does inFlow calculate\u00a0Total Sales Value<\/em>?<\/strong><\/p>\n
In this report, the Total Sales Value<\/em> is calculated based on quantity on hand<\/a> (this is different from the Inventory Summary report which calculates this value based on quantity owned).\u00a0<\/span>
\n<\/a><\/p>\nHistorical Inventory report<\/b><\/h3>\n
How does inFlow calculate the\u00a0Quantity Owned<\/em> field?<\/strong><\/p>\n
This report calculates your quantity owned<\/a> at\u00a0end<\/em>\u00a0of day\u00a0<\/em>of the selected target date. Quantity owned<\/em> is determined by shipping date if shipping is turned on, or invoice date if shipping is turned off.<\/p>\n
In other words, the Historical Inventory Summary report records that a product is removed from inventory on the shipped or invoiced date.
\n<\/a><\/p>\nInventory Movement Summary<\/b><\/h3>\n
How does inFlow calculate the\u00a0Quantity On Hand\u00a0<\/em>field?<\/strong><\/p>\n
This report calculates your quantity on hand at\u00a0end<\/em>\u00a0of day\u00a0<\/em>of the selected target date. Quantity On Hand<\/em>\u00a0is determined by the pick date on a sales order.\u00a0<\/span><\/p>\n
In other words, the Inventory Movement Summary report records that a product is removed from inventory on the picked date.
\n<\/a><\/p>\nInventory Movement Details<\/b><\/h3>\n
- In the Product Selection screen, click into the Show<\/em> field, select “Show All” and hit Refresh<\/em><\/li>\n
- Inventory Summary report<\/span><\/a><\/li>\n
- Sales by Product Details report<\/span><\/a><\/li>\n