Transfers Report

Transfers Report

Transfers Report Overview

The "Transfers Report" will display the products' transfer data for stores from where the transfer was done and the stores to which the transfer was done. Multiple different types of sorting functionalities and filters can be configured as per your requirements.

FTx Cloud POS will display the records of product transfers with TO and FROM store locations' names only according to the filters configured by you. The system will display several fields with detailed and automatically calculated information, separately for each transfer type.

Reaching the "Transfers Report"

To reach the "Transfers 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 Transfers

Understanding the "Transfers Report"


                                                                                            Figure 1

See Figure 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 2

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

                                                                                            Figure 3

1. Generating the "Transfers Report"

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


                                                                                                Figure 4

The following data gets displayed in tabular format to know what items are transferred to and from which store in the selected time period.
1. Type: This field defines the transfer that is initiated either To or From the store and is represented in the form of numbers.
2. UPC: It stands for Universal Product Code (UPC), which helps in tracking items at the store.
3. Item Name: This column displays the list of items' names that are either transferred to or from the selected store.
4. Quantity: This column lists the number of units per product that are Transferred From or Transferred To the store.
5. Cost Each: This column displays the cost per unit of the items.
6. Total Cost: Total cost is calculated as cost per unit x number of units transferred.
7. Created By: This column will display the name of the employee who created the transfer.
8. Applied To: This column displays the name of the employee who accepts the incoming transfer request.
9. Applied By: Here, the name of the employee who has initiated the transfer process of the items appears.
10. Time Stamp: This field displays the date and time of the transfer process initiation.

2. "Transfers Report" Filter Options

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

2.1 Saved Filter and Custom Filters for "Transfer" Items

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


                                                                               Figure 5

You will see the different tabs to filter the items for the "Transfers 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 saved custom filters. See Figure 6.                                                                                                                                                                                                                            Figure 6
  1. See Figure 7.
                                                                                                                                                                                                            Figure 7
  1. Select Filter: You can select any filter from the list to generate the desired Transfers Report. Select the filter from the list, and then click on the "Select Filter" button.
  1. Select the "Manage Filter Category," say, "Department," and you will see many options listed below. See Figure 7 above.

2.2.1: Filter Items by Different Categories

See Figure 7. Now, let's see how to check the Transfers Report using different filters. The data in the Transfers Report can be filtered into different categories as well. The filter options are:
  1. Manufacturer: If you select "Manufacturer," you will see the manufacturer-specific inventory data in the report of the items that are transferred.
  1. Department: If you select "Department," you will see a report of items that are transferred department-wise. 
  1. 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. 
  1. Tag: If you select "Tag," you can select which tags you want to narrow your search by. 
  1. Vendor: If you select "Vendor," you will get the vendor-wise inventory data for the group that is entered in the product's details. 
  1. Department Tag: Selecting "Department Tag" will fetch the department-tag-wise inventory data that is entered in the product details.
                                                                                                                                               Figure 8

1. Selected List: You will have one flag to decide whether you want to "include" or "exclude" the selected records when Figure 8 is generated.
  1. Include: If the flag is selected as "Include," it means the Transfers Report will be generated by applying the selected records. See Figure 8 above.
  2. Exclude: If the flag is selected to "Exclude," it means the Transfers Report will be generated without including the selected records. See Figure 8 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.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 9
  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 2 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 (until morning/evening), and you can select the particular time (hour and minutes) from the date selection. See Figure 10.

Start Date: This option lets you choose the starting date of the selected date range.


                                                                                         Figure 10

End Date: This option lets you choose the ending date of the selected date range.


                                                                                          Figure 11

Presets: It is provided to select the specific duration/interval to generate the Transfers Report according to the selected time period.

                                                                                                Figure 12

3. Generating the "Transfers Report" After Applying Filters

  1. Once you apply the desired filter, it will take you back to the Transfers Report main page.
  2. Then click on "Generate Report" to generate the filtered report.  
Here you can see the selected location, "Oneonta" and Grouped by Location, clubbed with other checkbox filters.

                                                                                                       Figure 13

The stores are represented in the form of store numbers, i.e., 1, 2, 3, and so on, and their numbers are mentioned next to the location name.

See Figure 13. Location-2 represents Middletown and Location-4 represents Amsterdam.

The two types of transfers:
  1. Transfer To: This type of transfer suggests that the process is initiated from any store TO the selected store. In this case, any store process will be initiated to add item quantities to the store, and hence, in the Quantity column, the item value is represented in a positive manner. See Figure 13.
  1. Transfer From: This type of transfer suggests that the process is initiated FROM the selected store to any other store. In this case, the process is initiated to add the item quantities from the store, and hence, in the Quantity column, the item value is represented in a negative manner. See Figure 13.

3.1 Quantities, Total Cost, and Total

  1. Quantities: If the value of the item quantity is positive in the Quantity column, then the same amount of items are added to the store whose location is mentioned in the location label. If the quantity value is negative (-), then the same amount of items are transferred from that store to the selected location.
  1. Total Cost: Total cost of the items that are being transferred to or from is calculated as- transferred quantity value X cost per item.
  1. Total: The total is calculated as follows: 
Total Quantity = The total of transferred item quantity of Location 1 + The total of transferred item quantity of Location 2.

4. Checkbox Filters

The checkbox filters highlighted in Figure 14 below will impact the Transfers Report as described below:
 4.1 Show Xfer Store Sums: This filter groups and totals individual store totals together. It makes it easier to see the summed totals for each location.

                                                                             Figure 14
4.2. Show Department Sums: This filter will display the Transfers Report department-wise.                                                                                                                                                  Figure 15
4.3. Only Open Transfers: This filter will organize the report with transfer records that have been created from one store and are in the queue to be accepted by another store. It implies that it will only show the records of the transfers that have just been initiated.                                                                     
                                                                                                                                                    Figure 16

4.4. Omit Activity From Store: This filter option will omit the transfer from the selected store. From the "Omit from Store" drop-down list, select the name of the city that you wish to omit.

                                                                                     Figure 17

When this filter is applied, as depicted in Figure 17, store no. 24 Middletown is omitted, and in the report, no record for store 24 is shown.
You can choose multiple checkbox filters, and the results will be displayed in combination.

    • Related Articles

    • Suggested Transfers

      Suggested Transfers Overview Stock transfers are essential to the retail business because they efficiently optimize perpetual inventory. FTx Cloud POS offers you an intelligent feature, "Suggested Transfers." This feature allows retailers to analyze ...

    • Transfers

      Transfers Overview A stock transfer is the warehouse logistic process of transferring products from one store to another. The goal of the stock transfer include are: Optimizing the purchase process by leveraging extra stocks at some stores Optimizing ...

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

    • Report Favorites

      Report Favorites Overview "Report Favorites" will display the list of all report types (List Reports, Sales Reports, Smart Till Reports, Inventory Reports, Lottery Reports, etc.) that have been saved by the user for easier access or review. Each ...

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