Reporting & Analytics

Reporting tools deployed in the Aidacare MS-GP environment — financial reporting, operational SSRS, real-time enquiry, and cross-system data analysis.

Source: Aidacare ERP MS-GP Infrastructure Details.docx (QR-IT-INF-001 V0.1) Primary server: AIDAGPDEV01V · SQL: AIDASQL01P

Reporting Tools

Management Reporter, SSRS, SmartView, SmartList, Popdock

SSRS Host

SQL 2019

AIDASQL01P

SmartView Version

2.0.70

On AIDAGPDEV01V

Power BI

TBD

Not documented in TechCodebase

Reporting Tools Summary

Tool	Primary Purpose	Host Server	Version	Primary Users
Management Reporter	Financial reporting — P&L, Balance Sheet, Budget vs Actual	Connected to GP DBs	TBD (listed as NA)	Finance team
SSRS	Operational reports — stocktake, inventory, SOP reports	AIDASQL01P (SQL Server 2019)	SQL Server 2019 built-in	Operations, Warehouse, Finance
SmartView	Real-time GP data enquiry — interactive views of GP tables	AIDAGPDEV01V	v2.0.70	Finance, Ops, Admin
SmartList	Ad-hoc data export from GP tables (built-in GP module)	AIDAGPDEV01V (within GP)	Standard GP built-in	All GP users
Popdock	Cross-system data enquiry and GP reporting	AIDAGPDEV01V	TBD (listed as NA)	Finance, Management
Power BI	TBD — not documented in TechCodebase	TBD	TBD	TBD

Source: Aidacare ERP MS-GP Infrastructure Details.docx (QR-IT-INF-001 V0.1)

Management Reporter

Financial Reporting

Purpose P&L, Balance Sheet, Budget vs Actual financial reports Data Source Connects directly to GP databases (GL tables — GL10000, GL20000, GL00100) Version TBD — Listed as NA in infrastructure doc. Confirm with Aidacare IT. Primary Users Finance team Report Types Profit & Loss, Balance Sheet, Budget vs Actual (standard MR report types) Specific Reports TBD — Specific reports configured at Aidacare require validation Refresh Behaviour Reflects posted GL transactions only — unposted batches will not appear in MR reports

Data Flow to Management Reporter

Sub-ledgers post to GL
AR, AP, Inventory, WennSoft, SOP

GL Tables (TWO database)
GL10000, GL20000, GL00100

Management Reporter
Reads GL data directly

P&L / Balance Sheet / Budget vs Actual reports

Management Reporter version is listed as NA in the infrastructure document. Version should be confirmed with Aidacare IT to assess patch status and support eligibility.

SQL Server Reporting Services (SSRS)

Operational Reports

Platform SSRS built into SQL Server 2019 on AIDASQL01P Primary Use Operational reports — stocktake, inventory, SOP reports Stocktake Reports SOP_SSRS Reports Usage for Stock Take.docx documents stocktake-specific SSRS reports Custom Reports Inventory TBD — Custom SSRS reports in use require Aidacare validation. Full report catalogue not in TechCodebase. Access TBD — SSRS report portal URL not documented

Stocktake SSRS Reports

The stocktake process uses specific SSRS reports. Refer to the SOP for usage details.

SOP: SSRS Reports Usage for Stock Take

File SOP_SSRS Reports Usage for Stock Take.docx Purpose Documents how to use SSRS reports during the stocktake process — pre-validation, count sheets, variance analysis Location GP Tech Support SOP Documents/GP Functional Module SOPs/

Download SOP

GAP-009: SSRS report inventory is not documented in TechCodebase. A full catalogue of active SSRS reports should be compiled and documented. See Risks & Gaps Register.

SmartView

v2.0.70

Version 2.0.70 Host AIDAGPDEV01V (10.26.21.43) Purpose Real-time GP data views — interactive enquiry of GP tables without leaving GP client Use Cases Operational enquiries, exception reporting, data validation, live transaction lookup Data Access Read-only access to GP databases via ODBC service account Users Finance, Operations, Admin — any GP user with SmartView licence

SmartList

GP Built-in

Type Standard GP built-in module (included with Microsoft Dynamics GP) Purpose Ad-hoc data export from GP tables — query builder with Excel export capability Use Cases Operational enquiries, data validation, ad-hoc Excel exports, exception reporting Access Available to all licensed GP users — accessed via Tools → SmartList in GP navigation Customisation Custom SmartList favourites can be saved per user or shared — details TBD for Aidacare configuration

SmartView vs SmartList — When to Use

Scenario	Recommended Tool	Reason
Quick lookup of a live GP record (customer, invoice, item)	SmartView	Real-time, embedded in GP navigation
Ad-hoc data extract for analysis in Excel	SmartList	Built-in export to Excel; flexible column selection
Recurring operational report with saved query	SmartList Favourite	Save and reuse query definitions
Cross-system enquiry (GP + other systems)	Popdock	Popdock connects multiple data sources

Popdock

Version TBD

Host AIDAGPDEV01V (10.26.21.43) Version TBD — Listed as NA in infrastructure document Purpose Cross-system data enquiry and GP reporting — connects to GP and potentially other data sources Configuration TBD — Popdock configuration, connected data sources, and available widgets not documented in TechCodebase Users TBD — Requires Aidacare validation

GAP-010 / RISK-003: Popdock version and full configuration not documented. Version confirmation required to assess patch status. See Risks & Gaps Register.