DynamicAccounting.netYou, Me, and Dynamics GP

2010-11-10 · 2010

SQL Queries for AA Summary Balances in Dynamics GP

SQL & DataGeneral Ledger & Financials

Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

 

Someone call the rescue squad for veeyeskay. Apparently he has been kidnapped and forced into SQL slave labor. At the rate he’s been releasing SQL queries for Dynamics GP he must be locked in a dark room and chained to a PC with instructions to write SQL code or else. His latest work includes:

SQL Query for AA Multicurrency Summary Balances

SQL Query for AA Functional Summary Balances

SQL Query for GL Summary Balances

Somebody please rescue him from a lifetime of forced SQL slavery. Until then, enjoy the code.