Browse by Tags
All Tags » General Ledger ( RSS)
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
The topic of General Ledger distributions for Sales Order Processing transactions has been known to cause a fair amount of confusion for Dynamics GP users. I would like to address some of the typical questions we receive on this. You can click on the...
|
|
|
|
|
|
|
|