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 Automate | Passing Collections from Power Automate to Power Apps (Revisited)

Image
I revisit an old video I did couple years ago showing how to pass collections from Power Automate to Power Apps.  This time around, I show how to leverage arrays to accomplish the same. This time around you will learn about: Power Apps trigger in Power Automate   Get Rows SQL action   Variables action Select action and Arrays Response action Power Apps Collections To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP
Read more

Why my transactions don't post through GL even when I have the flag selected?

Image
Are you tired of asking why is it that some transactions do post through GL and why some don't? Tired of changing the posting settings to no avail? This issue outta be one of the most confusing issues for users and consultants, new or seasoned alike. If you ever struggle with one issue in GP, please tell me it's this one, because even today, I cannot claim victory over this subject. So let's walk the walk together. What the theory says? According to Part 3, Chapter 13, page 87 of the Microsoft Dynamics GP's System Setup guide, " If you mark the Post Through General Ledger Files option, batches posted in other modules automatically will update the module in which the transactions originated and the appropriate posting accounts in General Ledger. Your transactions will post to General Ledger and not through General Ledger when posting transaction individually (without a batch). " Now lets break it down... It's important to really pay close attention to the t...
Read more

A .NET Framework error occurred during the execution of user-defined routine or aggregate "GetAssignedUsers"

Image
So, I found myself helping a client to troubleshoot a workflow issue. After configuring workflow a few weeks aback and running a few tests without any issues, we applied Microsoft Dynamics GP 2015 R2 January 2016 Hotfix. Now, when the client went to execute the workflow, he received the corresponding email indicating there was a purchase order to approve. He then proceeded to click the Approve hyperlink and the process continued as expected. After clicking the Approve button, the client receive the following error message: The server encountered an error processing the request. See server logs for more details The following shows the error as displayed on the client's screen. At this point, it is worth stating that the workflow ran to completion and the PO appeared completely approved and fine in Dynamics GP, so whatever was causing this error did not seem to interrupt the approval flow. As good troubleshooters, we went to the Event Viewer to check for addi...
Read more