Home Ø Products Ø Malvern Manifest System Ø Malvern Link Ø Interface to Macola


For over 25 years, Malvern Systems has developed affordable, integrated, multi-carrier parcel shipping solutions for small to medium-sized companies across a wide variety of industries.


 

macola7.gif (6347 bytes)Malvern Interface to Macola

 

Overview

The Malvern Manifest System integrates seamlessly with Macola to enable a fast and accurate shipping environment.  Freight charges and tracking numbers are written back to Macola immediately to enable same-day invoicing and enhanced customer service capabilities.  Malvern will dramatically improve your overall shipping process by increasing efficiency, virtually eliminating human error, and reducing freight bills.

  • Links directly to Macola's Microsoft SQL (or Pervasive SQL) tables in Macola 7.5 and ES.

  • Imports all relevant shipping data including ship-to address, shipping mode, PO#, billing options, COD Amount, etc.

  • Exports all relevant shipping data (freight charges, tracking number, etc.) for each package and totals for each order.

  • Freight charges sent back to Macola can be carrier's published rates, your negotiated discounted rates, or either of these rate plus a surcharge.  Rates can be exported with or without an optional, configurable handling charge.

  • Fields imported & exported to and from Macola are 100% configurable (virtually any field can be passed between Malvern and Macola).

  • Data conversion tables, data manipulation, error-handling, and customer-specific business rules can be applied to any data for additional efficiencies and customized functionality.

  • Entire integration is enabled by a user and/or dealer configurable vb script.

Process & Data Flow

When a Pick Ticket is printed, data is written to Macola's ARSHOFIL_SQL table.  When the shipper scans or enters the order number, Malvern checks ARSHOFIL_SQL to confirm that the order is ready to be shipped. Then Malvern automatically imports the shipping data (ship to address, billing options, shipping mode, etc) from the OEORDHDR_SQL table.  The import routine includes all necessary data conversions (such as ship via code conversions).  Then, the shipper weighs the carton (or types in a weight), adds or modifies shipping options, and presses F12.  A shipping label is printed and the shipping data for each carton (freight charges, tracking number, ship date etc) are exported to ARSHTFIL_SQL and the total freight charges for each order are exported to the OEORDHDR_SQL table.

 

Standard Features

There are hundreds of standard features included with the Malvern Manifest System.  

Following are a few key features:

 

  • Seamless, real-time, configurable link to Macola 

  • UPS Domestic & International services

  • FedEx Domestic & International Express, Ground, Home Delivery

  • LTL & Internal Fleet Shipment Logging, LTL Rating, BOL Printing

  • U.S. Postal Service Domestic and International Rates

  • Multiple Account Support

  • FutureShip (Pack & Hold Processing)

  • Parcel search capabilities on virtually any data field

  • Dual Rating: Maintain Published Rates and Programmable Discounted Rates

  • Alternate Return Address Support

  • Unlimited Historical Archiving

  • Chargeback Accounting Reports

  • Configurable Handling Charge

  • Multi-Carrier Rate shopping sorted by carrier service level and cost

  • Numerous Standard Reports & Export File Formats

  • User-Configurable Shipment Reports

 

Benefits

  • Reduce labor costs by consolidating all shipping through a single, easy-to-use interface

  • Eliminate costly human errors with a seamless link between Malvern and Macola

  • Increase productivity due to far less data entry required 

  • Reduce freight charges by using built-in rate shopping feature

  • Automate & accelerate invoicing process with real-time and accurate freight charges written back to Macola

  • Reduce freight charges with automatic, UPS Hundredweight shipment optimization

  • Enhance service to your customers due to the ability to provide real-time tracking info

  • Reduce parcel insurance charges by 50% or more by using third-party insurance carrier

 

In the Press

Shopping Carts Internet Postage LTL Time-in-Transit Address Correction

© 2008 Malvern Systems, Inc.

All rights reserved

(800) 296-9642

Home