Inventory Evaluation

Inventory Evaluation

Inventory Evaluation Report

Reports -> Inventory Reports -> Inventory Evaluation Report

To keep an eye on your product inventory, the inventory reports must track the available stocks, total cost, and price. 
FTx Cloud POS reports provide different types of inventory reports that can give details of the stocks on hand, total cost, and retail price. You can generate reports by applying the custom filter options and many other customization options to keep an eye on your inventory. Different options are provided to bifurcate the records of the generated inventory reports.

In this technical document, you will see how to generate the "Inventory Evaluation Report" using the filter options and price calculation with margins.

1. Reaching the Inventory Evaluation Reports


To reach the Inventory Evaluation Report, follow the steps below:
  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Reports
  4. Step 4: Choose Inventory Evaluation

                                                                                      Figure 1

2. About Inventory Evaluation Reports

When you click on "Inventory Reports" from the left navigation panel, you will see the empty report data results. By default, another type will be selected in the "Choose Report" drop-down. 


                                                                                        Figure 2.1

You can generate your desired reports with different statics by selecting the inventory report types [Choose Reports] and setting up the filters.

                                                                                         Figure 2.2

You will get many types of inventory reports that will be useful to any retail business. By clicking the "Choose Report" drop-down selection, you will see the different types of inventory reports.

3. Generating the Inventory Evaluation Report

Now, let's generate the Inventory Evaluation Report. Follow the steps below to generate the Inventory Evaluation Report (See Figure 3.1 below): 
  1. From the "Inventory Reports" page, you will see the "Choose Reports" drop-down selection.
  2. By clicking the drop-down selection, you will see different types of inventory reports in alphabetical order.
  3. Search for "Inventory Evaluation" from the list and click on it.

                                                                                         Figure 3.1

Once you click the "Inventory Evaluation" report type, you will get the relevant filter options to customize the inventory report accordingly. You have many bifurcation options to generate the reports and check the different statics of the inventory.


                                                                                                       Figure 3.2
From the above Figure 3.2
  1. Customer filters, grouping, and other filter options.
  2. Bifurcate options for the Inventory Evaluation Report.
    1. Note: The custom filters and bifurcation options might vary as per the type of report selection.
  3. By clicking "Generate Report" from the top-right corner, the Inventory Evaluation Report will be generated and appear on the screen. See Figure 3.3.

