Browse by Tags
All Tags » GP Reports ( RSS)
-
|
This has been a hot topic in the newsgroups lately and several people have asked me if I have any code for Receivables (AR) apply information in Dynamics GP. Below is a view that should help you get started if you’re building a report to show AR...
|
-
|
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...
|
-
|
The Crystal Reports tip from Flexible Solutions GP Reports November newsletter shows how to selectively highlight values in a list without having to write a formula. Let’s say you have a customer list with balances: Now what if you wanted to make...
|
-
|
This view is a little bit of a twist on my previous SQL view for inventory quantities on hand . The results of this view will give you a list of your Microsoft Dynamics GP inventory items, current quantities and the last sales and purchase dates along...
|
-
|
Here is a tip from the Flexible Solutions GP Reports October newsletter on how to create a running total in Crystal Reports. Running totals are a great way to show totals that have a different calculation than a subtotal without having to write additional...
|
-
|
I have published SQL views that return all posted Payables payments in Dynamics GP and Payables apply information to help identify what payments (or credits) paid off an invoice, however another frequent request is for a list of payments and their apply...
|
-
|
Payables Transactions have been a popular request for reports lately. Below is a view that lists all posted Payables transactions in functional currency. Voided transactions are not excluded. For other SQL views on Dynamics GP data, please visit my GP...
|
-
|
This view is in response to more than a few inquiries I have had for a vendor check report. This view brings in all payments, not just checks, so if only checks are needed, add the following to the end of the WHERE clause: AND P.PYENTTYP = 0 For other...
|
-
|
Here is a SQL view that will return all unapplied Receivables transactions in Dynamics GP. This will calculate how many days overdue unapplied transaction are. If something is not overdue, or if it is a credit transaction (payment, credit or return) 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...
|
-
|
From the Flexible Solutions’ GP Reports July 2009 Newsletter , here is a great new tip: how to calculate next Monday’s date in Crystal Reports. This comes up periodically when someone wants to have weekly columns on a report showing totals...
|
-
|
Here is the latest Crystal Reports tip from the Flexible Solutions GP Reports June 2009 newsletter : how to work with addresses. Dynamics GP (and probably many other systems) stores address components in separate fields, so if we look at a customer address...
|
-
|
I haven’t had much time to blog lately as we have added functionality to our GP Reports Viewer product that allows seamless replacement of SOP reports in Dynamics GP and the amount of interest has been overwhelming. However, I just needed to create...
|
-
|
The May 2009 Flexible Solutions GP Reports Newsletter brings us a tip for dynamically changing decimal places in Crystal Reports. This can be really useful for creating Sales Order Processing (SOP) reports for Dynamics GP, where GP stores the number of...
|
-
|
Here is a script that I have found useful on numerous occasions – it returns the lines items for all SOP (Sales Order Processing) transactions, both posted and unposted. This view will work with either SmartList Builder or Crystal Reports. For more...
|
-
|
Here is the latest tip from the Flexible Solutions GP Reports Newsletter : how to add a watermark to your Crystal Reports. I am going to demonstrate with an example. I have created a statement report, but it’s a little bland, especially when there...
|
-
|
Below is code to create a SQL view that returns all the posted Receivables transactions in Dynamics GP. I have had an abbreviated version of this view on my GP Reports page for a while, but I cleaned it up a bit and gave it some more friendly column names...
|
-
|
Something I have been asked more than a few times is how to use a SQL view in SmartList Builder to create a new SmartList. I am going to walk through this step by step using Dynamics GP 10.0 SP 3 and SQL Server 2005 SP 3: STEP 1 - create SQL view To start...
|
-
|
Here is a new Crystal Reports tip from the Flexible Solutions GP Reports newsletter . I have added an example with some screenshots to better illustrate. Want to spruce up your Crystal report a little by adding alternate color shading to the lines? Here...
|
-
|
As a corollary to my view showing the Dynamics GP 10.0 security roles and tasks assigned to users , I have created another view that adds the security resource details. Thank you very much to Tim Foster for pointing me to a newsgroup post by David Musgrave...
|
-
|
Dynamics GP 10.0 has brought about a drastic change in GP security. Not only is the security pessimistic now, so by default no permissions are granted, but setting up and administering security is quite different from what many of us are used to after...
|
-
|
Here is the latest Crystal Reports tip from the Flexible Solutions GP Reports Newsletter: Ever try to delete a parameter from a Crystal Report and get a pop-up message saying the field is in use on the report and then discover that you can’t find...
|
-
|
Here is a view to show all Sales Order Processing line items with the SOP-POP link in Dynamics GP. You can use this with either SmartList Builder Crystal Reports, as I have made sure not to put any spaces in the column names. I maintain a list of all...
|
-
|
A new page is now available with table information for the Bank Reconciliation module . I have reorganized all the pages a little so they are now alphabetized on the sidebar to the right and hopefully easier to find. All of the available pages as well...
|
-
|
Here is a tip from the Flexible Solutions GP Reports newsletter: Often when creating a Crystal report for something that needs a new page for each group (like Invoices or Purchase Orders) we use the New Page After option for the Group Footer in Crystal’s...
|
More Posts Next page »
|
|
|
|
|
|
|