Archive | September, 2010

SQL view for Payables apply detail and GL distributions in Dynamics GP

September 23, 2010 by Victoria Yudin 37 Comments

Who doesn’t need yet another view for Payables transactions in Dynamics GP?  🙂 The view below is a combination of my Payment Apply Detail and GL Distributions for AP Transactions views. It lists all Payments, then shows the transactions they were applied to and the GL distributions of those applied to transactions. You can find other Dynamics GP Payables […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Payables SQL code
, , ,

Coding specific dates in SQL Server

September 13, 2010 by Victoria Yudin 3 Comments

Quite often when writing reports I need to write a formula to calculate dates. Dates are not very straightforward to code in SQL Server, and I have started keeping a list of various formulas so that I do not have to re-write the code every time. I have previously posted some code on calculating date differences in SQL, […]

Continue reading →
GP Reports code, SQL coding
, ,

Dynamics GP build numbers and service packs

September 11, 2010 by Victoria Yudin 34 Comments

I have posted a number of different resources in the past for finding Dynamics GP service pack levels based on build numbers, however, I wanted to put together something where you can check the major service pack builds for the main GP components all in one place. As new service packs come out, I will update […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, GP 2013, GP 2015, GP 9.0
, , , , , ,

SQL view for Payables invoices originating from POP in Dynamics GP

September 1, 2010 by Victoria Yudin 40 Comments

This Dynamics GP SQL view originated from a request on the Dynamics GP customer forum, but is also something that I can see being useful in a variety of situations. It returns all posted Payables invoices that came from the Purchase Order Processing module with details of the items that were received on each invoice as well […]

Continue reading →
Dynamics GP, GL SQL code, GP Reports code, GP SQL scripts, Payables SQL code, POP SQL code
, , , , ,