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 [...]
Posts Tagged ‘General Ledger’
SQL view with all GL distributions for AR transactions
Posted in GP Reports, GP SQL scripts, tagged General Ledger, GP Reports, GP SQL view, Receivables, SQL code on February 10, 2010 | 5 Comments »
What’s with all these dates?
Posted in Dynamics GP, tagged Bank Reconciliation, Dynamics GP, General Ledger, Payables, Purchase Order Processing, Receivables, Sales Order Processing on September 8, 2009 | 6 Comments »
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 [...]
SQL view for all posted GL transactions in Dynamics GP
Posted in GP Reports, GP SQL scripts, tagged General Ledger, GP Reports, GP SQL view, SQL code on August 11, 2009 | 7 Comments »
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 [...]
Dynamics GP Trial Balance in Excel using FRx
Posted in Dynamics GP, FRx, tagged Dynamics GP, FRx, General Ledger on July 17, 2009 | 11 Comments »
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 [...]
Where did my transaction go?
Posted in Dynamics GP, tagged Dynamics GP, General Ledger, Payables, Sales Order Processing on April 11, 2009 | 5 Comments »
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 [...]
Search this blog
Pages
Tag Cloud
-
Recent Posts
-
Top Pages & Posts
GP Version Poll
Categories
- Crystal Reports (12)
- Dynamics GP (64)
- Extender (2)
- GP 10.0 (10)
- GP 8.0 (3)
- GP 9.0 (4)
- GP SQL scripts (24)
- SmartList Builder (4)
- Events (2)
- FRx (4)
- GP Reports (38)
- Microsoft (10)
- Miscellaneous (5)
- SQL Server (8)
Archives
Frank Hamelly’s tip of the day:-
Recent Comments
Lisa Sorensen on SQL view to show all GL distri… Kathryn on Bank Rec Tables Victoria Yudin on Bank Rec Tables Erik on GL Tables Erik on SQL view for all posted GL tra… jubith on GL Tables Kathryn on Bank Rec Tables Victoria Yudin on Company/System Tables Victoria Yudin on Inventory Tables jubith on Inventory Tables -
Hits since 9.17.2008
- 144,592
