📦
P4W User Manual
  • P4W Change Log
  • QUICK START GUIDE
    • Overview
    • FAQ
    • Supply Chain Glossary
    • New User Login
    • Create a Warehouse
      • Edit Warehouse
      • Add Zones
      • Add Bins
    • Create a User
    • Create a Product
    • Create a Vendor
    • Create a Customer
    • Setup Printers
  • Tenant Full Guide
    • Tenant Setup
      • General
      • Login Screen
  • System
    • Translation
    • Logs
    • Database Backups
    • Query Builder
    • History Search
    • System Configurations
      • System
      • Integration
      • Communication
        • Email
        • Webhook
  • System Audit Guide
    • Audit
  • User Full Guide
    • Create New User
    • Edit User
    • User Modules
    • User List
    • User Sessions
    • Active Handhelds
  • PRODUCTS FULL GUIDE
    • Product Setup
      • Product Settings
        • Product Information
        • Product Monitoring Features
        • System Configurations
      • Product List
    • Product Bundles Setup
  • WAREHOUSE FULL SETUP
    • Warehouses
    • Zones
    • Bins
    • Dock doors
  • Printers
    • Printer Setup
    • Printer Agent
    • Templates
    • Print Queue
  • 3PL
    • 3PL with P4W
      • Multi Client Configuration
  • Reporting
    • P4W Reporting
    • Widgets
    • Dashboards
    • Scheduled Reports
      • Query Tab
      • Recipient
  • Receiving
    • Vendors
    • Calendar
      • Calendar Configurations
    • Pending Purchase Orders
      • Page Overview
      • New Purchase Order
      • Import Purchase Orders
    • Receiving Process
      • Handheld Receiving Operations
    • Closed Purchase Orders
    • Handheld Receiving Overview
      • PO List
      • PO Receiving
      • PO Photo
      • Product Barcode
      • Un-Receive PO
      • Non-PO Receiving
    • System Configurations
      • Data Entry
      • Operations
      • Handheld
      • Automation
      • Document Printing
      • Email Notification
  • Fulfillment
    • Setup
      • Customers
      • Cartonization profiles
      • Carton sizes
      • Carriers
      • Shipping Rules
    • Pick Tickets
      • Page Overview
      • New Pick Ticket
        • Header
        • Ship From
        • Ship To
        • Bill To
        • Shipping Details
        • Progress
        • Pick Info Details
        • Lines
      • Import Pick Tickets
      • Allocation
      • Picking | Web Interface
        • Wave
        • Cartonize
        • Rating State
      • Picking | Handheld Interface
        • Pick Ticket List
        • Tag List
        • Pick & Pack
        • Wave Picking
        • Full Pack Picking
        • Carton Picking
    • Cartonization
    • Totes
    • Shipping Station
      • Shipping Details Overview
      • Generate a Shipping Label
    • E-comm Dashboard
      • Forming a Staging Bin
      • Individual Order Processing
      • Bulk Shipping
    • Truck Loads
      • Prepare Pallets
      • Create Truck Load
        • Truck Load Details
        • Truck Load | Manual
        • Truck Load | Bulk
        • Staged Truck Load
      • Shipping Truck Load
        • Tote to Dock
        • Ship
        • Photo
    • Master Truck Loads
      • Prepare Pallets
      • Create Master Truck Load
        • Master Truck Load Details
        • Assemble a Master Truck Load
        • Staged Master Truck Load
      • Shipping Master Truck Load
        • Tote to Dock
        • Ship
        • Photo
    • Shipping Pick Tickets
      • Tote to Dock
      • Ship
      • Photo
      • Deliver
    • History
      • Pick Tickets
      • Totes
      • Truck Loads
      • Master Truck Loads
    • Handheld Staging Operations
      • Tote Move
      • Repackaging
      • Tote Merge
      • LPN Merge
      • Tote Counting
      • Unpicking
      • Print Contents
    • System Configurations
      • Shipping
        • Truck Load
          • Operations
          • Email Notification
        • Master Truck Load
          • Operations
          • Email Notifications
        • Packslip
        • Small Parcel
        • Private Fleet
        • Email Notification
      • Closing
        • Back Orders
        • Email Notification
      • Data Entry
      • Automation
      • Releasing
      • Allocation
      • Cartonization
      • Waving
      • Picking
      • Document Printing
      • Handheld
  • Returns
    • RMA and Customer Returns
      • Pending Returns
        • Customer Return Details Page
        • Adding Products
        • Receiving RMA
          • RMA List
          • RMA Receiving
          • Photo Return
          • Non-RMA receiving
          • Un-receive RMA
      • Closed Returns
    • System Configurations
      • Data Entry
      • Operations
      • Handheld
      • Automation
      • Document Printing
      • Email Notification
  • Inventory Adjustments
    • Adjustments
      • Customer Return
      • Vendor Return
      • Adjust In
      • Adjust in by Bin
      • Adjust Out
      • Adjust out by Bin
      • Adjust out full Bin
    • System Configurations/Reason Codes
  • Production
    • Workflow
      • Workflow Mapping
    • Production Orders
      • Production Order Details Page Overview
      • Adding Lines
      • Production Order Allocation
      • Production Order Cases
        • Assemble BOM
        • Disassemble BOM
        • Produce Multiple SKUs
        • Product Consumption
      • Handheld | Production
        • Production Folder Overview
          • Production List
          • Picking
          • Processing
          • Produce
        • Production Process
          • Picking
          • Processing
          • Produce
          • Closing Production Order
    • Closed Production Orders
    • System Configurations
      • Operations
      • Picking
      • Allocation
      • Handheld
      • Automation
  • Collaboration
    • User Tasks
    • Unapproved CCs
      • Cycle Counting Configuration
    • Custom Actions
    • Handheld Operations
      • My Tasks
      • Custom Actions
  • Analytics
    • Inventory
      • Inventory
      • Bulk Inventory
        • License Plate Configuration
      • Empty Bins
      • Inventory Availability
      • Staging LPNs
      • Warehouse Min/Max
      • Bin Min/Max
      • Expiry
      • Substitutes
    • Cycle Count
      • Cycle count bins
      • Cycle count LPNs
      • Cycle count audit
    • Custom Dashboards
  • Floor Operations
    • Inventory
      • Product Move
      • Full Bin Move
      • Bin Contents
      • Packsize Convert
      • Packsize Breakdown
      • Substitute Conversion
    • Bulk
      • LPN Letdown by Bin
      • LPN Letdown by SKU
      • Product Letdown by Bin
      • Product Letdown by SKU
      • LPN Move
    • Cycle Count
      • Cycle Count by Bin
      • Cycle Count by Product
      • Cycle Count Marked Bins
    • Products
      • Product Dims
      • Product Locations
      • Product Photo
    • Dims/Weight
      • Tote Dimensions
      • LPN Dimensions
  • Handheld Configurations
    • Handheld Settings
  • P4W Communications
    • Web Browser Chat
    • Handheld Chat
Powered by GitBook
On this page

Was this helpful?

  1. Reporting
  2. Scheduled Reports

Query Tab

PreviousScheduled ReportsNextRecipient

Last updated 2 years ago

Was this helpful?

In the query tab, users can enter required query if the following field.

To test your query and see the result, click execute button. If the query works correctly, results wil be displayed as shown below.

Recurrence

In the recurrence sections, users can setup schedule and frequency for the current report. Use drop down menu to choose frequency. Available options are: Monthly, Weekly, Daily, Hourly.

After setting report frequency, add days and time for report execution. Click 'Add Day' button and select a day and time.

Users can select multiple time slots per day.

Notice: Do not select the same day (Monday, Tuesday, Wednesday, etc.) twice. This action will cause an error and will prevent schedule report from execution.

To remove day and time selection, click 'Delete' button next to the chosen position as shown below.

Click 'Update' button to save changes.

To see the report's schedule, click 'Execution plan' button in the top right corner of the page.