Spreadsheet Server for use with Lawson

Spreadsheet Server for use with Lawson


Spreadsheet Server for use with Lawson

You can combine the power of Lawson with the familiarity of Excel with Spreadsheet Server. 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.

The Query Designer component of Spreadsheet Server for use with Lawson 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.


  • 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
  • Use the narrative reporting feature of Spreadsheet Server to automatically generate your pre-formatted Excel reports in Word, PDF, or HTML format

  • 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


  • 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

  • Rush-Copely Medical Center

    Rush Copely Medical Center Rush-Copley Medical Center is the leading services provider to the greater Fox... Read More
  • 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


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

    Prior to utilizing Spreadsheet Server, National Heritage Academies used Crystal Reports and had to rely on their IT department to generate the reports, which was very inefficient.

    ...Read More

Technical Requirements

View a listing of the Technical Requirements for Spreadsheet Server.