Inventory Balance Report

December 27, 2021 07:21

Inventory Balance Report provides inventory balance by store/location as well as to view item properties such as price levels, location types, categories, etc.

Navigate to Reports → Inventory Reports → Inventory Balance Reports

Filter your Reports

You can filter reports to narrow down the information that is shown by default. For example, you can add a filter to show inventory for a specific Store/Warehouse, etc.

You can also add or remove columns in your reports. Any filters or edits that you apply are temporary.

Open a report.
Click Filters.
Select a Column
From the drop-down list, select the operator Contains, Not Contains, Equals, Not Equals, Starts With & Ends With.
In the filter box, type any value that you want to filter by.

If you want to filter Size by a value that is "Large", and/or "Medium" then select the operator Contains Large AND/OR Contains Medium

You can specify more than one value. If a filter uses the same name operator, then data is included in the report if any of the values match.

Filter IBR By Location/Pricebook

To filter Reports by Venue, Store, or Warehouse user selects the appropriate filters.

If a location has a price book attached, this report will filter the data based on the selected location and show the updated item details (updated Selling price, etc.) specified in the price book.

Screenshot

If you select the location as 'ALL', none of the location-specific price book prices are displayed, and only the default merchant prices are displayed.

Add or Remove Columns in Your Reports

You can add and remove columns in most reports to show more or less information than is shown by default.

Note: You can add a column to a report and print or export it, but you can’t save the edited report and reopen it later.

Open a report.
Click Columns. A drop-down list shows the columns that you can add or remove. The columns that are shown by default have a checkmark.
Check the columns you want to add. Uncheck the columns you want to remove.

Details

This report provides details on the items that are in inventory.

Note - this reports only active items, any items which have been made inactive will not appear on this report even if they have quantity.

To view the report from a beginning UPC number to an ending UPC number in numeric order user enters the beginning UPC into From and the ending UPC into To

The user then can generate the report and download the excel file. Once a report is generated, the user can see the store, the warehouse, the department, the SKU, and the description, category, sub-category, supplier, quantity on hand (QOH), cost, cost value, retail price, and sell-through percent (the percentage of items sold off units available for sale) of each item listed.

The report includes various fields that provide detailed information about each item in stock. Here is a short description of the fields in an Inventory Balance report:

UPC (Universal Product Code): The barcode assigned to each product.
Item ID: The unique ID for the item.
Product ID: An identifier specific to the product, often used for internal tracking or referencing purposes.
Item Name: The name or description of the item.
Image: An image or photo of the item, allowing for visual reference.
Department: The department to which the item belongs, usually used for organizing inventory.
Category: A more specific classification within the department, further categorizing the item.
Subcategory: A more detailed classification within the category, providing additional granularity.
Color: The color or variant of the item, useful for distinguishing similar products.
Size: The size or dimensions of the item, particularly relevant for apparel or other size-dependent products.
Current QOH (Quantity-On-Hand): The current quantity of the item in stock at the specified location. Clicking on the link will take the user to a detailed view of the QOH levels based on different locations.
Style: The specific style or design of the item, often applicable to fashion or similar industries.
Brand: The brand associated with the item.
Season: The specific season or collection to which the item belongs, relevant in industries with seasonal variations.
Team: To categorize products based on different teams.
Venue: The venue where the item is stocked or available for sale.
Supplier: The supplier or vendor from which the item was sourced or purchased.
Location: The name of the location where the item is stored or displayed.
Location Type: The type of location such as store, warehouse, or venue.
Selling Price: The price at which the item is sold to customers.
Cost Price: The cost or purchase price of the item for the retailer.
Extd. Retail (Extended Retail): The total retail value of the quantity on hand, calculated by multiplying the selling price by the current QOH.
Extd. Cost (Extended Cost): The total cost value of the quantity on hand, calculated by multiplying the cost price by the current QOH.
Date Last Sold: The date when the item was last sold to a customer.
Date Last Received: The date when the item was last received or restocked in the inventory.

Note: Please be aware that the Inventory Balance report will encompass items from inactive stores if their Quantity on Hand (QOH) is greater than 0. However, items linked to inactive stores with a QOH equal to or less than zero will not be listed in the Inventory Balance report.

Updating Item from IBR

Clicking on the UPC will take you to the product detail page where you can update the item selected.

Item Analytics on IBR

The Analytics icon adjacent to each line item within the IBR report serves the purpose of providing users with direct access to deeper analytical insights associated with individual items. Screenshot 2023-11-30 at 2.08.44 PM.png

This functionality facilitates a more detailed exploration of specific data points, enabling users to delve into comprehensive analytics for enhanced understanding and decision-making.

Screenshot 2023-11-30 at 2.11.12 PM.png

Creating Store Orders from IBR

Navigate to Reports → Inventory Reports → Inventory Balance Reports

Select the items from the report grid by checking the box and navigating to the 3 dots near the Advanced Filters and click the 'Create Store Order' option.

Screenshot

This will directly take you to the Create Store Order page. Update the store order details and specify the order quantity and click the Create button to create the store order.

Click here for more info on Store Orders

Creating Inventory Transfer from IBR

Navigate to Reports → Inventory Reports → Inventory Balance Reports

Select the items from the report grid by checking the box and navigating to the 3 dots near the Advanced Filters and click the 'Create Inventory Transfer' option.

This will directly take you to the Initiate Inventory Transfer page. Update the transfer details and specify the order quantity and click the Initiate button to initiate the inventory transfer.

Click here for more info on Inventory Transfer

The Inventory Balance report provides a comprehensive snapshot of the inventory status, enabling businesses to make informed decisions regarding stock levels, pricing, and restocking strategies.

Export/ Download Reports

Users have the option to download reports on Console,

Navigate to Reports and select the report
Select the Date Range that you wish to get the report for.
Select filters that are necessary for your report.

Note: Default Settings will create a Report with all the necessary information, but if you want a more detailed report, add or remove filters.
Navigate to the Download button on the top right corner of the screen, By clicking on the button, the report will be automatically downloaded as an Excel file. The downloaded file will include detailed information on applied filters, encompassing criteria such as start and end dates, time, and store location.

Note: If you have custom attributes enabled on your account, it will show a popup window to enter the email to which the report will be exported. No default settings/filters on the report will get exported in this case.

Note: The "Supplier" field name has been changed to "Vendor." and the "Date Last Received" column has been modified to include only receiving transactions specific to the particular store.

Articles in this section