Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Remove Balance from Account

(0) ShareShare
ReportReport
Posted on by

Client had an account originally set up as Balance Sheet - in FY 2019 they had transactions, year closed - error not noted ( not sure how it was missed ), no activity in FY2020 - year closed and no notice of error - no activity in FY2021 ( Feb 1, 2020 to Jan 31, 2021) - year closed - and Retained earnings is noted to be out of balance - by the amount in the account.

Seems that somewhere along the way someone corrected the account and it now appears as P/L ( correct ) but it still has an opening balance.

So I believe the change to the P/L was done after the last year close.

To fix

(1) reset account back to Balance Sheet

(2) restore from Year End Close - GL magic button

(3) change the status of the account to P/L

(4) close the year - again

I am pretty sure that this is correct - my question has to do with all the changes, JE and such that the client has done since they closed the Year - they would have done correcting transactions into the closed year - they have done a ton of work since end of February - What will happen to all that work if we reopen the year - make our correction and the close the year?

Second question - what does this look like when you look into the detail transactions for the GL - the concern is that the external auditors may have a fit if there are whole sale changes and a ton of reversing and re-reversing transactions.  Or is this not the case?

Thanks in advance for your assistance.

Categories:
  • Suggested answer
    agaber Profile Picture
    agaber on at
    RE: Remove Balance from Account

    Hi Bill-

    Thank you for the response.  I understand they have already made a correcting entry, but you should re-open the year again, and change the erring account to P&L.  Then back out whatever "correcting entry" they had done, and reclose the year to update Retained Earnings correctly.  Just keep in mind that one sided journal entries would not be supported a method, but if you need an example of how it has been done, check out this link below.

    dyngroup.blogspot.com/.../the-beginning-balance-one-sided-entry.html  

    I hope this information is helpful.  Have a great day!

    Adam G.

    Microsoft Dynamics GP

  • RE: Remove Balance from Account

    Ok, I need to restart this conversation.

    The client has done what we discussed, however made an error in doing so and left one of the accounts in the wrong Typical Balance when they did the reverse year end and corrections - missed one account.

    They somehow missed this one account.

    Now we have a P/L account that has a beginning balance - wrong

    We do not want to see any updates to the Retained Earnings as the client made the correcting entry with the 'mass work' done back in March.

    So now I have to do a journal entry to remove the Opening Balance in basically a one sided journal entry.  My challenge is I need assistance in the one side JE - have not had to do one in a number (huge) of years.

    Anyone point me in the right direction please and thanks in advance.

  • Suggested answer
    Jeff Grant Profile Picture
    Jeff Grant on at
    RE: Remove Balance from Account

    Hi Bill,

    I agree your solution was the way to go.  Generally, if you have an incorrect posting setting you would just need to to is re-open the year, flip the account type and reclose the year as the data will be same in the backend, it is just pushed between GL Open (GL20000) and GL History (GL30000) tables in the process.  What will change is the DEX_ROW_TS time stamp field, which will reflect the date of the re-closing process on the moved transactions, but all data will essentially be the same other than the RE amount.  As for the correction entries prior, it would be up to the user discretion if they want to void them out (once the year is in open status), remove them with SQL or just create a new entry to back them out at the current date with explanation intact in the reference field as far as the purpose of the adjustment.

    Best Regards,

    Jeff Grant

    Microsoft Dynamics GP Support

  • Suggested answer
    RE: Remove Balance from Account

    Well we were able to convince the client the the second best solution to her problem was to do a Prior Period Adjustment - so in the end a simple post to Retained Earning and the expense account and all is sorted.

    Thanks for the consideration to this matter.

  • RE: Remove Balance from Account

    Question to Community

    If we Reverse the currently closed year - and then Re-Close the year with the correction to the account type - will there be double the number of transactions appearing in the Detail Trial Balance -  This client is somewhat sensitive to the Auditor seeing them correct errors in the system.  ( not sure why )

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans