Apex Roadmap. Session Objective. The Apex Roadmap will provide an overview of the new features offered in Apex Version 5 and outline the direction of the Apex product for the near future.
An Image/Link below is provided (as is) to download presentationDownload Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.Content is provided to you AS IS for your information and personal use only. Download presentation by click this link.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.During download, if you can't get a presentation, the file might be deleted by the publisher.
E N D
Presentation Transcript
Apex Roadmap
Session Objective The Apex Roadmap will provide an overview of the new features offered in Apex Version 5 and outline the direction of the Apex product for the near future. The infrastructure requirements of the Apex product line will also be discussed including OS, database and Crystal Reports versions supported, as well as deployment strategies and new integration capabilities. This session is geared toward Executives, Managers, and Administrators responsible for the long term planning of your bulk materials operations. BLK-001 Apex Roadmap
Agenda Roadmap Overview Allen Bryant Customer Support / Professional Services Robert Thompson Apex 5 Customer Case Studies Russ Weston / Kyle Fisher Break 11:20 – 11:30 Apex 5 Customer Case Studies Kyle Fisher / Russ Weston Apex 6 Sneak Peak - Customer Case Studies Kyle Fisher / Russ Weston BLK-001 Apex Roadmap
Apex Roadmap The 10,000 Foot View BLK-001 Apex Roadmap
Apex Release Lifecycle 2010 2011 2012 2013 2014 2009 Apex Ver 2 Apex Ver 3 Apex Ver 4 Apex Ver 5 Apex Ver 6 Current Shipping Version - Eligible for all maintenance and support services. Software changes may include new features and bug fixes. Full Support - Eligible for all maintenance and support services including software changes for reported bugs. Limited Support- Maintenance and support services limited to diagnostic related support services for problem resolution that do not require software changes. End of Life – No longer eligible for any maintenance and support services. Active maintenance contracts still eligible for software version upgrade. BLK-001 Apex Roadmap
OS and Database Platforms Apex 3 and Pervasive Database BLK-001 Apex Roadmap
OS and Database Platforms Apex 4 Windows XP, Windows Vista, Windows 7 Windows Server 2003 or Higher MS SQL Server 2005, 2008R2, 2012 Apex 5 Windows 7 Windows 8 Support ~ Q1 2013 Windows Server 2008 Windows Server 2012 Support ~ Q1 2013 MS SQL Server 2008R2, 2012 BLK-001 Apex Roadmap
Report Engine Crystal Reports & Apex 5 Print Engine completely rewritten in Apex 5 with an emphasis on Performance! New Print Service available to centrally manage many distributed printers. Crystal Reports 2011 Report Designer Backwards compatible to Crystal 2008 Changed from ODBC to Native SQL client connection Utility to convert legacy custom reports BLK-001 Apex Roadmap
Deployment Scenarios Centralized Office database in central location LAN Users or Citrix/Terminal Server Remote scale operations can be run over Citrix/Terminal Server if infra-structure is appropriate Distributed Systems Stand alone local database for plant site Data replicated to/from a central location Operations are not WAN dependent BLK-001 Apex Roadmap
Apex Development BLK-001 Apex Roadmap
Apex Development Agile Methodology Customer Collaboration Develop in Small Increments Adapt to Changing Requirements Integrated Testing Apex Releases Nightly Build/Test Monthly Release (Typical) on Current Version Patches Available to Support as Completed Favor Phased Development Releases BLK-001 Apex Roadmap
Apex Development Customer Driven Development Additional Signaling/Mapping Vendors Support Cartage Enhancements Kiosk Functionality Extensions Automation for Split Weight / Split Load Loader In-cab Ticketing Strategic Development Integration Command Alkon Platforms ERP Technology Partners Mobile Device Integration Internationalization / Localization BLK-001 Apex Roadmap
Apex Goes International Australia Columbia Chile Liberia Romania Qatar BLK-001 Apex Roadmap
Robert Thompson rthompson@commandalkon.com 913-638-1993
Contacting Apex Support By phone 800-624-1872 option 2 then 6 (24/7) 913-384-0880 option 1 (7:00 a – 6:00 p Central) By email apexsupport@commandalkon.com BLK-001 Apex Roadmap
Apex Support Staff Manager – Support Department Robert Thompson / rthompson@commandalkon.com Supervisor – Phone Support Susan Whetstone / swhetstone@commandalkon.com Project Managers Matt Fox / mfox@commandalkon.com Dan Hughes / dhughes@commandalkon.com Rick Knabe / rknabe@commandalkon.com Kristy Thompson / kthompson@commandalkon.com Staff (20) 8.7 years experience BLK-001 Apex Roadmap
Contacting Support JWS support / 7:00 a.m. – 6:00 p.m. Central Please avoid holding for more than 5 minutes. Our goal is to contact you within 1 hour. Leaving messages. Company name Phone # Who is calling? Short description of problem Open case # Avoid emails directly to support staff. Avoid leaving messages in staff voice mail boxes. BLK-001 Apex Roadmap
Contacting Support JWS support – 24/7 800-624-1872 option 2 then 6 Leave your message Company name Phone # Who is calling? Short description of problem Open case # Call will be returned BLK-001 Apex Roadmap
Cases Handled 7,200 + cases handled past year 67% closed the same day >96% closed within a week Average wait time = 2:44 Average abandon time = 3:19 BLK-001 Apex Roadmap
GoToAssist – Remote Access What is GoToAssist? (GTA) 2004-12 Support Remote Service Sessions need to be scheduled or initiated by JWS Support. 7,000+ sessions last year Average duration – 156 minutes Comments, feedback and ratings 1,400+ rated 97% positive 3% neutral Average 5 negative ratings per year BLK-001 Apex Roadmap
Call Escalation Project Managers Matt Fox / mfox@commandalkon.com Dan Hughes / dhughes@commandalkon.com Rick Knabe / rknabe@commandalkon.com Kristy Thompson / kthompson@commandalkon.com Susan Whetstone – Supervisor swhetstone@commandalkon.com Robert Thompson – Manager rthompson@commandalkon.com Apex Roadmap - Support
Scheduling Service On-site and remote service Robert Thompson Remote service Robert Thompson & Susan Whetstone After hours service Robert Thompson & Susan Whetstone Apex Roadmap - Support
International Support 24/7 toll free numbers English & Spanish Malaysia U.K. Apex Roadmap - Support
Upgrading Apex Pervasive no longer sold or supported. Operating system issues. We are adding staff so schedule soon! Test upgrade and test labs. Remote or on-site upgrades. Upgrade now! Apex Roadmap - Support
Russ Weston BLK-001 Apex Roadmap
Customer Case #1 - Globex Apex 5 – Globex Needed ERP Integration (SAP) Timely data migration between systems Data mappings between ERP and Apex Eastern European language support Romanian (Pilot) Hank Scorpio BLK-001 Apex Roadmap
Timely Data Migration How to move the data between North America and Romania? Data validity problems Network reliability problems Network performance problems BLK-001 Apex Roadmap
Data Replication Service BLK-001 Apex Roadmap
Data Replication Service Configuration Replication configuration is simple and straight forward… Error Thresholds Emails Process Monitor BLK-001 Apex Roadmap
Data mappings How to map all the SAP fields that don’t exist in Apex or are different data type or are too small? Some Examples CMR Number CIF Number VAT Number Incoterm Description SAP Item Number Port of Exit Original Vendor Packing Slip Data might be modified when in Apex Changes need to be sent back into ERP (SAP) BLK-001 Apex Roadmap
User Classes Could try to use User Classes Fields that move from Customer to Sales Order to Ticketing BLK-001 Apex Roadmap
User Types Apex 5 added more User Types BLK-001 Apex Roadmap
Worked and Not Worked Just didn’t meet all their needs, nor would it be flexible enough to meet unknown future needs. BLK-001 Apex Roadmap
UDF (User Defined Fields) User Defined Fields are treated by Apex as storage fields - no business logic or validation is performed on these fields. To Add – Run a SQL script against the Apex database/table. The field names must have an ‘UDF’ prefix. Example of 1 field in the Slordnam tableIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id IN (SELECT object_id FROM sys.columns WHERE name = 'UDFFieldname') AND name = ‘SLORDNAM')BEGIN ALTER TABLE dbo.SlordnamADD UDFFieldNameint NOT NULL CONSTRAINT Slordnam_UDFFieldName_ConstraintDEFAULT 0END BLK-001 Apex Roadmap
UDF (User Defined Fields) SQL scripts must be placed in a specific directory. C:\CAI\JWS\Apex\DBEmpty\Scripts Database upgrades will not delete the ‘UDF’ columns. BLK-001 Apex Roadmap
UDF (User Defined Fields) Design your screen BLK-001 Apex Roadmap
UDF (User Defined Fields) Design your template for the Ticketing Screen BLK-001 Apex Roadmap
Ticketing Problem Apex has 25 pre-defined scale types Different Scale Vendors than in North America Configurable Scale Types BLK-001 Apex Roadmap
Language Support Apex has hundreds of screens Globex needed Scale screen with several supporting master data screens (Customer, Orders, Tax, etc.) BLK-001 Apex Roadmap
Translation Process Created small Translation projects BLK-001 Apex Roadmap
Translated Screens BLK-001 Apex Roadmap
What’s next More Countries and Languages Czech Republic Slovakia Hungary … BLK-001 Apex Roadmap
Summary Apex 5 – Globex Needed Timely data migration between systems Data Replication Data mappings between ERP and Apex User Defined Fields Eastern European language support Translation Projects (with more languages to come) BLK-001 Apex Roadmap
Kyle Fisher BLK-001 Apex Roadmap
Slate Rock and Gravel Company Mr. Slate wanted to reduce costs by reducing overhead and improve efficiency of their sales, dispatch, and ticketing operations. Hurdles and goals: Distributed environment Reduce duplication of roles Streamline processes Accurate vehicle scheduling BLK-001 Apex Roadmap
Slate Rock and Gravel Company Keys to the solution: Distributed Dispatch Sales enhancements Dispatching improvements Use COMMANDtrack to improve vehicle scheduling Reduce weighmaster responsibilities BLK-001 Apex Roadmap
Slate Rock and Gravel Company Reduce overhead using Data Replication Central sales, dispatch, and vehicle management Remote check in/out and ticketing BLK-001 Apex Roadmap
Slate Rock and Gravel Company Improve sales productivity with new features Fax and email Attach documents Export to Excel Value Change System Navigator Mass Data Change Destinations Wizards BLK-001 Apex Roadmap
Slate Rock and Gravel Company Value Change System When a user changes a field on a sales document, that change update other fields to specific values. Template system Combine with Screen Designer Configured by system administrator An Example When the user sets the credit type to “Cash”, the value change system will set the order to “pending” and set that approval is required. BLK-001 Apex Roadmap
Slate Rock and Gravel Company The Navigator Customizable Sorting, filtering, grouping Export to Excel, PDF, CSV, HTML, etc. BLK-001 Apex Roadmap
Slate Rock and Gravel Company Mass Data Change Change hundreds of records at once… BLK-001 Apex Roadmap
Slate Rock and Gravel Company Destinations Multiple delivery addresses for an order Can be geocoded Can be dispatched Can be ticketed BLK-001 Apex Roadmap
Slate Rock and Gravel Company Wizard Improvements Create Destination from Current Order Create Dispatch from Current Order Can directly open new document BLK-001 Apex Roadmap
Slate Rock and Gravel Company Improved dispatch order management Multi-date dispatch Calculate quantity and loads by available vehicles Can be updated from parent sales order Restrict to vehicle group or vehicle type group BLK-001 Apex Roadmap
Slate Rock and Gravel Company Improve vehicle management through COMMANDtrack BLK-001 Apex Roadmap
Slate Rock and Gravel Company Apex Dispatching and COMMANDtrack in action BLK-001 Apex Roadmap
Slate Rock and Gravel Company Improved vehicle events Can trigger specific events from COMMANDtrack Can edit event history Can export event history to excel or 3rd parties BLK-001 Apex Roadmap
Slate Rock and Gravel Company Vehicle Assignments Trucks Available Vehicle assignments Vehicle events BLK-001 Apex Roadmap
Slate Rock and Gravel Company Extended Load Stack BLK-001 Apex Roadmap
Slate Rock and Gravel Company Mr. Slate wanted to reduce overhead and improve efficiency of their sales, dispatching, and ticketing operations. Accomplished by Central Dispatch with Remote Ticketing Streamlined order entry Streamlined dispatch management Streamlined vehicle management Streamlined ticket entry BLK-001 Apex Roadmap
10 Minute Break BLK-001 Apex Roadmap
System Architecture System Architecture and Management Data Replication and Distributed Dispatch Models Print Service System Configuration Divisional Hierarchies Security Auditing BLK-001 Apex Roadmap
System Architecture Data Replication Reliably transfer data from one location to another Transform data Protect data Filter data Error notification Dispatch Import Service BLK-001 Apex Roadmap
System Architecture BLK-001 Apex Roadmap
System Architecture Central Dispatch with Remote Ticketing Central sales and dispatching Remote ticketing Data Replication with Dispatch Import Service Pros: Simplified system Singular responsibilities Centralized management Minimal network, no Citrix Cons: Network connectivity required BLK-001 Apex Roadmap
System Architecture BLK-001 Apex Roadmap
System Management - Printing Print Service Simplify printer management Great for Citrix! Improve printing performance Supports all aspects of Apex printing and imaging Supports multiple languages and cultures Recommended for any multiple computer network BLK-001 Apex Roadmap
System Management – Configuration System Configuration Centralized Company -> Station Hierarchy Can be replicated BLK-001 Apex Roadmap
System Management - Security New divisional hierarchies for master data Divisions Regions Operating Groups Territories New security enhancements Restrict customers and orders by region Selective override of user group settings on a per user basis BLK-001 Apex Roadmap
System Management - Security Improved auditing for centralized systems Added support for UTC times for auditing and versioning Now can view audit history BLK-001 Apex Roadmap
System Management More details in breakout sessions on Apex Connectivity Crystal Reports Apex Dispatch and Truck Tracking Apex Security and Administration BLK-001 Apex Roadmap
Customer Case #4 – Rich Corporation Sales needs a fixed price Sales needs to schedule price changes Sales needs to project revenue Sales needs easier Zone Pricing Ability to Pay Multiple Carriers from 1 Transaction Load each vehicle to its legal maximum Posting to Database staging tables Enhance Invoicing BLK-001 Apex Roadmap
Delivered Price Sales needed a fixed priced to quote the customer BLK-001 Apex Roadmap
Price Changers Sales needs to schedule price changes Freight Freight Price List Zone Price List Orders BLK-001 Apex Roadmap
Pricing By Date Sales needed to project revenue Price History Future Prices Future Prices Price History BLK-001 Apex Roadmap
Pricing By Date BLK-001 Apex Roadmap
Advanced Zone Pricing Easier Zone Pricing Matrix of Complex Freight Rules Includes billing rates, pay rates, and minimums BLK-001 Apex Roadmap
State Weights and Tare Rules Load each vehicle to its legal maximum BLK-001 Apex Roadmap
State Weights and Tare Rules Unlimited Truck Types “Ship From” state “Ship To” state Vehicle type Federal highway Overload permit BLK-001 Apex Roadmap
Posting to database staging tables Ability to send posting detail to ERP via intermediate SQL data tables. Alternative to legacy ASCII file import/export. Posting is user defined SQL statement, providing flexibility for data field selection and transformation. BLK-001 Apex Roadmap
Multi-Ticket Edit BLK-001 Apex Roadmap
New Invoice Break Options BLK-001 Apex Roadmap
Options to Suppress Invoice Printing BLK-001 Apex Roadmap
Credit/Rebill Wizard Enhancements Now, include multiple invoices in a Credit/Rebill run BLK-001 Apex Roadmap
Credit/Rebill Wizard Enhancements New C/R ticket editor to change many tickets at once BLK-001 Apex Roadmap
Credit/Rebill Wizard Enhancements Summary of all tickets changed BLK-001 Apex Roadmap
Credit/Rebill Wizard Enhancements When you’ve completed all your C/R work, print and post all. BLK-001 Apex Roadmap
Rich Corporation Numerous Pricing Enhancements Numerous Invoicing Enhancements More Back Office Enhancements to come BLK-001 Apex Roadmap
Vandelay Industries Art wants to be able to Accurately track vehicles Pay based on distance Minimize driver downtime Minimize driver interaction with dispatchers and weighmasters Hurdles and goals: Want tracking, but not Trimble Want mapping, but not Trimble Streamline process for drivers Fix short scale problem BLK-001 Apex Roadmap
Vandelay Industries Keys to the solution: Enhance signaling and mapping Enhance freight pricing via Freight Price Lists Enhance Vehicle Mass Management Short scale support Split load support Advance Shipment Notification BLK-001 Apex Roadmap
Vandelay Industries Enhanced vehicle signaling Support COMMANDfleet 3rd Party Standard Simultaneous support for multiple signaling systems Custom driver messages at ticketing Custom driver messages when changing location Message multiple vehicles at once BLK-001 Apex Roadmap
Vandelay Industries Enhanced mapping New Command Alkon standard Locate vehicle or group of vehicles Geocode plants, quotes, orders, destinations, and dispatch orders Source Location BLK-001 Apex Roadmap
Vandelay Industries Calculation of drive time and distance from plants to jobs Saves to sales documents Inherited by dispatches, tickets BLK-001 Apex Roadmap
Vandelay Industries Dynamic relocation of job site based on vehicle unloading Updates dispatches, in-transit tickets, and vehicles BLK-001 Apex Roadmap
Vandelay Industries Freight Price Lists Pay per distance, per unit, per load, or percent Pay per distance can be setup with intervals Inherit from other freight price lists Apply based on product group, freight mode, rate type, freight unit, and carrier type BLK-001 Apex Roadmap
Vandelay Industries Vehicle Mass Management Create unique configurations for vehicles and trailers Assign default configuration in vehicle screen Assign specific configuration in ticketing BLK-001 Apex Roadmap
Vandelay Industries Short scale support (Split weight) Attended or unattended Based on length of vehicle + trailers vs. scale length Weight 1 Weight 2 BLK-001 Apex Roadmap
Vandelay Industries Advance Shipment Notification Notify COMMANDbatch system when product is ticketed Automatically update inventory Adding support for notifying Apex system BLK-001 Apex Roadmap
Vandelay Industries Inventory Products Assign inventory product to a saleable product BLK-001 Apex Roadmap
Vandelay Industries Art wants to be able to accurately track their vehicles and pay them accurately on a per mile or a time basis. They also want to streamline process by minimizing required driver interaction with dispatchers and weighmasters. Accomplished by: Vehicle signaling and mapping improvements Simplified freight pricing via Freight Price Lists Simplified vehicle handling via Vehicle Configuration Speed up ticketing with split weight and split load support BLK-001 Apex Roadmap
Customer Case #6 - Virtucon Ticket from within a Loader Edit the tickets Total Price Improve Split Product Ticket Deliver documents electronically Additional Language Needs Douglas (“Dougie”) Powers BLK-001 Apex Roadmap
Wireless Loader BLK-001 Apex Roadmap
Wireless Loader BLK-001 Apex Roadmap
Ticket from Loader BLK-001 Apex Roadmap
Edit Tickets Total Price Scenario – Customer calls makes an order for $300 and will have a check at the job site. Problem – Getting the exact weight/amount nearly impossible. Solution – Ticketing allows the Total Price to be editedso that the exact amount can be collected at time of delivery. BLK-001 Apex Roadmap
Improve Split-Product Ticket Definition - A split product ticket is one where the truck is loaded with two products destined for the same customer – one product in the truck or first trailer and a second product in the next trailer. Since both products are for one customer, it’s desirable to create one ticket with both products. Apex currently handles a “split product” load by creating two tickets. BLK-001 Apex Roadmap
Improve Split-Product Ticket Apex will improve the method of creating one ticket with two products, each with a separate weight. The ticket screen will be modified to allow the user to enter the first product, then record the weight for the first product, then enter the second product and record the weight for the second product, and finally print the ticket that includes both products. BLK-001 Apex Roadmap
Document Delivery BLK-001 Apex Roadmap
More Languages Additional Languages Finnish Estonian Russian BLK-001 Apex Roadmap
BLK-001 Apex Roadmap
Please Complete Your Evaluation Be sure to circle the session you are evaluating on the back of your card Bulk (Track Name) BLK-001 (session code) Apex Roadmap (session title) All breakout session materials can be accessed at:www.commandalkon.com/cc2012/update/index.htm Thank You! BLK-001 Apex Roadmap