web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Many to One Clearing A...
Microsoft Dynamics GP (Archived)

Many to One Clearing Accounts

(0) ShareShare
ReportReport
Posted on by Prakash P 800

Hello,

We have a scenario that at the end of each month we have to clear more than 20 GL accounts to a single offset/clearing account.

We know it is possible to create a clearing entry with one to one or one to many (with the help of Allocation accounts)  but our scenario is many GL account to one clearing account.

I'm planning to create a quick journal entry but I would like to know if there are any other better way to handle this scenario in GP.

Please advise...

Thanks

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Prakash P Profile Picture
    Prakash P 800 on at
    RE: Many to One Clearing Accounts

    Thank you all for your replies. It seems there is no direct option and we are fine with Quick Journal Entry as I said before.

    Hope MSFT will consider this feature in the next release.

  • Verified answer
    Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at
    RE: Many to One Clearing Accounts

    Hi

    There is not a quick option that I am aware of.

    Quick journal, standard journal, journal paste (by the way, a version of the free option Babu suggested has been incorporated into GP 2013 R2 onwards and all my clients LOVE it), use FRx / Management Reporter (know FRx could do it - assume MR can too) to export to an excel file the account balances and use Integration Manager to reimport (or journal paste).

    Nothing automated though that I know of.

    Cheers

    Heather

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    RE: Many to One Clearing Accounts

    Hi Prakash,

    I think recurring batch within GP will be meet your requirement.  Please click  here have a look at the same.

     

  • Prakash P Profile Picture
    Prakash P 800 on at
    RE: Many to One Clearing Accounts

    Thank you for your reply, Babu. I would like to know any options available within GP.

  • Verified answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    RE: Many to One Clearing Accounts

    Hi Prakash,

    you can create a template in excel and using excel paste copy and paste it to GL entry.  You can use free excel paste from Dynamics Innovations.

    GP Excel paste

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans