Call Us: +61 2 9790 8328

Enterprise System Integration

Transfer data between SEQOS and another computer systems, or upload files from your desktop computer and download files to your desktop computer.

User configurable field mapping to import and export data via various formats to SEQOS database tables, with field value validation.

Frequency Inbound data to SEQOS can be event triggered in real-time, for example, when a file is loaded, SEQOS can be immediately triggered to process the file.

Outbound data from SEQOS can also be event triggered in real-time, for example, when stock is received or when an order is picked, a file can be immediately generated and sent to the enterprise system.

Alternately, files can be processed or generated in batch, or manually generated. This can be configured separately for each transaction type so a combination of real-time, batch and manually generated transaction files can exist in the same system.
Example Client Interfaces Supported File and Record Formats File Transfer Methods
  • SAP
  • Oracle
  • BPCS
  • MFG/PRO
  • Focus
  • MYOB
  • Excel spreadsheets
  • XML
  • EDIFACT
  • Delimited (e.g. Comma Separated Value)
  • Static width columns
  • FTP
  • SFTP
  • Web services
  • Email (auto extract received files, auto send generated files)

Materials Handling Equipment Integration

Use SEQOS Assets Management to calculate depreciation on equipment and to schedule maintenance.

Forklifts and Cranes

A warehouse may have several different types of equipment which work in isolated areas. For example, a gas-operated fork lift might not be permitted into an area of the warehouse. Another example is a very-narrow-ailse crane might be restricted to the very-narrow-aisles.

SEQOS uses "staging" locations to pass stock between different types of equipment. When stock is confirmed at a staging location by one RF using a type of equipment, another suitable RF with another type of equioment is automatically triggered to pick up the stock.
Pick-to-Light SEQOS is integrated to several different brands of pick-to-light systems including a proprietary system.
Carousels

Multiple carousels operating simultaneously are supported. For example, while picking from one carousel, another carousel is instructed to turn to be ready for the next pick. The replenishment function is also integrated with the carousels by instructing the carousel to spin to the required location to replenish stock.

Multi-order picking is supported by picking the total quantity from a carousel bin and distributing to orders on a bench, all using pick-to-light.
Check-Weigh

The weight of a shipper (tote or carton) and its contents is calculated and compared with the weight transmitted from the scales. If the weight is outside a tolerance, the shipper is rejected to a "checking" lane.
Sortation Diverters Barcoded cartons for multiple orders are placed on a conveyor. A fixed-head scanner near the end of the conveyor reads the barcode and SEQOS operates a diverter at the right time for the corresponding order's lane.
ASRS (Automated Storage and Retrieval Systems)
This is intergrated with the SEQOS Automated Task Queue. The interface is customised depending on the manufacturing of the ASRS.

Web Browser Integration

Customer Portal Customers can use the Web Browser to enquire on the status of their orders, current stock levels and stock transaction history. Lists of records on enquiry screens may be downloaded to the customer's computer.

Customers can also create new orders or amend existing orders, or may upload order files.

When the order is received by the customer, the Proof of Delivery can be confirmed using a Web Browser.
Transport Portal Transport companies can enquire on loads using a Web Browser. Within the load, drill down to see orders, shippers, and shipper contents.

Record orders that were delivered, and record discrepancies such as damages and losses.
Warehouse Portal Warehouse operator access to the SEQOS application may be via a Web Browser instead of Windows-based client.

All screens displayed on SEQOS Client for Windows are shown in a similar format on the Web Browser.

Any module from the system menu can be run at any time in the same window or a new window.

Reports are generated in PDF format for printing or viewing with Acrobat Reader.

Database Integration

The very efficient native SEQOS database is the most efficient way to access and update data in the SEQOS system. Each SEQOS process runs multiple threads to read-ahead records into a cache using asynchronous I/O.

SEQOS also runs on these other databases:

  • SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • Other databases using ODBC

Multiple databases may be updated simultaneously, for example, SEQOS may run on MySQL and update an Oracle database with the same data in real-time.


Windows Desktop Integration

Records in lists on any screen may be selected and exported to Excel via a hotkey sequence.

Pictures, documents and other files can be attached to most SEQOS record types. For example, when stock is received, delivery documents may be scanned by an image scanner and attached to the SEQOS receipt data. If received stock is damaged, a photograph of the damage may be attached to the stock record. Another example is an image of every product may be attached to its product record.

As each record is scrolled in a list, or the record detail is displayed, the “Attachment” menu item in the window menu bar is updated with the list of pictures, document and other attachments relating to the current record. Click on name of the attachment to open it.