Finance | Project Operations, Human Resources, ...

Accounts History not Appear in Inquiry and Reports after closing

(0) Share

Report

Posted on by MSOBKY

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

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Jeff Grant on at

Like (0)

Report

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

Was this reply helpful? Yes No
MSOBKY 84 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Lisa at AonC.com 921 Super User 2025 Season 2 on at

Like (0)

Report

Confirm you have the Maintain History checkboxes marked at Microsoft Dynamics GP > Tools > Setup > Financial > General Ledger.

Was this reply helpful? Yes No
Jeff Grant on at

Like (0)

Report

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

Was this reply helpful? Yes No