Application
Sendmaster Export Service
v18.1 — emails & SMS on schedule
Type
Web Application
UI and local DB
App Server
AIDAGPWC01V
SendMaster host
Database Server
AIDAGPWC01V
Local SendMaster database

System Details

Send Master
Name Send Master (Automate Customer Statements) Application 18.1 — Sendmaster Export Service sends out emails and SMS messages on a schedule Application Type Web application having UI and local DB App Server AIDAGPWC01V Database Server AIDAGPWC01V

What SendMaster Does

Communication Layer

SendMaster is a custom Aidacare web-based scheduling and communication application built around Microsoft Dynamics GP data. It allows business and finance users to create and manage scheduled email, SMS, file, and report-based communications using configurable folders, SQL-driven datasets, message templates, merge fields, and report attachments. The tool reads required customer, finance, service, and statement data from the GP SQL Server, generates outputs such as SSRS reports, Crystal Reports, Excel files, or PDFs, and sends them to customers or internal stakeholders through email and SMS channels.

Operational Controls

Governance

SendMaster provides operational controls such as run-now execution, schedule enable/disable, execution logs, success/failure tracking, completion queries, orphaned log review, and role-based permissions — making it a governed communication automation layer on top of Dynamics GP rather than a standard GP module.

Why SendMaster Is Needed

In Simple Terms

GP is the system of record, but it is not designed to be a flexible customer communication scheduling platform. Microsoft Dynamics GP holds the finance, customer, statement, sales, and service data. However, sending personalised statements, reports, reminders, SMS messages, Excel files, PDFs, and operational notifications on a recurring schedule requires additional orchestration. SendMaster sits on top of GP and converts GP data into scheduled, template-driven communications.

GP stores and processes the business transactions. SendMaster automates how selected GP data is communicated to customers and internal users.

Without SendMaster, the outcome would probably require a mix of manual GP report runs, SQL scripts, SSRS subscriptions, Outlook/email handling, SQL Agent jobs, and ad hoc support from technical users. That increases operational risk, manual effort, and dependency on a few people.

Why GP Alone Is Not Enough

GP vs SendMaster
Why GP alone is not enough What SendMaster adds
GP has transactional data, but limited business-user-friendly scheduling for custom communications Web-based schedule setup for email, SMS, files, and reports
GP reports usually need manual running, exporting, or emailing Automated report generation and delivery
GP is not ideal for dynamic email/SMS templates with merge fields Personalised templates using customer name, period, email address, etc.
Sending monthly statements to hundreds of customers manually is time-consuming Bulk scheduled customer statement automation
GP users may need SQL/reporting knowledge to extract the right data Predefined SQL datasets and report configurations exposed through SendMaster
GP does not provide a dedicated communication execution dashboard Logs showing success, failure, status, and message counts
GP security is around GP functions, not custom communication schedules Role-based access for schedule view/setup/edit permissions
Exceptions may require manual checking across GP, reports, email, and SQL Centralised failure visibility, orphaned logs, and rerun support

SendMaster Capabilities

Diagram
SendMaster capabilities diagram
SendMaster capabilities — communication automation on top of Dynamics GP
Architecture: SendMaster runs as a web application on AIDAGPWC01V with its own local database on the same server. It reads customer, finance, and statement data from the GP SQL Server and delivers scheduled communications via email and SMS through the Sendmaster Export Service (v18.1).

Solution Architecture

Diagram
SendMaster solution architecture diagram
SendMaster solution architecture @ Aidacare
Application Sendmaster Export Service v18.1 — web application with UI and local DB App Server AIDAGPWC01V Database Server AIDAGPWC01V (local SendMaster database) Data Source GP SQL Server — customer, finance, service, and statement data Output Formats SSRS reports, Crystal Reports, Excel files, PDFs Delivery Channels Email and SMS
Workflow: Business users configure schedules, SQL datasets, templates, and report attachments in SendMaster. On schedule (or run-now), SendMaster queries GP data, generates outputs, merges template fields, and dispatches communications — with execution logs and failure tracking throughout.

Data Flow

Diagram
SendMaster data flow diagram
SendMaster data flow — from GP data through report generation to email/SMS delivery

SendMaster App Screens

6 Screenshots

Application screen captures from the SendMaster web UI — schedule setup, message templates, execution logs, and communication management on AIDAGPWC01V.

SendMaster app screen 1
App Screen 1
SendMaster app screen 2
App Screen 2
SendMaster app screen 3
App Screen 3
SendMaster app screen 4
App Screen 4
SendMaster app screen 5
App Screen 5
SendMaster app screen 6
App Screen 6

Technical Document

Integration

SendMaster integration documentation — architecture, data sources, scheduling, and GP integration details.

Download SendMaster Integration Documentation (.docx)