Call Us: +61 1300 858 703

Built-In Reports

Dozens of useful built-in reports are included in the SEQOS package to facilitate warehouse operation.

The comprehensive reports have been developed over many years from requests by SEQOS users.

Features include:

  • Ability to include/exclude columns in reports
  • Run automatically at end of day, end of week, end of month
  • Print to PDF file to view with Acrobat Reader
  • Export report contents to Excel spreadsheet cells
  • Configure email recipients for PDF file and Excel reports

KPI Reports and Charts

KPI Reports and Charts assist with warehouse performance measurement.

KPI Reports are configured using the SEQOS Report Wizard tool and entering criteria to determine if a KPI is met or fails. As different clients often have different KPI requirements, the ability to configure the rules for KPI reports is very useful.

Excel Charts are generated by SEQOS to compare operational transactions and location usage, by day, week or month with year-by-year comparison. The charts are useful for tracking staff performance, supplier and transport company performance, stock throughput and transaction charging.

  • Receipts (ordered and received quantities)
  • Supplier Returns
  • Repack Product function
  • Sales Orders (ordered, picked, and nil-picked)
  • Customer Returns
  • Putaway function
  • Replenishment function
  • Location Usage
  • Transaction Charging

The Location Heatmap graphically shows the relative position of each location in the warehouse, or locations selected for the report, with different intensities of colour indicating the relative quantities for a range of dates. (The data range associated with the range of colour intensities is bracketed in the list below).

  • Current stock quantity at each location (Empty/smallest quantity to largest quantity)
  • Usage percentage compared to total available at each location (0% to 100% used)
  • Relative age of stock (Newest to oldest stock)
  • Expiry date of stock (Locations with expired stock shown in red)
  • Replenishment number of visits (Least visits to most visits)
  • Picking number of visits (Least visits to most visits)

Report Wizard

The SEQOS Report Wizard is an easy step-by-step tool that quickly generates reports.

The steps are:

  1. The type of report chosen from a list: Stock, Orders, etc.
  2. Selection Criteria to match records for the report
  3. Columns to show on the report
  4. Sort records
  5. Subtotals and totals

The results can be printed as a report, graphed, or exported to Excel.


Billing Reports

Billing Reports may be generated for charging warehouse services including transactions and space utilisation. 3rd Party Logistics providers often derive their income from their clients by charging for transactions and/or space.

Transaction Charging:

  • Receipts
  • Supplier Returns
  • Order Picking and Packing
  • Customer Returns

Daily, weekly, or monthly charges.
Charges for different products or groups of products may be configured.

Services:

  • Purchase Order Creation and Maintenance
  • Sales Order Creation and Maintenance
  • Consignments
  • Proof of Delivery
  • Labour
  • Miscellaneous Services (e.g. Container Unloading, Shrink-wrapping)

Location Storage Charges by location, groups of locations, products, groups of products, unit of measure.

All charges may have a budget and maximum for that budget, then an excess applied when the maximum is exceeded. For example, a client might be charged for processing 100 orders per day, then a charge per order if 100 is exceeded.