Inventory Adjustments Report

Inventory Adjustments Report

Inventory Adjustments Report Overview

The "Inventory Adjustments Report" offers a comprehensive overview of all inventory changes made within a specified date range, enabling users to monitor and verify adjustments for accuracy and transparency. It captures essential information such as product name, UPC, adjustment type, quantity, date, time, and the store where the adjustment was applied.

This article explains the purpose of the "Inventory Adjustments Report," the type of data it includes, and how to use filters to tailor the results to your needs.

You can apply filters like Adjustment and Transfer Type to narrow down the results based on specific criteria. This report is a valuable tool for identifying inventory changes and ensuring adherence to inventory control procedures.

1. Reaching the Inventory Adjustments Report

To reach the "Inventory Adjustments Report," follow the steps below (see Figure 1.0):
  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 Adjustments Report
See Figure 1.1. 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 1.0

2. Understanding the "Inventory Adjustments Report"

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

Figure 2.0

3. Generating the "Inventory Adjustments Report"

To generate the "Inventory Adjustments Report," follow the steps below. (See Figure 2.0 above).
  1. From the "Inventory Adjustments 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 Adjustments 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 Adjustments Report" will be displayed as highlighted in Figure 3.0.

Enter the data in the fields to get desired results.
  1. Filter Items: This field lets you pick either of the two options, "Show All" or "Custom Filter," which are subject to displaying all the inventory adjustments for the selected location. Custom filters will segregate the report according to different filters.
  2. Start Date: Pick the start date for the transfer time period.
  3. End Date: Pick the end date for the transfer time period.
  4. Checkbox Filters: Tick the desired filter to get a more detailed report.

                                                                                    Figure 3.0

The following data gets displayed in tabular format to know what items are adjusted in the selected time period.
  1. UPC: This is the Universal Product Code, a unique identifier for each product.
  2. Item Name: The name of the item/product involved in the inventory movement.
  3. Users/Employees: The person (employee or system user) who performed the action, such as an adjustment or transfer.
  4. Purchase Qty and Purchase Cost: These show how many units of the item were purchased and what the total cost was.
  5. Adjustment Quantity and Adjustment Cost: These reflect manual changes made to the inventory, such as adding or removing stock. The cost reflects the value of the adjusted quantity.
  6. Transfer Quantity: This refers to the number of units of a product that have been transferred from one location (store/warehouse) to another.
  7. Transfer From Cost: This is the cost value of the item at the originating location (the store or warehouse from where the item was sent).
  8. Transfer To Cost: This is the cost value of the item at the destination location (the store or warehouse receiving the item).
  9. Cycle Count Quantity and Cost: This shows results from scheduled inventory counts. Any discrepancies found are recorded here with their cost impact.
  10. Spot Check Quantity and Cost: These are from unplanned or random inventory checks. Again, any variations are captured in both quantity and cost terms.
  11. Import Quantity and Cost: If inventory was imported into the system via a manual or bulk upload, this shows how many units were added and their value.
  12. Waste Quantity and Cost: This indicates the amount of inventory discarded due to spoilage, expiration, damage, or other reasons, along with the cost lost.
  13. Adjustment Type: This categorizes the nature of the adjustment — for example, shrinkage, damage, theft, etc.
  14. Reason: A more detailed explanation for the adjustment, such as "vendor return," “expired,” “broken in transit,” or “stock mismatch.”

4. Filter Options

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


Figure 4.0

4.1 Manage Filters 

  1. You can generate the Inventory Adjustments Report for all store locations with the "Show All" option or a customized report with "Custom Filter." 
  2. You will see the different tabs to filter the items for the item Inventory Adjustments Report. You can choose the required filter category.
  3. 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. See Figure 4.1.0.

                                    Figure 4.1.0                                                                                                                                                                                                                                                                                                                                                                                                                             
  1. Select Filter: You can select any filter from the list to generate the desired Inventory Adjustments Report. Select the filter from the list, and then click on the "Select Filter" button.
  1. Now, let's see how to check the Inventory Adjustments Report using different filters. The data in the Inventory Adjustments Report can be filtered into different categories as well. The filter options are: 
                                                                                                                                                                      Figure 4.1.1
