Wednesday, February 20, 2013

Dynamics GP Microsoft Extender and eOne Extender Enterprise

First of all, the extender that is installed from the add/remove programs for GP is Microsoft Extender.
eOne has another version called Extender Enterprise. It has more features than Microsoft Extender.

Even if you are using GP 10, install the Extender Enterprise for GP 2010.

The most updated version can be found here

If you have already installed the Microsoft Extender, and need to upgrade to the eOne Enterprise Extender, follow the instructions here

If you are unable to login to your company because extender can't find certain tables, or you are getting an error saying some tables are the wrong version, follow these instructions to ensure you have completed the install correctly

Before doing any of this, you should backup or export your extender customizations/data. You may or may not be able to import them in, so be prepared to rebuild them if you have to.
  • Rename the EXTUD.dic to EXTUD.old in your Program Files\Microsoft dynamics\GP\ folder
  • Run the latest Extender Enterprise install (ExtenderEnterprise11.msi) and point it to your GP folder
  • It will extract the Extender chunk file to that location
  • Run GP, it will prompt to add new code, do so, ignore all errors
  • It should then prompt you to create all tables, say yes
  • Once it's finished, Restart GP
  • If you get any errors, go to GP>Maintenance>SQL
  • Select the old company database that is giving trouble
  • Select the Extender product
  • Select all tables
  • Tick "drop tables", "create tables", "drop auto procedure" and "create auto procedure"
    • This will wipe out ALL Extender customizations for the company, and ALL data in the extender fields. Make sure you backup whatever you need first.
  • Process
  • This will reset all of the tables in that company to the current version of extender that is installed

Tuesday, February 19, 2013

How to download your Microsoft Certifications

If you have done any Microsoft exams, you are a Microsoft Certified Professional.

Login to the website here

Navigate to My Credentials>Transcript>View or Download Transcript

Thursday, February 7, 2013

Dynamics GP - Outstanding AR transactions

This view can be used as the basis for an AR Trial Balance

Wednesday, February 6, 2013

Crystal Reports - Parameter Dynamics List does not show all values

This is a bug with Crystal itself.

To rectify this, and have Crystal display all parameter values,

  1. Click Start, Run 
    1. If run is not enabled, right click on start>properties>start menu>customize>scroll to the bottom>tick Run Command
  2. Type in "regedit"
  3. Expand HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\
    1. The "Suite 11.0" folder will be different depending on your version of Crystal
  4. Right click on Crystal Reports> New>Key> Type in "DatabaseOptions"
  5. Right click on DatabaseOptions> New>Key> Type in "LOV"
  6. Select LOV
  7. On the right hand side of the window in the white area, right click>New>String Value>Type in "MaxRowsetRecords"
  8. Double-click MaxRowsetRecords
  9. Type in -1 (-1 displays all available records)
  10. Restart Crystal
The final key that you should have added is: 
(For V11)
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords (String) Set to -1

(For V12)
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords (String) Set to -1

If this does not work, ensure that you have entered the names EXACT with no spaces.
This will work. If it does not, you have a typo somewhere.