After generating the report, check the "Inventory Evaluation Report" with the predefined selection of filter options (the system's default selection, and without any custom filter option setup).

You will see the overall total available stocks (QOH) with the Total Retail, Cost, and Margin ($).


                                                                                                                        Figure 3.3

Now, tick the "Show Details" button and then click the "Generate Report" button to check the inventory report with product details.



                                                                               Figure 3.4

You will see the following sales data in tabular format when you generate the Inventory Evaluation Report (Above in Figure 3.4): 
  1. UPC: This represents the item's UPC that was inserted during the product creation. The UPC is scanned and sold on the register. This is the actual product sold to customers.
  2. Product Name: This represents the name of the product.
  3. Vendor Part: This represents the vendor part number of the product that is received on an invoice and adds products to the store's inventory to be sold to customers.
  4. QOH: This represents the current stock of each product.
  5. Retail Each: This represents the retail price per product. Although the retail price for each product will vary as per price book zones, the highest retail price will be displayed here.
  6. Total Retail: This represents the total retail price of available stocks (QOH).
    Total Retail = QOH x (multiply) Retail Each (retail price per product), i.e., Calculation for Black Big [CTN] product 3020 (QOH) x 23.50 (Retail Each) = $ 70,970 (Total Retail)
  1. Cost Each: This represents the cost per product. Although the cost for each product will vary according to pricebook zones, the highest product's cost will be displayed here.
  2. Total Cost: This represents the total product's cost of available stocks (QOH).
    Total Cost = QOH x (multiply) Cost Each (retail price per product), i.e., Calculation for Black Big [CTN] product, 3020 (QOH) x 22.00 (Cost Each) = $ 66,440 (Total Cost)
  3. Profit ($): This represents the total profit in $ amount as per the calculation between [Total Retail -  (minus) Total Cost] of a product.
  4. Margin (%): This represents the margin that gains or loses in percentage. % Margin will calculate the margin against the Total Retail in percentage.
    Margin in percentage = [Profit/(divided) Total Retail] * 100,     i.e., Calculation for % Margin for Black Big [CTN], $ [4,530 (Profit) / 71,970 (Total Retail)] *100 = 6.38 % (Margin in %)
  5. Grand Totals: This calculates the totals of all the available stocks for each product, including the total retail, cost, and profit that would be earned after selling the products.
Note: The data in the Inventory Evaluation Report is generated based on the current stocks at different stores (locations).

4. Report Filter Options


Now, let's understand the custom filter options to generate the Inventory Evaluation Report by setting up specific criteria.

4.1 Custom Filters for Items

Now, let's see how to filter the items to generate the desired Inventory Evaluation Report. You will see the "Filter Items" drop-down option, from which you can customize the item selection.


                                                                                   Figure 4.1.1

You will find the two options from the "Filter Items" drop-down selection:
- Show All: It considers all the data (criteria) to generate the report. The "Manage" button will be disabled for this option. By default, this option will be pre-selected.
- Custom Filter: To customize the items for the report, you need to select the "Custom Filter" option. Once you select it, the "Manage" button will be enabled to set up the filters.

                                                                                           Figure 4.1.2

By clicking the "Manage" button, a "Manage Filters" window will pop up. You will see the following details: (See Figure 4.1.3 below.)

  1. You will see the different tabs to filter the items for the Item Inventory Evaluation Report. You can choose the required records by navigating the tabs individually to generate your Desired Inventory Evaluation Report.
  2. You can select the saved custom filter from the drop-down selection. The "Manage Filters" button will open the list of the saved custom filters.
  3. You can see the UPC list (items) when the "UPC" tab is selected.
  4. You will find the checkbox along with all the records. You need to select the items from the list and move to the "Selected List" area on the right side.

                                                                                             Figure 4.1.3

Once you select the records from the list, click on the green right-sided arrow ("Move" button) to move the records to the "Selected List" area.


                                                                                           Figure 4.1.4

By clicking the "Move" button, the selected records will be moved to the "Selected List." So, the Inventory Evaluation Report will be generated with the selected records only.
You can remove any record from the list by clicking the "remove" (x) icon. If you want to remove the whole selection, click the "Clear Selection" button. 


                                                                                   Figure 4.1.5

Selected List: You will have one flag to decide whether you want to "include" or "exclude" the selected records when the Inventory Evaluation report is generated.
  1. Include: If the flag is selected to "Include," it means the inventory Evaluation Report will be generated by applying the selected records. See Figure 4.1.5 above.
  2. Exclude: If the flag is selected to "Exclude," it means the inventory Evaluation Report will be generated but ignore the selected records. It will consider the selected records that need to be excluded to generate the sales report and the left-side records for reports.
    See     Figure 4.1.6 below.

                                                                              Figure 4.1.6

When you need to avoid some of the records in the inventory Evaluation Report that are not required, you can select those few records from the list (from the left side to the right side) and select "Exclude." So when the report is generated, you will not see inventory details for the records in the Inventory Evaluation Report.

Similarly, you can filter and set up the records for other tabs (parameters). Once the specific records are selected from the filter options (tabs), you can generate the Inventory Evaluation Report by clicking the "Apply" button and then the "Generate Report" button from the main page.


                                                                         Figure 4.1.7

4.1.1 Save & Manage Custom Filter

You can also save the configured custom filters for future use. By clicking the "Save Filters" button, a pop-up will appear asking you to enter the name of the custom filter.


                                                                                 Figure 4.1.1.1

Enter the name of the custom filter and click the "OK" button to save it.

Saved Filter:
The saved custom filters will appear in the drop-down selection. You can select the required custom filter from the list for the inventory report.


                                                                                    Figure 4.1.1.2

Manage Filters:
You can check and manage the filters by clicking the "Manage Filters" button. By clicking on it, you will see a listing of the saved custom filters in a pop-up.



                                                                                        Figure 4.1.1.3

Select Filter: You can select any filter from the list to generate the desired Inventory Evaluation report. Select the filter from the list and then click on the "Select Filter" button.
Delete: You can delete any filter from the list that is no longer required. Select the filter and then click on the "Delete" button.

4.1.2 Search Records

Search Edit Box: You can search for a specific record by entering text. You will see this search box in all the tabs (parameters).
Select Parent-Child: You can filter the UPC list records by selecting All Items, Child Only, Parent Only, or Standalone Only. You will see this drop-down selection only for UPC (product selection).
Select Active-Inactive: You can filter the list of records for many tabs (parameters) by selecting Active Only, Inactive Only, or All Records.


                                                                                        Figure 4.1.2.1
In this way, the "Custom Filter" options (tabs) help to customize the item records and set up the options to get only the required data for the Inventory Evaluation report.

4.2 QOH Filter

Now, let's check the inventory report by filtering the QOH values.

You can get the specific UPCs (products) in the inventory Evaluation report by selecting the pre-defined QOH values from the "QOH Filter" drop-down selection. You will have the following QOH pre-defined values:
Show All Items | Only Items > 0 | Only Items < 0 | Only Items >=0 | Only Items <=0 | Only Items = 0 | Only Item <> 0


                                                                                     Figure 4.2

Show All Items: This option will be pre-selected. This will show all the products when you generate the report.
Only Items > 0: By selecting this option, only products with positive stocks will be displayed when the report is generated. (positive stocks only).
Only Items < 0: By selecting this option, only products with negative stocks will be displayed when the report is generated. (negative stocks only).
Only Items >= 0: By selecting this option, the products with zero stocks and positive stocks will be displayed together when the report is generated. (Zero and positive stocks only)
Only Items <= 0: By selecting this option, the products with zero stocks and negative stocks will be displayed when the report is generated. (zero and negative stocks only)
Only Items <> 0: By selecting this option, the product with positive and negative stocks will be displayed when the report is generated. (Hiding 0 stock products)

4.3 Group By

Now, let's see how to check the Inventory Evaluation Report using different grouping options.
You can check the data in the Inventory Evaluation Report by dividing the group as well. You will have the following grouping options to generate the report in a group:
UPC | Departments | Category | Manufacture | Tag | Department/Store Totals (See Figure 4.3.1)

4.3.1 Group By UPC

When you generate the inventory Evaluation report, by default, it will be generated with the "Group By UPC" pre-selection. The report will show the UPC (item) wise sales data.



                                                                                            Figure 4.3.1

4.3.2 Group By Departments

If you select "Group By Departments," you will see the department-wise inventory data in the report. The items in the same department will be displayed under the specific department when you generate the Inventory Evaluation Report.


                                                                                           Figure 4.3.2

4.3.3 Group By Category

If you select "Group By Category," you will see the product's category-wise inventory data in the report. You can check the inventory data in the report at the category level. You need to select the level from the "Category Depth" drop-down selection. When you select "Group By Category," by default, Show All will be pre-selected.


                                                                                             Figure 4.3.3.1

Category Depth: When you select "Group By Category," this drop-down option will be enabled. This drop-down option lists the level (depth) of the categories. So, by selecting the specific depth, the inventory Evaluation report will display only those inventory data under the selected depth (level).


                                                                                  Figure 4.3.3.2

4.3.4 Group By Manufacturer

If you select "Group By Manufacturer," you will see the manufacturer-specific inventory data in the report.


                                                                                               Figure 4.2.4


Note: If the manufacturer is not assigned to the products, the inventory data for those products will be displayed under the "Not Available" group.

4.3.5 Group By Tag

If you select "Group By Tag," you will get the tags-wise inventory data in the group that is entered in the product details. When you select "Group By Tag," the Specific Tag Group will be enabled. Currently, you will see "All Tag Groups" by default.


                                                                                            Figure 4.2.5
So, the inventory data will be grouped in the report as per the tags that are inserted in the product details.

4.3.6 Group By Department/Store Totals

If you select "Group By Departments/Store Totals," you will see the total on-hand stocks (QOH) with Total Retail, Cost, and Margin ($) for the specific department.

                                                                                        Figure 4.3.6

4.4 Group By Location

You can filter the inventory report based on specific locations (stores). You will see a "Group By Location" drop-down from where you can select the "Location".
By default, "None" will be pre-selected. It means the inventory report will be generated for all the stores (locations).

                                                                                                              Figure 4.4.1
Once the "Location" specific report is generated, you can check the inventory data for the specific stores (locations) separately. So, you can check the total product stocks for a single store.

4.5 Filter Locations & L. Groups

You can generate the Inventory Evaluation Report by setting up the specific location and location group filters. For that, you will see the filter button for "locations" in the top-right corner.


                                                                                             Figure 4.5.1

By clicking that button (for the filter location), a "Manage Filters" window will pop up. You will see the following details: (See Figure 4.5.2 below.)

  1. Select the saved custom filter from the drop-down selection. The "Manage Filters" button will open the list of the saved custom filters.
  2. You will see the two tabs: "Store" and "Location Group"
  3. You can see the list of stores (locations) along with the checkbox. If there is a long list of stores, you can easily search by entering the name in the "Search" text box.
  4. Select the record(s) by ticking the checkbox.

                                                                                      Figure 4.5.2
Once you select the stores from the list, click on the green right-sided arrow (the "Move" button) to move the store records to the "Selected List" area. See Figure 4.5.3.


                                                                                      Figure 4.5.3
By clicking the "Move" button, the selected stores will be moved to the "Selected List," which means the inventory report will consider the inventory data of the selected stores.

You can remove any store from the list by clicking the "remove" (x) icon. If you want to remove the whole selection, click the "Clear Selection" button. (See Figure 4.5.4 below.) 

                                                                                     Figure 4.5.4
Similarly, you can select the required location group(s) by navigating to the "Location Group" tab.

Once the specific records are selected from the filter options (tabs), you can generate the Inventory Evaluation report by clicking the "Apply" button and then the "Generate Report" button from the main page.

                                                                                         Figure 4.5.5
You can save it as a filter record for future use by clicking the "Save Filters" button. When you click the "Save Filters" button, a pop-up will appear asking you to enter the name of the location filter. (See Figure 4.5.6 below.)

                                                                                       Figure 4.5.6

Saved Filter:
The saved custom filters will appear in the drop-down selection. You can select the required custom filter from the list to generate the inventory report.

                                                                                                   Figure 4.5.7
Manage Filters:
You can check and manage the filters by clicking the "Manage Filters" button. By clicking on it, you will see a listing of the saved custom filters in a pop-up.


                                                                                                   Figure 4.5.8

Select Filter: Select any filter from the list to generate the desired Inventory Evaluation Report. You need to select the filter from the list and then click on the "Select Filter" button.
Delete: You can delete any filter from the list that is no longer required. Select the filter and then click on the "Delete" button.

When you set up the filters for locations (stores) & location groups, by hovering the mouse cursor over the filter button, you will see the selected details.


                                                                                                   Figure 4.5.9

In this way, the location-specific custom filter options help to customize the data for the Inventory Evaluation Report by selecting specific stores (locations) and/or location groups.
Note: "4.4 Group By Location" will group the inventory data based on Locations. While "4.5 Locations & Location Groups" custom filter option sets up a specific data selection, and the inventory data will be generated in the report as per the selected locations (stores) and/or location groups only.

4.6 Sort By

You will get the sorting option to sort the report data in ascending or descending order and apply it to the product name or UPC.

By clicking the "Sort By" option, you will see the four options to sort the inventory data accordingly. Name Ascending | Name Descending | UPC Ascending | Descending


                                                                                               Figure 4.6.1

5. Bifurcate Options for Report (Checkboxes)

You can enable the required options for the inventory report that are provided with the checkboxes. When you select the Inventory Evaluation Report, you will see the pre-selected filter and bifurcate options by default. You will see "Show Cost" and "Show Price" pre-selected.

                                                                                                   Figure 5

5.1 Show Details

Tick the "Show Details" checkbox to display the products on the list. By ticking the "Show Details" checkbox and generating the report, you will see the products with the quantities on hand in the Inventory Evaluation report.


                                                                                                   Figure 5.1
You will see the Vendor Part Num, Available Stocks (QOH), Profit ($), and Margin (%) in the inventory Evaluation report.

5.2 Show Cost

Tick the "Show Cost" checkbox to check the cost of each product. By ticking the "Show Cost" checkbox and generating the report, the two columns "Cost Each" and "Total Cost" will be displayed in the Inventory Evaluation report.

                                                                                                   Figure 5.2
The "Cost Each" column shows the cost of each product, and the "Total Cost" column shows the total cost as per available stocks (QOH) for each product.

5.3 Show Price

Tick the "Show Price" checkbox to check the retail price of each product. By ticking the "Show Price" checkbox and generating the report, the two columns "Retail Each" and "Total Retail" will be displayed in the Inventory Evaluation report.


                                                                                                   Figure 5.3.1
The "Retail Each" column shows the applicable retail price of each product, and the "Total Retail" column shows the total amount of retail price as per available stocks (QOH) for each product.
Note: If you have selected the "Show Cost" and/or "Show Price" checkboxes only, you will see the overall Total Retail and/or Total Cost with total stocks (QOH) and Margin ($) in the Inventory Evaluation Report.


                                                                                                   Figure 5.3.2

5.4 Adjust Buydown from Cost & Price

By ticking the "Adjust Buydown from Cost & Price" checkbox and generating the report, you will see the inventory data of the cost & price after applying the buydown.

Before enabling the "Adjust Buydown from Cost & Price" checkbox, you can see the applicable cost and retail price for each product in the Inventory Evaluation Report.


                                                                                                   Figure 5.4.1

After enabling the "Adjust Buydown from Cost & Price" checkbox, you can see the applicable cost and retail price after adjusting the buydowns in the inventory data.


                                                                                          Figure 5.4.2
The buydown is adjusted as per configuration from Pricebook -> Discounts/Buydowns -> Buydowns.

5.5 Snapshot Report

By ticking the "Snapshot Report" checkbox, you can check the inventory QOH details for a specific date. Once you tick the "Snapshot Report" checkbox, the date selection will be visible.
- Select the date and generate the report to check the inventory-QOH details for that specific date.


                                                                                                 Figure 5.5.1

Once the report is generated, you can see the snapshot report data as per the selection of the other filters and checkboxes.


                                                                                       Figure 5.5.2

You can see the inventory-QOH details for the selected date if there is movement in the products, i.e., if products are sold at POS or added to inventory (adjustment).
In this way, you can set up multiple custom filter options and enable bifurcation options [checkboxes] at the same time to get the required inventory evaluation report in different combinations.

5.6 Rollup Links

Rollup Links: This filter will merge the related parent and child items to give you the total quantity on hand of the product in decimal format.

                                                                                               Figure 5.5.3

    • Related Articles

    • Inventory Definitions

      Inventory Definitions Overview "Inventory Definitions" lets you create definitions for stock verification processes such as cycle counts and spot checks. "Inventory Definitions" is available to corporate or store employees with relevant rights. They ...

    • Inventory Adjustments

      Inventory Adjustments Reports Overview The "Inventory Adjustments" report type will display the list of products for which adjustments were made during a specifically selected date range (time period). Various filters can also be configured, ...

    • Inventory Settings

      Inventory Settings Overview "Inventory Settings" lets you configure settings that are needed to manage any inventory-related process. You can configure settings related to invoicing, receiving, and alerts regarding product stock and inventory. ...

    • Inventory Projection Report

      Inventory Projection Report Overview Inventory Projection is also known as Inventory Forecasting or Demand Planning. It’s all about guesswork or estimation of past inventory data/trends in order to make inventory management effective for the future. ...

    • Inventory Movement Report

      Inventory Movement Report Overview Inventory Movement is all about the location of the product, i.e., where did a product arrive from, and where was the product sent/transferred to. When your company orders products from vendors, they arrive at one ...