Invoice Detail Report Overview

                                                                                Figure 1.1

2. Understanding the "Invoice Detail Report"

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

⁣                                                                         Figure 2.1

3. Generating the "Invoice Detail Report"

To generate the "Invoice Detail Report," follow the steps below. (See Figure 2.1 above.)

1. From the "Invoice Detail Report" page, you will see the "Choose Reports" 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 Report" from the list and click on it.
   

Select and choose the data in the following fields:

1. Start Date: Pick the start date for the transfer time period.
2. End Date: Pick the end date for the transfer time period.
   
3. Store: Select the store name from the drop-down menu, mentioning the store location.
   
4. Date Range Only: If checked, this checkbox filter will ensure that the report displays the result for the selected vendor in the vendor field and no other vendor invoice data within that date range. If unchecked, it will display the invoice data for all the vendors within the selected date range.
   
5. Select Vendor: Pick the vendor name from the drop-down menu.
   
6. Invoice: This field is automatically filled when the vendor is selected in the above field. 

                                                                  Figure 3.1

1. Invoice #: This column displays the invoice number of the product(s) purchased from a vendor.
2. Vendor Part: This column displays the vendor part number, a unique number provided by the vendor for the product listed on the invoice.
3. UPC: It is a Universal Product Code (UPC) associated with the items listed on the invoice.
4. Item Name: This column displays the list of item names that have been purchased from the vendor and added to the inventory.
5. Part Qty: This is actually the number of part units that are mentioned under the vendor part module.
   
6. UPC Qty: This is the number of items that are contained in the one vendor part unit. And the UPC quantity can be calculated as Part Unit X UPC Quantity. For example, if the part unit of a vendor part is 2 and it contains 6 items in each unit, then the UPC quantity will be 2 x 6 = 12.
   
7. Vendor Part Cost: This is the cost of the item for which the store buys the item. 
   
8. UPC Each Cost: This column displays the UPC cost per item of the items that were ordered and are on the invoice.
9. Supplier Discount: This column displays the retailer's discount from the vendor. This amount may reduce the total invoice cost but doesn't affect the item's last cost.
10. Supplier Deposit: This column displays the deposit fee for that vendor's part. This amount may inflate the total invoice cost but doesn't affect the item's last cost.
11. Total Cost: This column will display the result of Retail Each X UPC Qty.
12. Retail Each: This column displays the store selling price of the item.
    
13. Total Retail: This column displays the Total Retail calculated by Retail Each x UPC Quantity.
    
14. Margin: This column will define the margin percentage as Total Retail Price - Total Cost/Total Retail Price x 100.

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

1. Start Date: Choose the start date of the selected date range for which you want to view invoice details.

                                                                  Figure 3.1.1

1. End Date: Choose the end date of the selected date range for which you want to view invoice details. 

                                                                            Figure 3.2

                                                                           Figure 3.1.1.1

3.2. Store

This dropdown allows you to select a specific store location for which you want to view the invoice details in the report. Choosing a store helps filter the data to only include transactions that occurred at that particular location. This selection is mandatory for generating the report, as the system uses it to pull invoice data relevant to the selected store only.


            Figure 3.2.1               

3.3. Vendor

         Figure 3.3.1

3.4. Invoices

This dropdown lets you select a specific invoice associated with the vendor you've chosen and within the selected date range. Selecting an invoice helps you drill down to the detailed line items of that particular transaction.


                  Figure 3.4.1

4. Checkbox Filter

                                                                           Figure 4.1

1. When the filter is checked: 

                                                                         Figure 4.2

5. Scheduling a Report

FTx Cloud POS supports report automation. You can configure a report and schedule it. The system will send the scheduled report to the indicated email IDs at the defined frequencies (daily, weekly, bi-weekly, monthly, quarterly, etc.). 

Please refer to Scheduling a Report to learn how to schedule a report.

6. Printing/Exporting a Report 

You can print or export any report according to your requirements. When you use the Print function, the system creates and opens the report's PDF file in a new tab. You can download the soft copy or print the paper copy according to your requirements. 

Please refer to Printing a Report to learn how to print or export a report. 

7. Manage Favorites 

FTx Cloud POS allows quick access to the reports you need to view frequently through "Favorite Reports." You can save a report as a favorite and manage all your favorite reports from any of the report screens using the "Manage Favorites" button. 

Please refer to Managing the Favorite Reports to learn how to manage or export a report.