The Product List Report produces a list of all products/services loaded in the Product Database. This report can be used to list Product options used or unused in bookings for a range of service dates.

NOTE: For Tourplan users that use Webconnect, it can show products that have been Internet Enabled.

This report includes the following information:

• Loc(ation) (Code).
• Serv(ice) (Code).
• Supplier (Code).
• Supplier Name.
• (Product) Code.
• (Product) Description.
• (Product) Comment.
• Booking Type.
• Booking Name.
• Travel Date.
• (Booking) Day (Number).
• (Booking day) Seq(uence) Number.
• (Booking) Service Date.
• (Booking) Reference (Number).
• Deleted (Flag) If the product has been flagged 'Deleted' in the product database.

Report Parameters can include:

• Order By - Location, Supplier or Product Code.
• List Product - All, Used or Unused Options.
• Products - All, Deleted, or Not Deleted Service Options.
• Show Internet Products Only (Yes or No).
• Currency and Price Code selections.

Generating a Product List Report

1. From the Home menu, select Home > Reports > Product Reports > Product List.
   

   1. Click the Reports menu to expand it:

      

   2. Click the Product Reports menu option to expand it:

      

   3. Click Product List to go to the Product List Parameters screen:

      

2. On the blank Product List Parameters screen, the Service Tab will open. Select the required parameters for the Product List Report.
   

   NOTE: There are 2 tabs available to select parameters from. They are the Service Tab and the Analysis Tab (Supplier and Service).

3. Check the completed screens.
4. Click on the Other Tab. Select how the results are to be ordered and filtered in the report from the dropdown selections or checkboxes available.
5. Select how the report is to display.
1. To view the report, click View.

   

2. To Download the report to a PDF file, click Download PDF.

   

3. To Download the report to a CSV file, click Download CSV.

   

Supplier From/To

Supplier range available from the dropdown selection.

Master Supplier From/To

Master Supplier range available from the dropdown selection.

Code From/To

(Product) Code range.

Location

Location code. Selectable codes are available in the dropdown to generate a report for a specific location.

Service Date From/To

The service line date (or range of).

Service Status

Multi select options for available service statuses.

Service (Type)

Multi select options for available service types.

NOTE: Service Status, and Services showing in the screen captures above are for training purposes. Users company systems will reflect users organisational requirements.

---

Supplier Analysis Codes 1-6

The top 6 Analysis fields are the Supplier/Creditor Analysis codes.

Product Analysis Codes 1-6

The bottom 6 Analysis fields are the Product/Service Analysis codes.

Multi select list of Analysis codes can be used to refine the report if necessary. To expand the fields use the +, and to minimise the analysis list use the -.

NOTE: Analysis codes in the above screen capture are used for training purposes. Users company systems will have analysis fields and codes unique to their organisational requirements.

---

Order By

Dropdown selection to order data in the report by one of the following:

• Location (Default).
• Supplier.
• Product Code.

List Products

Dropdown selection for:

• Used (Default).
• Unused.
• All.

Products

Dropdown selection to display Deleted Flag Status:

• Not Deleted.
• Deleted.
• All (Default).

Show Internet Products Only

Checkbox to list only internet enabled products.

Cost Currency

Multi select options to report All or Specific product Cost Currencies.

Sell Currency

Multi select options to report All or Specific product Sell Currencies.

Price Code

Multi select options to report All or Specific date range Price Codes.

Used Price Code

Multi select options to report All or Specific service line Used Price Codes.