Inventory Movement Report

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 of your stores. That’s inventory movement from a vendor to your store location. Similarly, when you move certain products from one of your company’s store locations to some other store location of your company; that’s also considered an inventory movement.

This particular report type will display a list of products/stock moved from one place to another. Multiple types of filters and sorting functionalities can be configured according to your requirements. The system will display the records of inventory movement-related data only according to the selected filter options. The system will also display several other related fields on your screen, with detailed and automatically calculated information about the movement of products/stock.

Reaching the Inventory Movement Report 

To reach the Inventory Movement Report, follow the below steps:
  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Reports
  4. Step 4: Choose Inventory Reports
  5. Step 5: Choose Inventory Movement Report 
See (Figure A). You will see many types of inventory reports that will be useful to your retail business. By clicking the "Choose Report" drop-down selection, you will see the different types of inventory reports.


                                                                                     Figure A

By clicking "Inventory Movement Report," you will be redirected to the "Inventory Movement Report," where you can see relevant filtering and sorting options.


                                                                                     Figure B

1. Generating Inventory Movement Report

To generate the "Inventory Movement Report" follow the steps below. (See Figure B above)
  1. From the "Inventory Movement Report" page, you will see the "Choose Report" 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 Movement Report" from the list and click on it.
The following data gets fetched in tabular format when you click on the "Generate Report" button in the top right corner; the "Inventory Movement Report" report will be displayed as highlighted in Figure C.

                                                                                            Figure C

Fields:

  1. Store: This column displays the store location name.
  2. Type: This column displays the type, depending upon the filter that has been checked, such as adjustments, transfers, invoices, cycle counts, spot checks, and sales/breakdown.
  3. Time Stamp: This field displays the date and time of the inventory adjustment process initiation.
  4. UPC: It is a Universal Product Code (UPC) that helps in keeping track of items at the store. Here, in the report, it signifies the items whose UPC is mentioned have undergone any kind of inventory movement. 
  5. Item Name: This column displays the list of item names that have been moved from the vendor to the inventory.
  6. QOH Before: Here in this column, the Quantity on Hand of the inventory items before any inventory movement is displayed.
  7. Adj Quantity: This column shows the adjusted quantities of the item.
  8. Adj Cost: The adjusted cost of the adjusted quantities is displayed in this column.
  9. Reference: The reference is the name of the person who made the inventory movement at that particular store.

2. Filter Options:

Let's understand the custom filter options to generate the "Inventory Movement" report by setting up specific criteria.

2.1 Save Filter and Custom Filters for "Inventory Movement Report"

You can generate the "Inventory Movement" report for all store locations with the "Show All" option or a customized report with "Custom Filter." 

                                                                                 Figure D

You will see the different tabs to filter the items for the item "Inventory Movement" report. You can choose the required filter category.
  1. You can select the saved custom filter from the drop-down selection.
  2. The "Manage Filters" button will open the list of the saved custom filters. See Figure E.

                                   Figure E
  1. Select Filter: You can select any filter from the list to generate the desired "Inventory Movement" report. Select the filter from the list and then click on the "Select Filter" button.

2.1.1: Filter Items by Different Categories

Select the "Manage Filter Category," say, "UPC" you will see many options listed below. See (Figure F) below.
See (Figure F). Now, let's see how to check the "Inventory Movement Report" with different filters. The data in the "Inventory Movement Report" can be filtered into different categories as well. The filter options are:


                                                                 Figure F

Select the "Manage Filter Category," say, "UPC," and you will see many options listed. See (Figure F) above.
  1. Department: If you select "Department," you will see inventory data department-wise in the report. 
  2. Category: If you select "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" drop-down selection. 
  3. Tag: If you select "Tag," you will get the tags-wise inventory data for the group that is entered in the product details. When you select the "Tag," the specific tag group will be enabled. 
  4. By  Vendor: If you select "Vendor," you will get the vendor-wise inventory data for the group that is entered in the product details. 

                                                                                 Figure G
