After understanding the basics of creating a simple inventory view report, you can continue to build your simple inventory view reports with more dimensions to provide additional data and visibility for your inventory.

Setting up the report

When you reorder products, some vendors might require additional time to fulfill orders for specific categories. Because of this, you may want to order more inventory in these categories than your typical categories. To do this, you can use your first simple inventory views report to add a Top Level Category as a dimension and run the report:

1. Run a Dusty report.
2. Remove the filters: Is Dusty, and Quantity is greater than zero.
3. Add a filter of Sale > Completed Date days since sold is equal to or greater than 60.
4. Optionally, you can change the default row limit from 500 to 5,000.
5. Remove the measures Days Since Sold, Days Since Received, Total Cost, and Total Inventory.

6. Add the measures Sale Lines > Totals > Quantity Sold. For this report, you don't need Quantity on Order and Quantity in Stock

   

Now you've set up the report, you have a few main categories that display in the results, and you can continue to add IF statements to your report.

Adding IF statements to the report

If, for example, you have components that need to be reordered at a higher volume than the other categories, and you want to replenish the stock of standard products at 50% of the quantity sold, and component products at 75% sold, you'll need to use IF statements.

IF statement needs to be formatted like: if( criteria ,result if true ,result if false )

In this example, the calculation should look like:

if( Product Category is "Components" ,re-order 75% ,re-order 50% ) 

To start adding the IF statements:

1. Click Calculations from the Data header bar.

2. In the calculator, type If(Category) and select the Top Level Category to find instances where the top-level category is components.

   

3. Enter an equal sign (=) after the Top Level Category bracket.
4. Search and add "COMPONENTS". Ensure you have the quotation marks and the word is capitalized, or you may receive an error message.
   

5. After "COMPONENTS", in the existing bracket, search and add quantity sold, enter *0.75, (to represent the 75% reorder quantity sold you're looking for), and another comma.

   

6. Next, after 0.75, in the existing bracket, search and add quantity sold, and enter *0.50, (to represent 50% quantity sold).

   

Your report will now include a new column with the calculation. You can rename the column title, for example, Reorder amount.

You can enhance your report even further by adding calculations to track what's coming in, what's currently in stock, and rounding out decimal results for improved readability.

The accuracy of your analytics directly depends on the consistency of the data in your Lightspeed account. Errors such as duplicate categories, unassigned products, or outdated data from unsynced changes can cause your results to differ from what you expect. While advanced calculations can help correct for some anticipated inconsistencies, such as using lowercase versions of words or checking a second criterion if the first is inconsistent, they can only do so much. The most effective way to ensure powerful and accurate analytics is to maintain consistent and clean data.