Disabling Multiple Ledgers functionality in Microsoft Dynamics GP 2010...after the fact

Let's face it! Like many things in life, configuration decisions are revisited even after going live (rightfully so!) with your system. What was viewed and considered a requirement a few months aback and worked during User Acceptance Testing turns out to be something the business no longer needs today, due to changes in direction, or changes in business conditions.

Just recently, I came across a request for disabling the new reporting ledgers functionality in Microsoft Dynamics GP 2010. While this implementation was not live, this issue was clearly affecting the consulting teams ability to move forward.

The following script should disable the reporting ledgers function:

-- Created by Mariano Gomez, MVP
-- This code is licensed under the Creative Commons 
-- Attribution-NonCommercial-ShareAlike 2.5 Generic license.

UPDATE GL40000 SET Allow_Reporting_Ledgers = 0, UseLedgersForAcctBalance = 0;
DELETE FROM GL40001;

Once the script is executed, go back to the General Ledger Setup window. You will notice that a BASE ledger is created by default, but also notice that the Allow flag is unchecked.


General Ledger Setup
Click the Ok button to continue.

Now, if you open the GL Transaction Entry screen, you will notice that the Ledger ID field is no longer present.

Transaction Entry
Hope you found this post useful.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

Comments

Jivtesh Singh said…
Mariano,

Wanted to turn off Ledgers in the test environment today, and searched KB/PS, but didnt find anything. As usual you were there to save the day!

Thanks
March 5, 2012 at 9:42 PM
Anonymous said…
Mariano, I used your script to disable the reporting ledger and now the when using the Finanial-Summary and History Summary inquiries no results are returned. If I access the summary and history windows from the Account Maintenance window the summary and history summary do return results. Any ideas what would cause this? Thank you, Scott
December 15, 2012 at 10:58 AM
Post a Comment

Popular posts from this blog

Power Apps - Application Monitoring with Azure Application Insights

Image
In this video, learn to enable Power Apps Application Monitoring with Azure Application Insights.  The following topics are covered in this video:  ( 0:00 ) - Intro  ( 0:36 ) - What is Azure Application Insights  ( 1:32 ) - The timesheet app  ( 2:12 ) - Creating an Application Insight for the timesheet application  ( 3:55 ) - Identify and copy the application instrumentation key  ( 4:09 ) - Enabling the timesheet application with the instrumentation key  ( 5:32 ) - Working with Application Insights  ( 8:06 ) - Outro For additional information on Azure Application Insights, please follow these resources: Microsoft Docs - What is Azure Application Insights? here Adam Marczak - Azure for Everyone: Azure Application Insights Tutorial, here To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP
Read more

#MSDYNGP: Named Printers and Redirected Printers in RDP environments

Image
A lot of the guiding principles for deploying Named Printers in a Terminal Server or Citrix environment comes from two of my favorite articles, written by my good friend and fellow Microsoft Business Applications MVP, David Musgrave  (twitter: @winthropdc ). David happens to be the creator of Named Printers and probably understands the product better than anyone I know. You can read his articles here: Using Named Printers with Terminal Server Using Named Printers with Terminal Server Revisited These articles continue to be very relevant if you are in an environment where a Print (or Printer) server is the norm and published printers are standard. Print servers are used to interface printers with devices in a network, but mostly to standardize administrative policies, and balance the document load that printers can manage. Part of the standardization is to ensure printers are uniquely identified across the networks, regardless of whether you are accessing the network remotely or ph
Read more

Integration Manager 10 INI settings

Image
The Integration Manager parameter file, Microsoft.Dynamics.GP.IntegrationManager.ini , provides a few keys that allow the application to perform certain actions according to the values and the sections in which these parameters are initialize . Here is a list of keys for the initialization file per section within the file: IMBaseProvider section This section controls the overall behavior of the Integration Manager application. AutoUpgradeIntegrations= 0/1 Prompts IM to check whether to upgrade an integration or not. CommandTimeout=30 Time allotted to execute a particular IM operation. If the operation is not successful in the time alloted, the record integration will fail. HideMsgBox= False/True Hides IM registration window during the application launch. UseOptimizedFiltering= False/True Allows you to maintain the same sorting as the original source. One note that I would make is that the following switch was put in more for performance. If you notice that your data is not coming in th
Read more