Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Ending Balance of 2014 is reporting incorrect value

Posted on by 22,647

Client comment

Client had some kind of issues when opening the year 2015. The fiscal year shows 2015 while the period date still shows 01/01/2014, 02/01/2014 and so on.  <client name> fixed the problem by manually change the period date to 01/01/2015, 02/01/2015.  <client name> is not sure if this causes the issue. 

This is the posed problem

2014 opening $78177.26, net change in 2014 -78000.00, ending of 2014 $177.26. However, now in GP after the year-end closing, the 2014 opening changed to 177.26 (which s/b the ending) , net change in 2014 is still -78000.00 and the ending changed to  -77822.74 (which is completely wrong).

Question

Would a simple Reconcile of the Fiscal years correct this problem.  I read the issue thus:

1. the client created the 2015 Fiscal year and it generated dates for the 2014 Calendar year rather than 2015 Calendar year.

2. the client did not note this originally and completed the year end.

3. the client found the error in the fiscal period dates and simply typed over the dates to create new fiscal buckets.

 

My question - will reconcile work?  or will we have to dig in with PSTL and repair the fiscal periods?

*This post is locked for comments

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Ending Balance of 2014 is reporting incorrect value

    Go to know this posting was of assistance.  It proves the value of the community posting system.  As users gain experiences >> have issues to share >> this site gets much better for all users.

    Keep posting. . . .

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Ending Balance of 2014 is reporting incorrect value

    Bill, interesting you had this issue because I have now encountered this twice.  Both of my clients are on GP2013R2 and the first time I thought the client just did something wrong but now that it has happened a second time I am wondering what is going on with the software.

    This last time the client closed the Fiscal Year 2013.  In Fiscal Periods the year was showing 2015 but the start date was 01/01/2014 and the end date was 12/31/14 and the year 2014 no longer existed.  My first client had the same thing happen but was in a bigger mess because they processed transactions in a sub-ledger and posted which compounded the problem and was a mess to clean up.

    I just want to post this in case other are seeing this same situation.  On the last client, I just changed the Fiscal start and end dates for 2015, created 2014, ran CheckLinks on the Financial tables and reconciled 2014 then 2015 and all is now working correctly

  • RE: Ending Balance of 2014 is reporting incorrect value

    Good to know your problem resolved Bill.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Ending Balance of 2014 is reporting incorrect value

    Babu, thanks for pointing me to PSTL for GP10.

    This was the problem and once I rebuilt the GL00105 and recreated all the Fiscal Periods all my problems went away.

    Thanks again for assistance.

  • Verified answer
    RE: Ending Balance of 2014 is reporting incorrect value

    Hi Bill,

    PSTL is there for GP 10 correct if I am wrong.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Ending Balance of 2014 is reporting incorrect value

    Client on GP 10 = does not want to update = no PSTL

    Second suggestion?

  • Suggested answer
    RE: Ending Balance of 2014 is reporting incorrect value

    Hi Bill,

    I think the reconcile wont help on this, its better to fix all the fiscal year using PSTL then do the reconcile.  You might also wanted to run checklink against Company-Period Setup to make sure everything is okay.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans