Invoice Detail Report - Store Employee

Invoice Detail Report - Store Employee

Invoice Detail Report Overview

This report lists all items received in a date range for a specific location and vendor, giving details of each item and the invoice that it was attached to. Multiple different types of filters and sorting functionalities can be configured, depending on user requirements.

The system will display the records for invoice-related detailed information only as per the filter options applied.

Along with it, the system also displays the vendor part quantity, the UPC quantity, the cost of each product on an invoice, the total cost of all the products on an invoice, the retail price of each product on an invoice, the total retail price of all the products on an invoice, the invoice number, the UPC, the product name, the vendor part number, and the profit margin in percent.

1. Reaching the "Invoice Detail  Report"  
To reach the "Invoice Detail Report," follow the steps below: 
  1. Step 1: Log into Control Center
  2. Step 2: Choose Location
  3. Step 3: Choose Reports
  4. Step 4: Choose Inventory Reports
  5. Step 5: Choose Invoice Detail Report 
See Figure 1.1. You will see many types of inventory reports that will be useful to the retail business. By clicking the Choose Report drop-down menu, you will see the different types of inventory reports.

                                                                                Figure 1.1

2. Understanding the "Inventory 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. 
  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.
The following data gets fetched in tabular format when you click on the "Generate Report" button in the top right corner; the "Invoice Detail Report" will be displayed as highlighted in Figure 3.1.

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. Date Range Only Checkbox Filter: 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.
  4. Select Vendor: Pick the vendor's name from the drop-down menu.
  5. Invoice: This field is automatically filled up when the vendor is selected in the above field.  
                                                                       Figure 3.1                       
The following data gets displayed in tabular format to know what items were purchased from the vendor in the selected time period:
  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 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 that 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.

3.1. Date Range

You can filter your sales 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 manually enter the date in mm/dd/yyyy format.
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.1.2
  1. Presets: The Presets drop-down menu is provided to select the specific duration/interval to generate the Invoice Detail Report according to the selected time period.
                                                                Figure 3.1.3

3.2. Vendor

This drop-down allows you to select a specific vendor whose invoice details you want to view in the report. Selecting a vendor helps narrow down the data to only those transactions associated with that vendor, making the report more focused and relevant. 

         Figure 3.2.1

This selection is mandatory to generate the report, as the system uses it to filter and display invoice data specific to that vendor.

3.3. Invoices

This drop-down 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.3.1

4. Checkbox Filter

Date Range Only: Displays all invoices within the selected date range, ignoring Vendor and Invoice filters.
  1. When the "Date Only" Filter is Checked: Vendor and Invoice selections are ignored. 
Example: If you set the date range from 01/16/2025 to 09/16/2025, the system will pull all invoices from all vendors issued in that time frame.                                                               

                                                                                         Figure 4.1
  1. When the Date Filter Is Not Checked: You must pick a Vendor and Invoice.
Example: Select Vendor and Invoice; the report will only show that specific invoice for that vendor within the given dates.
                                                                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, biweekly, 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. 

    • Related Articles

    • Invoice Summary Report - Store Employee

      Invoice Summary Report Overview The "Invoice Summary Report" gives a basic invoice summary for all invoices in the selected date range. At first glance, this report displays the total invoice amount, surcharge amount, miscellaneous fee, prepaid sales ...

    • Worksheets - Store Employee

      Worksheets Overview A Return Worksheet is a feature used to manage and process product returns, ensuring that returns are tracked systematically, authorized correctly, and accurately recorded in both inventory and financial records. In FTx Cloud POS, ...

    • Verified Invoices - Store Employee

      Verified Invoices Overview "Verified Invoices" shows the list of verified invoices once the store completes the invoice verification process using the handheld device. Generally, invoices are processed and completed via EDI. Therefore, retailers find ...

    • Invoice Detail Report

      Invoice Detail Report Overview: This report type will display detailed information about an invoice for the product(s) purchased from a vendor only in the specifically entered date range. Multiple different types of filters and sorting ...

    • Media Detail Sales Report - Store Employee

      Media Detail Sales Report Overview In FTx Cloud POS, the "Media Detail Sales Report" provides a breakdown of sales by payment media or tender types. This includes detailed information on how each transaction was paid. This article includes ...