Dynamics GP

GP 2013 and 2015 GP Web Services "Exception message: The security object does not exist"

After moving the GPWEBSECURITY database for GP Web Services and running a repair we received the following error opening the Security Console:"Exception message: The security object does not exist. Missing Key: 25cc1a21-2cc4-4b13-a1c8-eea186fb688a"Turns out we ran the wrong repair.  DO NOT run the repair from the GP Web Services Configuration Console.  Instead, launch the GP Setup.exe from the GP installation media.  This will detect the existing install and give you the option to repair.I used information from the following link and updated it for the new web services that does not run in IIS:https://support.microsoft.com/en-us/kb/943949To determine the scopes in the ADAM database, use the Authorization Manager (Azman.msc) Microsoft Management Console (MMC) snap-in to browse the database. To do this, follow these steps:Click Start, click Run, type azman.msc, and then click OK.On the Action menu, click Open Authorization Store.Click Active Directory.In Windows Explorer, open the following folder:C:Program FilesMicrosoft DynamicsGPWebServicesWebServicesUse Notepad to open the [...]

By | 2018-07-18T11:23:45+00:00 March 24th, 2015|Dynamics GP|

SSRS Report Builder "Application cannot be started, contact application vendor."

When trying to launch Report Builder you receive the error "Application cannot be started, contact application vendor." I did two things that seemed to of helpled. 1. Open SSMS and connect Server type "Reporting Services", Server name. Right Click the Server Name in Object Explorer and pick Properties. Under Advanced setting in the Reports section set the ReportBuilderLaunchURL to https://serverurl/ReportServer/Report/BuilderReportBuilder_3_0_0_0.appli.... 2. Create a Web.config file in the C:Program FilesMicrosoft SQL ServerMSRS11.instancenameReporting ServicesReportServerReportBuilder folder containing the following <?xml version="1.0" encoding="utf-8"?> <configuration> <compilation tempDirectory="C:Program FilesMicrosoft SQL ServerMSRS11.instancenameReporting ServicesRSTempFiles"/> </system.web> </configuration>

By | 2018-07-18T11:23:45+00:00 January 27th, 2015|Dynamics GP|

Management Reporter 2012 on GP 2015 Couldn't retrieve the list of available databases: The connection attempt failed.

While trying to configure Management Reporter 2012 on a brand new install of GP 2015 I received the following error: "Couldn't retrieve the list of available databases: The connection attempt failed." Configuration is SQL 2012 on Server 2012 R2, GP 2015 on Server 2012 R2. Solution: Install Dexterity Shared Components 12 from the install disc for GP2013 R2. I found the answer here: https://community.dynamics.com/gp/f/32/t/146554.aspx Thank you to Richard Markham.

By | 2018-07-18T11:23:45+00:00 December 19th, 2014|Dynamics GP|

Grant Permissions for Manufacturing SmartLists

When using Manufacturing in Microsoft Dynamics GP (both GP 2010 and GP 2013), people not assigned to the POWERUSER role are unable to see Manufacturing SmartLists by default - even users who are assigned MFG ADMIN and MFG_INQUIRY roles. To grant permissions for these, you need to include them with a task. You can assign the permissions to whichever task you choose. I choose to assign different SmartLists to their matching inquiry task (INQ_MFG_XXX), in case custom roles are added for which there should be limited manufacturing permissions. To add SmartLists to a Security Task: 1. Open the Security Task Setup window (Administration >> Setup >> Security >> Security Tasks) 2. Choose the Task ID for which you would like to add SmartList permissions 3. Select Product: Smartlist, Type: SmartList Object, Series: SmartList Objects 4. Check the boxes next to the SmartLists you would like to include 5. Click Save [...]

By | 2018-07-18T11:23:45+00:00 June 30th, 2014|Dynamics GP|

GP Manufacturing Accounting Flow: Component Transactions and MO Receipts

In GP Manufacturing, the accounting flow for inventory transactions involved in a Manufacturing Order can be tricky, because they don't all follow the same logic. Below is a summary of the accounting flow for some of the basic inventory transactions that take place during the Manufacturing process.Component Transaction Entry (Issue) Issues raw materials to production/WIP: -- Credits (decreases) the Inventory account -- Debits (increases) the WIP account To determine which inventory account to use, GP checks the Inventory account assigned to the Raw Material item. -- If this is present, it will use the account -- If it is blank, it will use the default posting inventory account To determine which WIP account to use, GP checks the WIP account assigned to the Finished Good item that is being produced: -- If the WIP account is present, it will use that account -- If the WIP account is left blank, it will [...]

By | 2018-07-18T11:23:45+00:00 June 17th, 2014|Dynamics GP|

