Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Post Financial Year End Close Errors

Posted on by Microsoft Employee

Our year end was 31st March 2016 this is only my second full financial year with GP2013. I closed the financial year 18th May having reconciled all the ledgers posting went fine, checked the balances into the new year all ok reports printed, checked balances carried forward into 2017 all ok straight forward. I have the auditors coming on the 1st June and today I thought I would print off the Stock Ledgers, Purchase ledgers as at year end in preparation. What I have now found is that the inventory and creditors no longer balance with the financial ledger.

To take the inventory for example reconciled stock close was 274,321 now in Financial Transactions at year end it is 308,662 when I run a stock ledger trial balance as at 31st March it is still 274,321. When I run a financial year end trial balance stock is still 274,321

 I suspect someone has managed to post a batch of purchase invoices as April 2015 instead of April 2016 as all my period end balances have changed for stock and creditors from April 2015 by 34,341 (308,662 - 274,321) even though the periods were marked as closed. I have spent a full day searching for the transactions that might have caused these differences without any results.

Does any one have any ideas for tracing transactions in all ledgers from the time I did the year end close to trace what has impacted the previous years balances.

Any help appreciated I have a reputation of clear concise and accurate accounts over many years with our auditors !

Kind Regards

Rozt

*This post is locked for comments

  • RogerRogerATX Profile Picture
    RogerRogerATX 1,515 on at
    RE: Post Financial Year End Close Errors

    1) Do you have multiple BBF entries in the GL20000 tables?

    2) Look at the DEX_ROW_TS entry for your BBF entry.  Then look for anything posted after that date (look at the DEX_ROW_TS ) in the GL30000 tables.  That will show you anything that was posted to a prior year after you ran YE Close

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans