Detrack
  • Features
  • Industries
  • Customer Stories
  • Integrations
  • FAQs
  • Pricing
  • Log in
  • Try it free
Try it free
Select Page
Tutorials // Jobs // How To Use Search Jobs To Generate Reports

How To Use Search Jobs To Generate Reports

By using the various search criteria, you can get information such as the number of jobs per driver/vehicle, jobs under a particular job status, jobs for a particular customer (deliveries, collections or both) or jobs created over a period amount of time.

The search conditions are:

  1. Detrack Job Type (Delivery or Collection)
  2. D.O. No.
  3. Date (Date range)
  4. Start Date (Date range)
  5. Job Time
  6. Time Window
  7. Tracking No.
  8. Address
  9. Deliver To / Collection From
  10. Open to Marketplace
  11. Order No.
  12. Job Type
  13. Group (drop-down list of groups)
  14. Run No.
  15. Account No.
  16. Invoice No.
  17. Assign To (drop-down list of vehicles/driver)
  18. Zone
  19. Job Status (drop-down list job statuses)
  20. Reason (list of reasons for failed deliveries and collections)
  21. Item Reject Reason (list of reasons for item rejection under delivery and collection)
  22. Serial No.
  23. SKU
  24. Item Description
  25. Item Serial No.
  26. Item P.O. No.
  27. Item Batch No.
  28. Source
  29. Department

The search criteria shown and the names of these search criteria displayed will be based on your customized field settings located in Settings > Job > Fields.

For example, you can filter the results of Delivery or Collection by using the Detrack Job Type search critieria.

After you have entered the search criteria, click Search to display the results on the dashboard. To create a report, enter the search criteria, select the Export Options you wish to enable, press Export and select either Excel or CSV.

Default Dashboard Field Name API Field Name Data Type Search Type
Account Number account_number String Whole
Address address String Partial
Customer customer String Prefix
Date date Date Range
Department department String Partial
Invoice Number invoice_number String Whole
Job Type job_type String Partial
Deliver To Collect From deliver_to_collect_from String Partial
Order Number order_number String Whole
Run Number run_number String Whole
Reason reason String Whole
Start Date start_date Date Range
Serial Number serial_number String Whole
Source source String Partial
Job Time job_time String Prefix
Time Window time_window String Whole
Tracking Number tracking_no String Whole
Zone zone String Whole
Default Dashboard Field Name API Field Name Data Type Search Type
SKU sku String Whole
Item P.O. No. purchase_order_number String Whole
Item Batch No. batch_number String Whole
Item Description description String Partial
Item Serial No. serial_numbers String Whole

Example data: Pineapples and oranges

Search Type Description Search Example
Partial Search matches any of the word/s in the Example data. oranges
Prefix Search of the prefix (starting characters) in the Example data. pine
Range Range of values (Applicable only to date related fields). –
Whole Search must fully match the Example data. Pineapples and oranges
Back to all tutorials
  • Start your free trial

WHO USES DETRACK

  • INDUSTRIES
  • Logistics Service Providers
  • Retailers
  • Medical and Pharmaceutical Companies
  • Furniture & Home Appliance Distributors
  • Construction Material Distributors
  • F&B Distributors
  • 3PL Providers
  • Businesses with Delivery Vehicles

CASE STUDIES

  • CUSTOMER STORIES
  • PAN Logistics’ customers get real-time proof of deliveries with Detrack
  • Teak & Mahogany solved its logistics problems with Detrack
  • Mansco’s deliveries went paperless with Detrack
  • SGS Logistics improved the customer experience using Detrack

DISCOVER DETRACK

  • DISCOVER DETRACK
  • High speed route optimization
  • Tap to track
  • Contactless Delivery
  • Who We Are
  • Countries & languages
  • Reviews
  • Security
  • App data usage

GET IN TOUCH

  • GET IN TOUCH
  • Schedule a call
  • Support overview
  • Tutorials
  • General enquiry
  • Ask us anything via chat
  • The Detrack Blog
  • FAQs
App store
Google play
  • Follow
  • Follow
  • Follow
  • Follow
  • Follow
  • Follow
  • © Detrack Systems Pte Ltd
  • Anti-spam
  • Privacy
  • Terms Of Use
  • Payment Terms
  • Data Retention
  • SLA
  • SaaS Agreement
Detrack is powerful delivery management software that lets you track your vehicles live on a map and capture electronic proof of delivery (e-POD) using our iOS or Android apps and an easy to use web dashboard for admins. Our apps have been translated into 26 languages and are being used daily around the world to complete millions of deliveries. Whether you’re looking for Delivery Management Software, a TMS System, Courier Software, Dispatch Software, or just an excellent Proof Of Delivery App, Detrack is the one to try. Sign up for a free Detrack account to get started. Or speak with our sales team today and we will get you up and tracking in no time.

The Capterra logo is a service mark of Gartner, Inc. and/or its affiliates and is used herein with permission. All rights reserved.