Settings guide.

Mock examples for the local S200Dashboards.io settings screen. Use your own Sage 200 Evolution server, database and business rules.

How to installStart a 7 day trial
S200Dashboards.ioRefresh in 4m 06s

Sales Pulse

Ahead
+18.4%

48,620 today vs 41,060 previous sales day.

Price Watch

Action needed
23 items

8 below cost and 15 below the target GP%.

Order Watch

Review
36,840

12 open order lines currently below target margin.

Stock Shortfall

At risk
17 products

29,440 of demand is not covered by planned supply.

What each setting is for

Below we show the sort of choices a user or IT person will see when connecting S200Dashboards.io to Sage 200 Evolution. Each user has their own personalized settings.

SQL connection

YOUR-SQL-SERVER

Enter the SQL Server or instance that hosts Sage 200 Evolution.

SageCompanyDemo

Choose the Sage company database for this user.

SQL username and password

Use Windows Authentication if the Windows user already has read access. Otherwise create a read-only SQL login.

Evoreader
••••••••••••
Demo Trading Company

This name is shown in the app so users know which company database they are viewing.

SQL login permissions

Create a SQL login called Evoreader and map it to each Sage company database that needs dashboards.

The login should be read-only. Tick db_datareader and public. Do not use SQL sa or a Sage administrator account.

Login Properties - Evoreader
  • General
  • Server Roles
  • User Mapping
  • Securables
  • Status
MapDatabaseUserDefault Schema
[x]SageCompanyDemoEvoreaderdbo
[x]SageBranchDemoEvoreaderdbo
[ ]master
Database role membership
[ ] db_accessadmin[ ] db_backupoperator [x] db_datareader[ ] db_datawriter [ ] db_owner[x] public

Sage and dashboard defaults

V8-V12

Choose either V7 or V8-V12. This helps the dashboards use the correct Sage table structure.

Overall

Choose whether Sage 200 Evolution is configured to hold one overall cost per inventory item, or a separate cost per warehouse.

25

This affects the red, amber and green traffic light colours on margin and price dashboards.

MAIN - Main Warehouse

Choose All Warehouses or select a specific warehouse you would like certain dashboards to report on.

July

Adjust this to match your own reporting year.

Rep on Transactions

Choose Rep on Transactions or Customer Record Rep depending on how you operate your business.

2 decimals

Controls home currency, financial value and unit price display. Quantities and percentages are unchanged. You can set it to use 0, 2 or 3 decimal places.

Order statuses to exclude

1 - Order on Hold
2 - Awaiting Payment

Statuses selected here are excluded from order dashboards such as Order Line Up, Sales Order Ageing, Back Order Status and Order Fulfillment.

Dashboards and refresh

Manufacturing Demand
Build Requirements
Stock Shortfall
Dead Stock
Stock Exposure
Stock Runway
Stock Policy Planner
Stock Below Safety
Negative Stock Watch
Margin Performance
Data Quality Watch
Duplicate Product Watch
Purchase Price Inflation
Supplier Delivery Performance
Customer Drop-Offs
Product Drop-Offs
Customer Product Drop-Offs
Customers On Hold
Debtor Watch
Debtor Risk Sales
Email Hygiene
Transaction Search

Hidden dashboards are removed from the top dashboard buttons and traffic-light summary for this Windows user.

Data Quality Watch ×Duplicate Product Watch ×
Every 15 minutes

Options are Off, Every 5 minutes, Every 15 minutes or Every 30 minutes. Users can still refresh manually.

Included when enabled on the website account

Extra company databases use the same SQL authentication, Sage version, inventory cost mode and rep source as the main connection.