GP 2013 Crash on Navigation Lists

Some of our clients have been experiencing a Dynamics GP application crash when selecting a Navigation List. Problem signature: Problem Event Name: CLR20r3 Problem Signature 01: Dynamics.exe Problem Signature 02: 12.0.270.0 Problem Signature 03: 5217d52e Problem Signature 04: WindowsBase Problem Signature 05: 4.0.30319.34004 Problem Signature 06: 5246811c Problem Signature 07: 1432 Problem Signature 08: 17 Problem Signature 09: System.InvalidOperationException OS Version: 6.3.9600.2.0.0.16.7 Locale ID: 1033 Additional Information 1: 5861 Additional Information 2: 5861822e1919d7c014bbb064c64908b2 Additional Information 3: d1d9 Additional Information 4: d1d94a13d3609d6b740644c12508f581 I found this post from Donna Krizik that solved the problem: http://www.crestwood.com/blog/view/dynamics-gp-2013-crashes-every-time-y... Quick fix: The Business Analyzer Fact Box was the culprit. I used the following script to turn it off and make sure it stayed turned off. Use Dynamics go update DYNAMICS..SY07225 set FactBoxVisible = 0 go CREATE TRIGGER dbo.Update_SY07225_FactBoxVisible ON dbo.SY07225 AFTER INSERT AS Update SY07225 SET FactBoxVisible = 0 go

By | 2018-07-18T11:23:45+00:00 June 11th, 2014|Dynamics GP|

Error logging in to GP2013 "An error occurred while loading or initializing an addin."

Working with GP2013, I encountered this error logging in: "An error occurred while loading or initializing an addin. Ask your administrator to check the Windows event log for more details. Dynamics will now close." Checking the Event Viewer provided a bit more information: "Microsoft Dexterity error: The description for Event ID 0 from source Microsoft Dexterity cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: An exception occurred while trying to load or initialize the addin located at VAT100ElectronicSubmission. Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'VAT100ElectronicSubmission, Version=12.0.0.0, Culture=neutral, PublicKeyToken=5eca28f6788f0a91' or one of its dependencies. The system cannot find [...]

By | 2018-07-18T11:23:45+00:00 May 21st, 2014|Dynamics GP|

Microsoft Dynamics GP is Slow on Startup

If GP seems unusually slow when starting up, it may be caused by reminders you have set. Upon startup, GP searches through the data for each reminder. Therefore if you have several reminders set on your Home screen, and/or if your reminders comb through a large amount of data, it can slow down GP's startup significantly. A couple of signs that reminders may be the cause: - It takes you much longer to log into GP than it does your coworkers logging into the same database. - GP seems to be the only program experiencing the slowdown - other programs do not take as long to start up. To test this, remove the reminders from your GP Home screen and restart. (You can find step-by-step directions on how to remove GP reminders at http://njevity.com/blog/how-remove-reminders-gp-dynamics.) If the reminders are the problem, you will notice a significant improvement in startup time.

By | 2018-07-18T11:23:46+00:00 April 29th, 2014|Dynamics GP|

How to Remove Reminders in Microsoft Dynamics GP

Reminders can sometimes slow down the performance of Microsoft GP Dynamics.Below are step-by-step instructions for removing your reminders from GP. (This will remove reminders only for your login, it will not affect reminders others may have set.)Go to Microsoft Dynamics GP >> Reminders                 Click "Change Reminder Preferences".  Uncheck Predefined Reminders and remove Custom Reminders that you do not wish to see.  Click OK.This should remove all selected reminders - if you leave the Home screen, and then go back to it, any reminders that you removed should no longer be there.

By | 2018-07-18T11:23:46+00:00 April 28th, 2014|Dynamics GP|

Error: The deployment has exceeded the maximum request length

While deploying reports to SQL Report Services you receive the error: "The deployment has exceeded the maximum request length allowed by the target server. Set the maxRequestLength= "20690" in the web.config file and try deploying again. This happen a lot because we forget to make a simple change. 1. On the SQL Reporting Server open the folder that SSRS is installed to. This is something like C:Program FilesMicrosoft SQL ServerMSRS10. The MSRS folders is what you are looking for. 2. Go to the Reporting ServicesReportServer sub directory. 3. Make a backup copy of the web.config file. 4. Open the original web.config file. 5. Find the line: <httpRuntime executionTimeout="9000" /> 6. Replace with: <httpRuntime executionTimeout="9000" maxRequestLength="30000" /> 7. Save the file. 8. Restart SQL Reporting Services. 9. Redeploy the reports.

By | 2018-07-18T11:23:46+00:00 April 25th, 2014|Dynamics GP|