Posts Tagged ‘Dynamics GP 2010’

Why my GP is too slow?

Hello all, I would like to provide you with some information on what to look when 312339_117542088417759_1094173370_nDynamics 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

What happens if I update Payroll tax tables and…

Hello all, here is something I was asked recently:

“I have processed my 2012 payrolls for the year, my IT is always on the latest and greatest regarding service packs, hotfixes, updates etc, and they installed the 2013 payroll tax tables update, and I have not executed the Payroll Year End, can I close it anyway?”

Short answer: Yes you can close it, but it will be incorrect.

Please if this happens to you, make sure to restore the Dynamics DB prior to the install of the payroll tax table update because I am sure you always do a backup of your databases prior to any updates installed right?

Leslie Vail has a post from 2011 where she explains how FICA/S wages and withholding is calculated Leslie’s Post

NOTE FOR LESLIE (Step 5b says “he year-end” instead of “the year-end”Smile)

But I wanted to provide a graphical representation of it

01-09-2013 12-21-51 PM


Until my next post…


Francisco G. Hillyer

It’s here again: Year End Processes 2012

So just like every year we go thru similar steps, I am providing some help along the way, 598846_4784214609951_774409899_nmany of the processes described here belong to a published KB from Microsoft as well links to posts from other resources but I wanted you to have them all in one place.

Please note that some of the links require you to have access to Customersource/Partnersource.


Difference between Year End Update and Payroll Tax Table Updates

The Year End Update download contains software changes to allow you to comply with 2012 filing requirements as well as the most recent fixes for your Dynamics application.

The 2013 Payroll Tax Table Updates contains updated rates and tax changes as well it might contain FICA/Medicare changes to be applied when processing 2013 payrolls.

Here is the link for the 2012 US Payroll Year End Update: Click Here

Here is the link for the US Payroll Tax Updates: Click Here

It is important to mention that you can install the Year end update prior to your last payroll for 2012, however do not install the Tax table updates before your last 2012 payroll as you might end up with a wrong calculation.

Always backup your data, your .DIC files as well.


Setting up / Adjusting Fiscal Periods in GL

Microsoft provides a KB article number 871679 KB871679


Closing Dynamics GP GL


Complete the posting/closing procedures for the modules in the suggested order prior to closing GL, please note that if you are not using a particular module, just skip it:

Follow the instructions provided in each KB

Inventory: KB 872713

Receivables Management: KB 857444

Payables Management: KB 875169

Fixed Asset Management: KB 865653

Analytical Accounting:

For Microsoft Dynamics GP 10.0 Service Pack 2 and greater, functionality was added to consolidate balances for dimensions in Analytical Accounting. Please review KB 960356 to make sure you have properly marked the dimensions that you want to be consolidated  during the year-end process. Please note that there is no separate year-end process that needs to be run in the Analytical Accounting module. When the year-end close process is run for General Ledger, it will automatically consolidate the balances and move the transactions in Analytical Accounting for dimensions that were properly marked.

PAYROLL year end procedures are independent of the procedures in other modules and are usually performed at the end of the calendar year. Please see this KB 850663


Adjusting entries are considered most of the time as entries that allow you to correct errors that were made when transactions were recorded as well they might be utilized to assign revenues or expenses to period or periods in which revenues were earned or expenses incurred.

If you need to in setup or adjust your fiscal periods in GP, please review the section “Setting up / Adjusting Fiscal Periods in GL” at the beginning of this article.


The posting type helps Dynamics GP determine whether an account will be closed to the retained earnings account or if the account balance will be brought forward to the next fiscal year.

Follow these steps to print an account list:

  1. On the Reports menu, point to Financial, and then click Account.
  2. In the Reports list, select All Accounts, and then click New.
  3. In the Option box, type all accounts.
  4. Click to select the Inactive Accounts check box. (if you want to delete inactive accounts)
  5. Click Destination to specify a report destination, and then click OK.
  6. Click Print.

Use the fiscal periods setup window to close all fiscal periods open for the 2012 year. This will prevent transactions from posting to the wrong period or the wrong year.

NOTE: If you still use Microsoft FRx, keep one period in the most recent historical year open to prevent the error: “FRX Print Engine Failed to Load the Company Calendar” see this KB 874932


Run the check links procedure on the financial series group of modules.

Make sure that you always have a backup and that you can confirm you can restore from it.


If you are like me and always want to keep historical records, you must enable the checkbox next to Accounts and Transactions in the Maintain History area of the General Ledger Setup Window.

NOTE: If for some reason you have the checkbox enabled for “Close to Divisional Segments” and you are no longer closing to Divisional Segments or by mistake someone else enabled it and not using it pay attention:

