# DynamicAccounting.net

> Mark Polino's blog on Microsoft Dynamics GP (2005–2024): 8,040 posts, 2,359 of them original articles on GP setup, financials, reporting, SQL, Excel, year-end, development and fraud/controls. The rest are short pointers to other GP writers. Archived; content reflects the GP version current when written.

Every post is available as HTML at its URL and as Markdown at `<url>index.md`.
The home page sells Historical Excel Reporting for Dynamics GP (HATB AR/AP, HITB, Historical Stock Status in Excel).

MCP server (Streamable HTTP, no auth): https://dynamicaccounting.net/mcp with tools search_archive, get_post, list_topics, list_topic_posts.
Plain HTTP API for curl/shell agents: https://dynamicaccounting.net/api/ (e.g. https://dynamicaccounting.net/api/search?q=smartlist). CLI: https://dynamicaccounting.net/dacct

## Bulk files

- [All original articles, full text](https://dynamicaccounting.net/llms-full.txt)
- [Every post as JSON Lines](https://dynamicaccounting.net/ai/posts.jsonl): title, date, kind, topics, GP versions, summary, markdown

## Topics (full text per topic)

- [General Ledger & Financials](https://dynamicaccounting.net/ai/topics/general-ledger.md): GL, chart of accounts, account segments, budgets, period close, bank rec, multicurrency, analytical accounting. (248 articles)
- [Payables & Receivables](https://dynamicaccounting.net/ai/topics/payables-receivables.md): AP, AR, vendors, customers, checks, EFT, aging, cash receipts, collections. (204 articles)
- [Sales, Purchasing & Inventory](https://dynamicaccounting.net/ai/topics/distribution.md): SOP, POP, inventory, item costing, manufacturing, field service, project accounting. (208 articles)
- [Payroll & HR](https://dynamicaccounting.net/ai/topics/payroll-hr.md): US and Canadian payroll, HR, benefits, W-2, payroll tax updates. (61 articles)
- [Year-End & 1099](https://dynamicaccounting.net/ai/topics/year-end-tax.md): Year-end close, 1099s, W-2 and tax update guidance. (47 articles)
- [Reporting & BI](https://dynamicaccounting.net/ai/topics/reporting.md): SmartList, Management Reporter, FRx, SSRS, Excel reports, Report Writer, Business Analyzer, Jet, Power BI. (292 articles)
- [Excel & Office](https://dynamicaccounting.net/ai/topics/excel-office.md): Excel techniques, Office integration, Word templates, Outlook and Office 365 with GP. (127 articles)
- [SQL & Data](https://dynamicaccounting.net/ai/topics/sql-data.md): SQL scripts, GP tables, SQL Server administration, data fixes, check links and reconcile. (145 articles)
- [Install, Upgrade & Admin](https://dynamicaccounting.net/ai/topics/install-admin.md): Installs, upgrades, service packs, security, users, web client, Citrix/RDS, performance and errors. (430 articles)
- [Development & Integration](https://dynamicaccounting.net/ai/topics/development.md): Dexterity, VBA, Modifier, eConnect, Integration Manager, web services, VS Tools, SmartConnect, APIs. (152 articles)
- [Tips & Hidden Features](https://dynamicaccounting.net/ai/topics/tips-features.md): Quick tips, features of the day, how-tos and lesser-known corners of Dynamics GP. (622 articles)
- [Fraud, Audit & Controls](https://dynamicaccounting.net/ai/topics/fraud-controls.md): Embezzlement stories, fraud prevention, internal controls, audit, SOX. (72 articles)
- [Microsoft & the GP Ecosystem](https://dynamicaccounting.net/ai/topics/microsoft-ecosystem.md): Roadmaps, licensing, Convergence, GPUG, MVPs, partners, ISVs, and Dynamics 365 / Business Central moves. (665 articles)
- [Accounting & Career](https://dynamicaccounting.net/ai/topics/accounting-career.md): The accounting profession, CPAs, finance careers, productivity and general business. (33 articles)
- [Off-Topic & Miscellaneous](https://dynamicaccounting.net/ai/topics/other.md): Holiday notes, Friday fun, and posts that don't fit a GP topic. (356 articles)

## Pages

- [Historical Excel Reporting for Dynamics GP](https://dynamicaccounting.net/): product page
- [Archive home](https://dynamicaccounting.net/archive/): search, topics, years
- [Best practice guides](https://dynamicaccounting.net/best-practices-2/index.md)
- [About Mark Polino](https://dynamicaccounting.net/about-me/index.md): CPA, former Microsoft MVP, author of the Microsoft Dynamics GP Cookbook series
- [Presentations](https://dynamicaccounting.net/presentations/index.md)

## Optional

- [Index of all 2,359 original articles](https://dynamicaccounting.net/ai/articles.md): title, date, topics, Markdown link