Selected List: You will have one flag to decide whether you want to "Include" or "Exclude" the selected records when Figure G is generated.
  1. Include: If the flag is selected as "Include," it means the "Inventory Movement Report" will be generated by applying the selected records. See Figure F above.
  2. Exclude: If the flag is selected to "Exclude," it means the "Inventory Movement Report" will be generated without including the selected records. See Figure F above.
2. Clear Selection: 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.

2.2.1 Save Filters

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


                                                                                             Figure H
  1. Click on OK to save the filter; once saved, click on "Apply" to apply the filters to the report.
2.2 Date Range
  1. You can filter your sales data in the report between the dates and select a specific time from the Start Date and End Date drop-down calendars.
  1. By clicking the edit box, you will get the drop-down calendar to select the specific date range. You can also enter the date manually in mm/dd/yyyy format.
  1. You can also generate a report with a specific time duration (till morning/evening), and you can select the particular time (hour and minutes) from the date selection. See Figure I and Figure J.

                                                                                 Figure I


                                                                                    Figure J

2.3 Presets

Presets label is provided to select the specific duration/interval to generate the "Inventory Movement Report" according to the selected time period.
         
                                                                                Figure K
Report Type
The Inventory Movement report is displayed in two forms, as mentioned below:


                                                                                                      Figure L
  1. Chronological Report: This type of report is displayed with respect to the time stamp of the inventory movement. See Figure L.

                                                                                                Figure M
  1. Summary Report: A summary report is a report that summarizes the data as per the filters applied.

3. Generating "Inventory Movement Report" With Various Filters

The following checkbox filters produce the dedicated results:
  1. Show Adjustment: This checkbox filter includes the list of adjustments relevant to inventory movement in the selected time period. See Figure L.

                                                                                          Figure N
  1. Show Transfers: This checkbox filter will list all the transfer records location-wise.

                                                                         Figure O
  1. Show Invoices: This checkbox filter includes a list of invoices relevant to inventory movement in the selected time period.

                                                                   Figure P
  1. Show Cycle Counts: Checking this filter includes the list of items that have been moved via cycle counts in the inventory in the selected time period. 

                                                                      Figure Q
  1. Show Spot Checks: Check this filter to prompt the system to list all the spot checks performed in the selected time period that caused items' movement in the inventory.

                                                                               Figure R
  1. Show Sales/Breakdowns: This checkbox filter lists the sales and breakdowns that have made any movement on the items in the inventory.

                                                                                       Figure S
See (Figure S)
  1. Sale: The sale type describes the movement of the items through sales of the listed items within the selected time period. The column with (Sale 112-29) is explained as - "112" is the register number and "29" is the receipt number.
  1. Breakdown: Breakdown Type describes manipulation with the parent and child items in the inventory in case the child items' QOH becomes 0. Here,  Adj Qty is -1 in the highlight breakdown column, which suggests that one parent item has been converted into needed child items to fulfill the needs of child items at the store. In the second case, see Adj Qty is +3,  and three child items have been added to the inventory by the parent item breakdown.
Taking the example of cigarette cartons as a parent and their cigarette packs as child items.
Whenever a child item at any store location is sold out completely and the quantity on hand (QOH) becomes 0, the parent item can be used (considering that one parent contains 10 child items) so that the store has a continuous supply of the child items. 

    • Related Articles

    • 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 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 ...

    • Lottery Safe Movement Report

      Lottery Safe Movement Report Overview The Lottery Safe Movement Report is designed to monitor lottery-safe activities and display information such as Register #, Z #, Lottery Game Names, Product UPC, Safe Values Before and After, the Employee Names ...

    • Cycle Count Coverage Report

      Cycle Count Coverage Report Overview Reports -> Inventory Reports -> "Cycle Count Coverage" The store admin/executive manages the inventory of the store using a POS system handheld device to count the inventory periodically. At the time of counting ...

    • Sales / Inventory / Non-Sellers Report

      Sales / Inventory / Non-Sellers Report Overview The Sales / Inventory / Non-Sellers Report will display the sales data and inventory data of non-selling products. All the hybrid data (sales, inventory, and non-selling) will be displayed together in ...