I have discovered in the past a BUG in dynamics GP that is still there as I reported in this blog in August 14, 2012, if you would like to read more about this important step please click here: YEAR END CLOSE BUG 64711


Make sure all users are out of the system

Remove stranded user sessions, you can follow this post Removing Stranded Sessions

Backup DYNAMICS database

Backup all company databases if you are unsure which databases to backup you can query the company master table (SY01500) and retrieve the names, the following script can help you determine that information.

select INTERID, CMPNYNAM from dynamics..sy01500

Make sure to backup as well the Dynamics GP code folder


Use the Trial Balance report window to print a year end detailed trial balance report. Even when this step is optional it is highly recommended to be followed.


Print any year end financial statements that are required. The most common are:

  • Balance Sheet
  • Profit and Loss Statement
  • Statement of Cash Flows
  • Statement of Retained Earnings

Before you can perform the year end closing routine, you must setup a new fiscal year, please follow the instructions on the section at the top of this article to Setup or Adjust Fiscal Periods.

  • Click on the Microsoft Dynamics GP Menu > Tools > Routines > Financial > Year End Closing.
  • If its not specified, you can key in the Retained Earnings Account.
  • Optional: Specify the Starting Journal Entry
  • Click on Close Year

Make another backup of the Dynamics DB and all the company Databases.


Thank you for reading I would like to mention that this post enhances Microsoft KB 888003 


Until my next post

Francisco G. Hillyer

How to remove the Connect section on the HomePage in Dynamics GP (via SQL)

Hello fellow readers, a few of us work in environments where we support many 282962_4217420760459_350721136_nusers or even better many instances of GP at a time.


Lately for many of our customers the Connect section has not been working as expected, for a few its just an ugly Error 404: File or directory not Found.

Error 1


Or simply it has been getting in the way of Integration Manager. Even when many colleagues like Mariano Gomez, Mark Polino, David Musgrave, Leslie Vail and others have provided help to the community on this issues. One question remained unanswered: How to massively remove it without the administrator login into each account?.

Famous engineer Tami Jones from the RoseASP team came up to my beach front office with a wonderful view of the Pacific ocean (ok it’s a 3 wall cubicle with no view) and asked me how can we automate this process as you know we team up with myGPcloud as well.


So I decided to take a look at the homepage behavior and came up with the following descriptions:


SectionID Value 1 is the ToDo Section
SectionID Value 2 is the Outlook Section
SectionID Value 3 is the Metrics Section
SectionID Value 4 is the My Reports Section
SectionID Value 5 is the Quick Links Section
SectionID Value 6 is the Connect Section


The table responsible for storing the values to display or hide those sections is SY08100 in Dynamics DB. So here is the script that will help you remove the connect section:


Code 1

With a little tweak you can limit the update statement to work only on 1 user or a set of users.

Always remember to backup your database and try statements in a test DB.


Have a great day!!!


Dynamics GP 2010 Service Pack 3 Released

Hello all, it has been a while since my last post, I have been busy working a few projects that took my attention completely.282962_4217420760459_350721136_n


I have not forgotten about you so here I am bringing good news. Dynamics GP 2010 Service pack is out.

We all have been very excited about this release as it fixes many issues for Analytical Accounting that we were working around. On my favorite topic, eConnect headaches will go away with SOP and PO.


Manufacturing has some improvements as well, so ok I will now provide you with the direct link to download from Microsoft’s website, remember to use your credentials to access this password protected site!!.


Have a great day!!!

Dynamics GP Mashup – Easy to Make Dashboard

I was experimenting the other day to get Management Reporter data and other Dynamics GP data together in one easy to make dashboard. It turned out to be easier than I had thought it might be.

Early in the process I came across some antiquities from Jan Harrigan that pointed me in the right direction regarding Management Reporter. It was easy to adapt her ideas about FRx, to MR:

Executive Reporting: Using Excel Charts with FRx
Graphing with FRx

I easily modified one of my detailed MR reports to just produce the summary information I wanted for my dashboard. And then I print the report and export to Excel. Use the same file name every time. The result is the graph that shows in the upper left part of the dash board.

Next I just added the other graphs I wanted, using refreshable Excel reports from Dynamics GP. I’ve shown this a few times here:

Simple Dashboards Using GL Summaries and Excel Reports for Dynamics GP
Creating a Simple Dashboard Using Excel Reports

Here’s the result:

This is a video showing how to get the Management Reporter information and make it available for use in Excel:

Management Reporter Report Scheduling

