Posts Tagged ‘eConnect’
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
Miscellaneous Logs is one of the defined transaction types in Dynamics GP -Project Accounting. When I discuss or demonstrate Misc. Logs with prospects and clients, they usually look at me in a way that indicates there is no way they would ever use that functionality. However we have clients who have used this transaction type extensively and effectively.
An example is a client that performs engineering inspections for large residential home builders. They perform inspections for roofs, foundations, windows, etc, for every home in new large housing developments. They charge their clients for each type of inspection on each new home, so there is a lot of data.
Before GP, they were collecting data in Timeslips, and manually entering into QuickBooks.
This is how they used Project Accounting:
- New projects were set up in Project Accounting so that each inspection type, on each new house was represented by a unique Cost Category. This process was automated using eConnect.
- Each Cost Category had a Miscellaneous Log budget that represented the inspection type, the quantity of inspections (usually 1), and the price, e.g. $115. The advantage of this was that they had significant detail to indicate to their clients exactly what the clients were being billed for.
- On a daily basis newly performed inspections were being imported from a field time gathering system using eConnect, and individual Miscellaneous Log transactions were being created for the specific Cost Categories.
- On a periodic basis the client would run the Cycle Billing routine to create invoices for all the inspections that had been performed.
Because the Cost Category budgets were set up for each inspection type and house, the home builders were not being billed twice for the same work, and our client now knew exactly what was not being billed. As it turned out; after using GP for several months, our client realized that they had previously been under-billing their clients by a lot. And because the whole process was automated, the effort involved in billing, decreased.
This is an example of how one client used Miscellaneous Logs to solve their business issues, and we have others who have used the Project Accounting transaction types in amazing ways.
In the case cited, eConnect was crucial to automate the project set up and transaction creation process. Otherwise the sheer volume of work would have killed the project. Because of the automation, the GP users at this client hardly interact with Project Accounting at all, for transactions and setup.