Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Is there a way to post ending balances directly using integration manager ?

Posted on by 175

Starting GP in 2012

Wishing to post ending balances only for FY 2009 and FY 2010 and net change for FY 2011.

Wanted to know if it could be done using integration manager

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Is there a way to post ending balances directly using integration manager ?

    Well done Warren,

    I admire your detail!

    Kind regards,

    Leslie

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Is there a way to post ending balances directly using integration manager ?

    Anthoney,

    BE VERY CAREFUL.  

    I am assuming that this is a new company and what you are wanting to do is having 12/31 balances for 2009, 2010, and 2011.  Assume that FY=CY.   I also assume that you are just really wanting this for reports that compare results.  

    If my assumptions are accurate, then here is what I would do.   Does not really matter if you use integration manager or manual entry, the process is the same.

    1) Besure that you have Year 2009, 2010, 2011, and 2012 created.

    2) Enter 12/31/09 ending balances (IM or manual).   Besure date is 12/31/09.

    3) Close 2009.   This will create opening balances for 2010.

    4) Calculate net change for 2010 by account and make entry (IM or Manual).

    5) Close 2010, creates opening balances for 2011

    6) Repeat step 4 &5 for 2011.

    If you did it the way that you propose, then your opening balances for 2012 would be the sum of the ending balance 2009 + ending balance 2010 + net change for 2011.   In other words, overstated.  

    Besure you understand the closing process and the importance of having accounts set correctly to either Balance Sheet or P&L.

    Warren

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Is there a way to post ending balances directly using integration manager ?

    Anthony,

    Sure, just import a big journal entry. Be careful to do them in order and pay attention when you close the year. I'd really need more information, what obstacle did you expect to encounter?

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans