Negative Items Report

Negative Items Report

Negative Items Report Overview

The Negative Items Report will display the data of those products that had any type (void, cancel, return, etc.) of negative transaction(s). The system will display the data of products with negative transaction(s) that took place within the specifically selected date range.

Different types of filters can also be configured, depending on your requirements. The system will display the records of products with negative transaction(s), only according to the selected filter options. The system will display several fields with detailed and automatically calculated information about all the products that had negative transaction(s) during a particular date range, by a particular cashier, or at a particular store location.

Reaching the Negative Items Report

To reach the Negative Items 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 Sales Reports
  5. Step 5: Choose Negative Items 
See Figure A.  You will see many types of sales reports that will be useful to your retail business. By clicking the "Choose Report" drop-down selection, you will see the different types of sales reports.


                                                                                       Figure A

You will see the "Report Data is Empty" message initially. You need to select the date range to check the negative item in the report. See Figure B.


                                                                                      Figure B

1. Generating the Negative Items Report

When you navigate to the Negative Items Report page, you will see the options pre-selected by default. You can generate the report for the selected date range.


                                                                                               Figure C
Fields:
  1. Store #: This column displays the store number.
  2. Name: Here in this column, the name of the store location is mentioned.
  3. Cashier: This column displays the name of the cashier who handled the transaction of negative items.
  4. Type: This column describes the type of negative item transaction, such as Cancel Sale, Returned, Void, or No Sale.
  5. Reg#: This column displays the number of the register that was used to handle the negative item transaction.
  6. Receipt: In this column, the receipt number is mentioned.
  7. Timestamp: The timestamp column displays the date and time of the negative item transaction.
  8. UPC: The UPC of the item(s) that are involved in the negative item transaction to the store.
  9. Name: This column is actually the name of the item that is part of a negative item transaction.
  10. Qty: The quantity of the items that are involved in any kind of negative item transaction is mentioned in this column.
  11. Price Each: This column displays the price of the item(s) involved in the negative item transaction.
  12. Actions: This is a view button that, upon clicking, will take you to the detailed negative item transaction on the E-journal Report page. 

2. Filter Items

  1. Show All: This option displays the Negative Items for all the store locations.
  2. Custom Filter (Manage): This button lets you apply some filters and generate filter-specific reports.

                                                                                                    Figure D

By clicking the "Manage" button, a "Manage Filters" window will pop up. You will see the following details highlighted in Figure E.


                                                                                          Figure E
  1. UPC: Universal Product Code (UPC), which helps in tracking items at the store. This UPC column displays the UPCs of the items that are listed. 
  2. Department: If you select "Department," you will see a report of items that are displayed department-wise. 
  3. Category: If you select "Category," you will see the product's category-wise sales data in the report. You can check the data in the report at the category level. You need to select the level from the "Category" drop-down selection. 
  4. Manufacturer: If you select "Manufacturer," you will see the manufacturer-specific inventory data in the report of the items that are transferred.
  5. Tag: If you select "Tag," you will get the tags-wise sales data for the group that is entered in the product details. When you select the "Tag," the specific tag group will be enabled. 
  6. Vendor: If you select "Vendor," you will get the vendor-wise sales data for the group that is entered in the product details. 
After selecting and moving the records under the "Selected List.See Figure F.


                                                                                                 Figure F

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 G

3. Date Range & Presets

You can filter your sales data in the report by selecting the date range as well as specific times.
By clicking the edit box, you will be taken to a tiny calendar where you can select a specific date range. You can also manually enter the date in mm/dd/yyyy format.

See Figure H and Figure I.

3.1 Start Date: This field lets you choose the start date of the date range.
                                                                                         Figure H

3.2 End Date: This field lets you choose the end date of the date range.

                                                                                              Figure I
3.3 Presets: The Presets label is provided to select the specific duration/interval to generate the report with that.

                                                                                               Figure J

Checkbox Filters:

  1. Only Item Returns:

This filter will display the Negative Returns with only the "Item Returns" Report. See Figure K.


                                                                                       Figure K
  1. Show Summary
This filter will summarize and display the negative item transaction along with its value for the selected locations or for all locations.
                                                                                      Figure L
    • Related Articles

    • Negative Cashier Report

      Negative Cashier Report Reports -> Sales Reports -> "Negative Cashier" Once the customers are done picking out the products that they want to buy in the retail store/shop/mall, they need to reach the counter to check out all the products and make the ...
    • Commission Items List Report

      Commission Items List Report Overview Commissions are a great way of adding a spiff to the specific item(s) and tracking it via reports and on the leaderboards within the point of sale. The "Commission Items List Report" shows all items on commission ...
    • Backorder Items Report

      Backorder Items Report Overview The "Backorder Items Report" lists items that were added to backorders when not received on an invoice in the selected date range (time period). Depending on your specific requirements, various filters for location, ...
    • Items Without Vendor Parts Report

      Items Without Vendor Parts Report The "Items Without Vendor Parts Report" lists all items that do not have a vendor part associated with them. 1. Reaching the "Items Without Vendor Parts Report" To reach the "Items Without Vendor Parts Report," ...
    • Zero Quantity Items Removed Report

      Zero Quantity Items Removed Report The "Zero Quantity Items Removed Report" lists the products removed from orders by users, along with the details of the order they were assigned to. 1. Reaching the "Zero Quantity Items Removed Report" To reach the ...