Spreadsheet Server for use with Lawson

Spreadsheet Server for use with Lawson

Overview

Spreadsheet Server for use with Lawson

You can combine the power of Lawson with the familiarity of Excel with Spreadsheet Server, Powered by the QueryExchange™ This Microsoft Excel Add-In provides dynamic Lawson reporting (for use with M3 and S3) and analysis from the Lawson ERP into Excel. Your organization's users have complete control over the design and content of your Lawson Excel reports from Lawson modules, including General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Manufacturing, Supply Chain and more... Users can create dynamic dashboard views from Lawson. These views can be accessed, automated and presented with our formula driven methodology, including summary balances and detailed drill-downs.

In addition, the cloud-based QueryExchange™ gives customers the ability to select from pre-built queries and tailor them to meet their specific needs. Utilized in the QueryExchange™, the SmartPak™ feature is way to group pre-configured queries together. Searching by selecting a SmartPak™ gives users a quick and reliable way to access a group of dedicated pre-defined queries. The Query Designer allows users to build dashboard views from any transactional database or any Lawson ERP application to be accessed, automated and presented with our formula driven methodology.

It uses company level security as defined in your Lawson application. Security is controlled and administered by the user to restrict the accessible areas of data.

BENEFITS INCLUDE:

  • Quick-Start install for Lawson users
  • Dramatically reduce number of days to close your books
  • Leverage existing Excel knowledge and write reports from Lawson within minutes
  • No more downloading or re-keying/exporting of Lawson balance or transaction level data
  • More timely report running and full drill-down capability within specific Lawson modules
  • Increase efficiency and timeliness of your budgeting process in Lawson
  • No staging areas or data warehousing needed
  • Excel 2010 64-bit support
  • Excel 2013 64-bit support

Features

  • Spreadsheet Server for use with Lawson screen shot Click to Enlarge

    Ability to publish any report from executive-quality to fully customizable Lawson ad hoc reports within Excel.

  • Query Designer for Lawson screen shot Click to Enlarge

    Use the Query Designer to create queries specifically for Lawson.

  • Distribution Manager for Lawson screen shot Click to Enlarge

    Automate distribution of Lawson Excel Reporting with the Distribution Manager utility

Case Studies

  • ProMedica

    ProMedica Established in 1986, ProMedica is a mission-based, not-for-profit healthcare... Read More
  • National Heritage Academies Case Study

    National Heritage Academies J.C. Huizenga founded the National Heritage Academies, Inc. (NHA) in 1995... Read More

Testimonials

  • National Heritage Academies utilizes Spreadsheet Server to minimize IT Intervention.

    Prior to utilizing Spreadsheet Server, National Heritage Academies used...

    Read More

Technical Requirements

View a listing of the Technical Requirements for Spreadsheet Server.