Archive for the ‘SQL Server Reporting Services’ Category
Hello all, I would like to provide you with some information on what to look when Dynamics GP seems to be working slow. As you may already know Dynamics GP is a process driven application and you may experience slow performance when specific processes are performed in GP please take a look:
· While posting might be due to the PJOURNAL table as you know checks post too or remittance is being printed separately
· Client workstations should have a default printer setup and online, remove invalid printers
· While opening windows, the autocomplete feature may cause performance issues and if not used can be turned off
· While login into Dynamics GP or utilizing 3rd party dictionaries as well if Menu Master table (SY07110) became too large.
· The location of the modified dictionaries other than local workstation
· Certain Smartlist reminders might interfere with login into Dynamics GP
· You may have shortcuts to network locations that are no longer mapped or available
· Printing to file directly into the client/remote computer instead of the hosted server user folders
· OLE Notes path in Dex.ini
· SQL AutoClose and AutoShrink options not set to false
· Virus scanner setup not excluding the following extensions (CNK, DIC, CHM, SET, INI, DAT, IDX, VBA, LOG, LDF, MDF)
· The Dynamics GP homepage smartlist favorites
· The Dynamics GP homepage outlook integration
· Enabling tracing options in DEX.ini
· Bad user defined triggers in SQL
· Bad configuration of SQL server memory allocation
· SQL server or Dynamics GP server available disk space
· SQL server log file is full and is not set to Autogrow
· TNT*.* files, your %TEMP% folder has not been cleaned
· Non-compliant SQL server/GP Server/Client hardware
· Different DB owner than DYNSA
· Little or no SQL server maintenance (Table Fragmentation)
· You might be missing table indexes or statistics
· When exporting a budget, thru the budget wizard it seems locked (if you are using the excel wizard to export, make sure the “save as” dialog is not on the background, Alt-Tab to it as it must have been opened and its behind your main GP windows.
· Too much history (You can archive historical years, specially if you have large tables like Item Master, Customers, Vendors) Believe me I ran reconcile one time and it took 6.5 days on a company with more than half a million SKUs and 5 years of sales.
I have witnessed how few administrators that in order to preserve enough disk space they have a tendency of running SHRINK on the SQL server, this obviously will fragment tables affecting performance. I have a post that covers that here.
If you want us to take a look at your environment don’t forget to contact us, and as always when troubleshooting record answers for the following questions:
1.- Can you replicate the issue? write down steps that let you reproduce the issue.
2.- If its related to posting, please note the module( s ), how many transactions are in the batch, how long does the process last? how long did the process last before?
3.- On a Server/Client install, can you replicate on the server?
4.- Can you reproduce on all or other clients?
5.- Are there any 3rd party products running on the same SQL/GP server or together with Dynamics GP?
6.- Are there any customizations in GP?
Until my next post and let us know if we can help!!
Francisco G. Hillyer
Dynamics GP 2010 includes the functionality to allow users to design their own Home Page by creating their own reports in SQL Server Reporting Services, and displaying those reports to the GP Home Page.
To try this out you can create a simple report using Report Builder in SQL Server Reporting Services. Once the report is created it’s easy to add to the GP 2010 Home Page.
I created this short video that demonstrates the whole process.
This is another compelling reason to upgrade to Dynamics GP 2010.
This is a list of SQL Server Reporting Services reports that are available for Dynamics GP 10.0. You should also check out the KnowledgeBase article #954242
SVC RTV Hard Copy
Bank Transaction History Report
Fixed Asset Depreciation Detail
Fixed Assets Depreciation Ledger
Fixed Assets to General Ledger Reconciliation Report
Journal Entry Report
Period Projection Report
Source Cross Reference
Trial Balance Detail
Trial Balance Summary
Employee Attendance Detail
Employee Attendance Summary
Enrollment by Benefit
Enrollment by Employee
Purchase Advice Report
BOM Detail Report
Item Standard Cost Changes Report
Manufacturing BOM Report Standard Costs
MO PO Links Report Sort By Vendor
Picking Report – Item Number
Picking Report Multibin – Item Number
Traveler Graphics Reports
Department Wage and Hour Report
Employee Pay History
Employee Wage and Hour
State Wage Report
Vacation Sick Time List
Detail Trial Balance
Monthly Employee Utilization
PA PBW Fee
PA PBW T and M
Pre-Billing Worksheet CPFP
Pre-Billing Worksheet T and M
Project Cost Breakdown
Projects in Progress
Aged Trial Balance – by Document Date
Aged Trial Balance Details Subreport – by Document Date
Back-ordered Items Received
Historical Aged Trial Balance
Purchase Order History
Purchase Order Status
Received Not Invoiced
Receivings Trx History
Aged Trial Balance – Detail
Historical Aged Trial Balance
Receivables Sales Analysis
Sales Distribution History
Sales Document Status
Sales Transaction History
Sales Transaction History Payment Details Subreport
Sales Transaction History Tax Details Subreport
SOP Document Analysis
SOP Document Analysis by Customer
SOP Inventory Sales Report
Once you’ve got these loaded, take a look at my quick video about using the Report Builder function in SSRS.
This video shows you how to easily use the SSRS Report Builder with Dynamics GP to create quick reports.
Report Builder uses report models that come ready to use with GP. You can also create your own report models using Visual Studio.
This is a good way to get your feet wet with SQL Server Reporting Services.