Unmarking Maintain General Ledger Account History In Multicurrency Setup when not registered for Multicurrency


TechKnowledge Content


Question:

I am trying to unmark the Maintain History options in the General Ledger Setup window (Setup-Financial-General Ledger), but when I do so I receive a message "You must keep General Ledger account history because multicurrency account history is being maintained." How do I unmark the maintain multicurrency history option when I am not registered for Multicurrency and cannot open the Multicurrency Setup window (Setup-Financial-Multicurrency)?

Answer:

A General Ledger year has been closed, but some accounts were posted with the wrong posting type. Adjusting entries need to be made to correct the balances. Maintain General Ledger account history in the Multicurrency Setup Window (Setup-Financial-Mulitcurrency) also needs to be unmarked.

However, an attempt to access the Multicurrency Setup window produces the error that You are not privileged to open this form because Multicurrency is not registered. What should be done if no MC registration keys are available? Use ISQL to update the Multicurrency setup table (MC40000).

Execute the following statement in Query Analyzer against the company's database.

update MC40000 set MNSUMHST = 0

This will change the value of the checkbox from marked to unmarked. After unmarking this, the user will be able to unmark maintain account and transaction history in the General Ledger Setup window.



This article was TechKnowledge Document ID: 1588

DISCLAIMER 

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.