Manage Filters Screen Information: 
  1. Manage Filters Drop-Down: Select the saved custom filters from the Manage Filters drop-down (if any) and click "Apply" to apply the saved custom filter. 
  2. Parameter Tabs: You will see seven tabs: UPC, Department, Category, Manufacturer, Tag, Vendor, and Department Tag. Select the required tab, i.e., UPC, to create or apply a custom filter specific to the selected UPCs.
  3. Search: Use this search box for a specific result.
  4. Match All Filters Drop-down: Use the Match All Filters filter to decide whether or not the Manage Filters screen data matches all applied filters. 
  5. Results: Here, you see the relevant list of data for the selected tab. For example, if you have chosen the UPC tab, it will show the list of all UPCs. You can search for a specific UPC in the Search bar.
  6. Checkboxes: Select the required products by checking the appropriate checkboxes.
  7. Arrow: Click the green arrow button to move the selected records to the selected list area. 

                                                                                                                                Figure 4.1.2
  1. 1. Selected List: You will have one flag to decide whether you want to "Include" or "Exclude" the selected records when Figure 4.1.2 is generated.

    1. Include: If the flag is selected as "Include," it means the Inventory Adjustments Report will be generated by applying the selected records.
    2. Exclude: If the flag is selected to "Exclude," it means the Inventory Adjustments Report will be generated without including the selected records. 

    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.

    3. Apply or save the custom filter:
    1. Apply: Click the "Apply" button for the selected parameters. Click "Generate Report." The system will generate reports based on your selection. 
    1. Save Filters: Click the "Save Filters" button to save the custom filter for future use. 4.2 Save and Manage Custom Filters explains the details.
    2. Close: Use this button to exit the Manage Filters screen.                                                                                                                                                                                                                                                                      

4.2 Save Custom Filter

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 4.2.0
  1. Click on "OK" to save the filter; once saved, click on "Apply" to apply the filters to the report.

4.3. Date Range

You can filter your data in the report between the dates and select a specific time from the Start Date and End Date drop-down calendars.
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.
You can also generate a report with a specific time duration (till morning/evening), and you can select the particular time (hour & minutes) from the date selection. See Figure 4.3.0.
  1. Start Date: This option lets you set the start date for the selected date range.

Figure 4.3.0
  1. End Date: This option lets you set the end date for the selected date range.
                                                                                 Figure 4.3.1
  1. Presets: The presets label is provided to select the specific duration/interval to generate the Inventory Adjustments Report according to the selected time period.

Figure 4.3.2

4.4. Checkbox Filters

You can also use checkbox filters to quickly select multiple filters at once, making it easier to refine and customize the report results.

1. Show Summary: This check filter will list the summary of items that have been adjusted in the selected time duration.

                                                            Figure 4.4.0
2. Show Item with 0 Qty: This filter will display the list of items whose quantity has become "0" or less than "0" at the selected store.

                                                                                                                                                                          Figure 4.4.1
                                          
3. Include Invoices: This checkbox filter includes the list of invoices relevant to inventory adjustments in the selected time period. 
                                                                Figure 4.4.2                                                                                
4. Include Adjustment: This checkbox filter includes the list of items adjusted in the report.

Info
When you check the Adjustment Filter checkbox, the Adjustment Type drop-down becomes visible. Select an adjustment type from the list to refine the results. 
                                                                          Figure 4.4.3

5. Include Transfers: This checkbox filter will list transfers from the "selected stores."

When you check the Transfer Filter checkbox, the Transfer Location Filter and Transfer Type drop-downs become visible. Select a transfer type from the drop-down list or apply location filters to refine the results.


Figure 4.4.4

6. Include Cycle Counts: Checking this filter will include the list of cycle counts that have been performed in the selected time period.
                                                                           Figure 4.4.5

7. Include Spot Checks: Check this filter to prompt the system to list all the spot checks performed in the selected time period.

Figure 4.4.6
8. Include Waste: Check this checkbox to apply a filter to the report to display the list of items that have been wasted (expired) during the selected time period.


                                                                                                                                                     Figure 4.4.7

9. Include Manual Import: Check the Include Manual Import checkbox to apply a filter to the report, displaying a list of items that were manually imported using the Import Utility feature during the selected time period.

                                                                                                                                       Figure 4.4.8

    • Related Articles

    • Adjustments

      Adjustments Overview Adjustments are additions or deductions made in stock levels in a point-of-sale system to accommodate known breakage, theft, waste, item expiration, internal use, shipment errors, and various write-offs. When an adjustment is ...

    • Adjustments

      Adjustments Overview Adjustments are kinds of inventory corrections used to adjust a product's in-stock quantity. You can use "Adjustments" when there is a known theft, damage, or mistake in counts. You can create adjustments for both positive and ...

    • Manual Adjustments Report

      Overview In certain inventory-handling scenarios — such as damaged items, inventory loss, or system discrepancies — manual adjustments to the on-hand quantity may be necessary. The Manual Adjustments Report provides a summarized view of all manual ...

    • Inventory Movement Report

      Inventory Movement Report Overview Inventory Movement refers to tracking the physical transfer of products — whether it's receiving stock from a vendor or transferring items between store locations. For example, when your company receives products ...

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