Feeds:
Posts
Comments

Posts Tagged ‘General Ledger’

As a corollary to my SQL view with all posted Receivables transactions, below is a view that will add all the General Ledger distributions to the AR transactions. I made a few changes to the original AR transactions view, primarily to remove some columns that are typically not needed and add underscores to the column names so [...]

Read Full Post »

There are many different dates stored in Dynamics GP. This is typically a good thing, my philosophy is that it is always better to have more data than you need and not the other way around. However, it can get confusing rather quickly since a lot of the labels for the dates sound very similar. I will attempt [...]

Read Full Post »

Below is a SQL script to create a view showing all posted General Ledger transactions in Dynamics GP. This has the common columns asked for on reports, but you can certainly add your own as needed. For additional SQL code, please visit my GP Reports page. A few notes on this view:

Year-end close transactions are excluded
Only functional amounts are [...]

Read Full Post »

While I work with SQL and Crystal Reports every day, there are some reports that are just easier created elsewhere. One example is a GL Trial Balance that you want to export to Excel. There are many ways of handling this requirement, I like using FRx for it.  Below are steps by step instructions on how to [...]

Read Full Post »

This is a common question, especially with new users of Dynamics GP, and I was recently reminded of it by a post in the Microsoft Dynamics GP Newsgroup. While every transaction type will be slightly different, there is a basic lesson that is important for all GP users: beware of the Delete button. Most GP actions are updated automatically [...]

Read Full Post »

Older Posts »