SBX - Search With Button

SBX - Forum Post Title

gl detail does not agree with accthist. how do I find out why or what happened?

Microsoft Dynamics SL Forum

Barbara Klassner asked a question on 20 Jan 2011 2:14 PM

Question Status

Suggested Answer
Period 12-10 Total 70,857.36 350,726.94 357,725.07 63,859.23 **
Sub 000UGL Total 70,857.36 350,726.94 357,725.07 63,859.23
Acct 1114 Total 70,857.36 599,576.94 603,326.07 67,108.23
Total Assets 70,857.36 599,576.94 603,326.07 67,108.23
^    Indicates the period entered is different from the period posted.
*    Indicates there are no GL transactions to support summarized AcctHist period activity.
**   Indicates the calculated period ending balance does not match the YTD balance on AcctHist.
***  Indicates the calculated account balance does not match the account balance on AcctHist.
#    Indicates Assets do not match Liabilities or Net Income does not equal the YTD Net Income account.

WHAT DOES THE HIGHLIGHTED STATEMENT MEAN AND HOW DO I FIX IT???

Any help is appreciated!!

Barbara

Reply
BGredell responded on 21 Jan 2011 11:12 AM
Suggested Answer

It means that the system calculated balance is not tying to the GL YTD balance. Several things can cause this including: incorrectly entering prior balance information, someone manually changing it in the Account History or someone accidently deleting a GL batch in SQL. In the past I had to go into Account History and force it to match. Prior to doing so you need to figure out which balance is correct. Also you may need to fix it again for periods after the adjusted period depending on the root cause.

Reply
GArn750 responded on 2 Jul 2015 8:02 AM

*    Indicates there are no GL transactions to support summarized AcctHist period activity.

I have this problem, how do I fix this?

Reply
GregzTech responded on 2 Nov 2018 9:36 AM

I am having this issue as well, was there a solution for it?

*    Indicates there are no GL transactions to support summarized AcctHist period activity.

Reply
BGredell responded on 21 Jan 2011 11:12 AM
Suggested Answer

It means that the system calculated balance is not tying to the GL YTD balance. Several things can cause this including: incorrectly entering prior balance information, someone manually changing it in the Account History or someone accidently deleting a GL batch in SQL. In the past I had to go into Account History and force it to match. Prior to doing so you need to figure out which balance is correct. Also you may need to fix it again for periods after the adjusted period depending on the root cause.

Reply

SBX - Two Col Forum

SBX - Migrated JS