DynamicAccounting.netYou, Me, and Dynamics GP

2011-01-17 · 2011

Multiple SQL Views for Analytical Accounting

SQL & DataGeneral Ledger & Financials

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

Sivakumar dropped a number of Analytical Accounting related SQL items on the community over the weekend including:

  • SQL View for AA Accounting Class–GL Account Link Information
  • SQL View for Receivables Transactions with AA Codes
  • SQL View For User–AA Code Access

All have been added to the SQL Scripts page as well.

Original article: http://office.live.com/error/error.html?aspxerrorpath=/view.aspx/Downloads/Dynamic%20GP%20SQL%20Scripts.xlsx