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 |
Now, if you open the GL Transaction Entry screen, you will notice that the Ledger ID field is no longer present.
![]() |
Transaction Entry |
Until next post!
MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
2 comments:
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
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
Post a Comment