The folks over at the Dynamics Corporate Performance Management blog drew my attention to this video about the report scheduling functionality in Management Reporter.

Take a look at this video:

“Report scheduling offers a flexible and secure mechanism for automating the publishing of your financial reports from within Management Reporter. Report schedules are simple to setup and require little maintenance. In your business, Report scheduling can be used to eliminate the repetitive task of generating the same reports every day during the month end.”

MR 2012 Feature Overview – Report Scheduling

Dynamics GP Payroll Processing – A Deceptively Simple Example

The Dynamics GP Payroll module is a complete payroll processing module that allows you to maintain employee payroll information and process periodic payrolls for salary and hourly employees, with benefits and deductions, and tax calculations. We have many clients that run their payroll in Dynamics GP; ranging from 20 employees, to over 2,000.

I am not a payroll expert, so what follows is a quick overview of processing a salary payroll in Dynamics GP, where I deftly avoid the complicated parts and make it look like anybody can run payroll. The fact is that it takes a fair amount of Dynamics GP knowledge and a lot of non-system payroll knowledge to accurately run a successful payroll using Dynamics GP. We process our own payroll on Dynamics GP, but they don’t let me touch it.

These are the three basic steps:

  1. Build Payroll Checks
  2. Calculate Payroll Checks
  3. Print Payroll Checks

These are the reports that print out. The system steps you through the process:

Here is a quick video that goes through the Dynamics GP Payroll Processing process:

Inventory Available to Promise (ATP)

The Inventory Available to Promise screen will give you insight into your current inventory situation for any item. For any item that you select in this screen you will see the supply and demand for the item in a time sorted list. You can drill back into any listed item to get more information.

The definition of Free-forward quantity is the total of available and pending quantities of an item, plus any additional quantities from purchase orders, assembly receipts, manufacturing orders, and sales returns displayed in the scrolling window. The total sum is reduced by the item quantities from unallocated sales orders, sales back orders, and unallocated manufacturing components displayed in the scrolling window.

There is a feature that allows you to forecast when a new specific quantity of the item will be available, and when you could start a manufacturing order to build the quantity, if needed. Here is a good example that shows the various attributes of the calculation, and displays the related transactions:

In this example I wanted to know when a quantity of 200 would be available. I entered 200 in the Required Quantity field, and the results show that there will be at least 200 available on 6/15/2017. By quickly reviewing the list of transaction you can see that the manufacturing order for a quantity of 8o is the limiting factor for this result. If you click on the Calc. Mfg. Date button, a report will run that shows you the items required for the manufacturing order. In this case the manufacturing order is waiting for a supply of Black Ink that will be delivered on 6/12/2017.

The Inventory Available to Promise screen is also accessible directly from the Sales Order Transaction Entry screen by clicking on the blue expansion arrow just to the right of the QTY Ordered field label.

Here is a soon-to-be ancient brochure from Microsoft. GP-Available-To-Promise

Dynamics GP Fixed Assets Depreciation and Reporting

The Dynamics GP Fixed Assets module can easily depreciate assets and send that information to the general ledger. If you want to see what future asset depreciation will be you can run a depreciation projection report.

There are two steps to running the depreciation projection report:

  1. Run the projection routine: Routines >> Fixed Assets >> Projection. Specify the date to which you want to run the projection.
  2. Run the projection report: Reports >> Fixed Assets >> Projection. You can run the report at a summary or detail level, and show either annual or periodic depreciation amounts.

Depreciating the assets is simple. Just navigate to: Routines >> Fixed Assets >> Depreciate. Select the book(s) you want to run the depreciation for, and the “depreciate to” date. If you go back and look at an asset you will see the individual depreciation records created for each period.

Periodically you will want to transfer the Fixed Assets transactions to the general ledger. To do this, run the GL Posting routine: Routines >> Fixed Assets >> GL Posting. I generally specify 0000-000 as the beginning period to ensure that I pick up all transactions in the fixed assets system. You will want to be careful when you specify the Ending Period because this routine will only make one journal entry per run. So if you haven’t run this routine for awhile, you will want to run it separately for each period; starting with the earliest period first.

I have always liked the standard reports in the Fixed Assets module. The reports are basically lists of assets. These are handy to address requirements for financial audits and property tax returns. The Property Ledger is the one I find most useful: Reports >> Fixed Assets >>Inventory >> Property Ledger.

There are also three SmartList objects that are very useful. Each one has dozens of additional fields you can add as desired.

Here is a quick video about Dynamics GP Fixed Assets Depreciation and Reporting:

Subscription Options:
Subscribe via RSS
Articles Categories