Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Create Automate Journa...
Microsoft Dynamics GP (Archived)

Create Automate Journal from account RollUP

(0) ShareShare
ReportReport
Posted on by Joni J 425

Hi all,

lately i'v just found that we can create reverse journal by creating correction journal (Backedout Journal).

one of steps on my closing process is i have to create reverse journal based on account rollup (per month) - (CMIIW)

after redisplay certain segment on account rollup menu, it will display several or more account with certain ammount

just like this :


the question is, does GP can create automatic journal, to reverse those data ? the logic is , if balance is + (positive-debit) amount, then create those account on reverse side (negative-credit) against some Journal Allocation template (which is already created), and viceversa.

thank you for your help & sharing :)

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Create Automate Journal from account RollUP

    Joni,

    I really think the clearing entry might be able to help. Can you send me some examples of what you do and I can better evaluate whether this would be a good answer.

    Call me at 972-814-8550 (US Central Time), or email me at leslievail@earthlink.net

    Kind regards,

    Leslie

  • Joni J Profile Picture
    Joni J 425 on at
    RE: Create Automate Journal from account RollUP

    Hi Leslie,

    thank you for your answer,

    hmmm, i'm afraid i'm not expert to tell the true issue :D, sorry for that,

    well , i just know that in my company, account rollup was checked every end of month to get expense amount to be  allocated to each journal template (Quick Journal) based on Fix Allocation that already saved before.

    After found the account and amount from account rollup, I have to go back to Quick Journal to put each amount to each account one by one. it really takes time and risky, cause not all of account on quick journal template need to filled with the amount from account roll-up.

    that's why, i just wondering,is there any  tools or menu to create journal based on account rollup automatically.

    Best Regards

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Create Automate Journal from account RollUP

    Hi Joni,

    I'm not sure I understand correctly, but I'll give it a shot. GP has something called a Clearing entry - that you can put in a recurring batch. What the clearing entry can do is transfer the balance (either YTD or Trx period) from one account to another. The beauty of a clearing entry is that you do not need to know the amount. Based on your selection, YTD or Trx Period, the system will automatically pull the correct amount.

    Am I getting close?

    Kind regards,

    leslie

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,317 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans