You’re offline. This is a read only version of the page.
80
Dear All,
when we conduct closing year for the customer working in GP 10 all accounts not have any History through the historical details inquiry, smart list or reports
only we have totals in historical inquiry and when we try to get any details or any information about the journal entries the system displayed blank screen
although the historical information were displayed normally on previous years
also please note that the year we mentioned is 2015 as the customer not conducting any closing process during that years
Hello M,
The results of the outlined SQL queries should outline some options.
For instance, if the 'count' of data for '2015' is zero in the GL30000 table it tells you the data is completely missing and there isn't a method to recover it from the same database as the table is the transaction detail table for history. However, If the count is similar to other years you may just need to run the Tools | Utilities | Financial | Reconcile process to recreate summary information for the prior year(s) based on the transaction detail, which may repopulate the reporting in question if it is based upon the historical summary amounts.
Also, if the count is zero but you have a backup where the 'count' is present for the prior year(s) you would have the possible option of using SQL/DTS to 'push' the missing data from the TEST db into LIVE to recover the missing data at your discretion.
Best Regards,
Jeff
Confirm you have the Maintain History checkboxes marked at Microsoft Dynamics GP > Tools > Setup > Financial > General Ledger.
Hi Jeff,
thanks for your reply and sure we get backup before we conduct anything and now we have test environment to conduct closing with several scenarios with and without the checklinks and reconcile and already we compare the open and historical
but the main issues now as followings:
1- why the historical not displayed although it's already works normal in previous years of 2015
2-how to solve that issue and system re-display the historical
thanks
M Sobky
Hello,
If the end user has a backup available that was made before the last YEC event I recommend restoring it into a TEST company on the same SQL instance so you can use SQL to compare table content:
select OPENYEAR, count(*) from GL20000 -- GL Open Transactions
group by OPENYEAR
select HSTYEAR, count(*) from GL30000 -- GL History Transactions
group by HSTYEAR
The SQL scripting should list the amount of transactions present per year and will give you a better idea if you have actually lost system data at some point.
Please note that if data has been lost during the YEC process the only supported option we would have would be to restore from the backup made prior to when the failed YEC activity took place.
Best Regards,
Jeff
Dynamics GP Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (