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.
- 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
Click to Enlarge
Ability to publish any report from executive-quality to fully customizable Lawson ad hoc reports within Excel.
Click to Enlarge
Use the Query Designer to create queries specifically for Lawson.
Click to Enlarge
Automate distribution of Lawson Excel Reporting with the Distribution Manager utility
Rush-Copely Medical CenterRush-Copley Medical Center is the leading services provider to the greater Fox... Read More
ProMedicaEstablished in 1986, ProMedica is a mission-based, not-for-profit healthcare... Read More
National Heritage Academies Case StudyJ.C. Huizenga founded the National Heritage Academies, Inc. (NHA) in 1995... Read More
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. Laura McDowell, Accounting Systems Analyst discusses how using Spreadsheet Server for use with Lawson has allowed her organization to enable their accounting group to independently generate their financial reports saving them a great deal of time.Read More
View a listing of the Technical Requirements for Spreadsheet Server.