DynamicAccounting.netYou, Me, and Dynamics GP

2007-11-13 · 2007

Cleaning Out the SQL Closet

SQL & Data

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

Ben Hollowel has been bugging me to clean out my closet of SQL stuff and get it up on the site. Well, I added a few things today. There’s probably a few more but I have to find them and clean them up. Added today are:

  • SQL code to check if reconcile needs to be run for an account
  • SQL code to change an inventory items unit of measure
  • SQL code to generate and AP Historical Trial Balance

I’ll keep looking Ben. The problem is that so much of the stuff from the past is very specific and doesn’t translate to general usage.