Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Create Journal Entry per transaction or batch

Posted on by 920

there is option to create a journal entry per transaction or batch on the posting setup window, what is the best option to choos?

thanks

*This post is locked for comments

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Create Journal Entry per transaction or batch

    A little further thinking on this - posting to GL in summary rather than detail for Control accounts would render the Reconcile to GL Utility practically useless.

  • Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Create Journal Entry per transaction or batch

    The JRNENTRY would be the same for all of the lines on the journal so should be easy enough to extract in future.

  • Verified answer
    Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Create Journal Entry per transaction or batch

    Hi

    Richard - your note prompted me to put an opinion on consolidating the AP control.  I just recently set up GP for a new client transitioning from a different accounting system.  In their old system they posted to the GL in exactly that manner - detail for the expense but summarised for their control account.  They wanted to bring transaction data over for a period of time - this proved to be a huge issue.

    You couldn't get a balanced "journal" that related to a single transaction - I ended up doing all sorts of pivot tables to try and "create" a transaction with an offset to a clearing account.

    So not saying it is wrong, but just a word of warning - if they ever decide to change system and want to move transactional details, it could be more difficult.

    In overall answer to the query - I am 100% for detail posting for all but payroll.

    Cheers

    Heather

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Create Journal Entry per transaction or batch

    Just to drop thought on this is that I have seen folks post in summary to their accounts payable account. This way if they process thousands of transactions per month, they see only the detail for the expense accounts and only a summary figure for accounts payable.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Create Journal Entry per transaction or batch

    I totally agree, I do believe that the best practice in order for your module to be tied to the general ledger is to post a journal entry per transaction.

    I have never seen a client considering a journal entry per batch for the financials or any of the supply chain modules.

    Your feedback is highly appreciated,

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Create Journal Entry per transaction or batch

    I'm on board with Frank Hamelly

  • Suggested answer
    RE: Create Journal Entry per transaction or batch

    Yes I agree with Frank JE per transaction will be a good practice and it will have clear visibility over your transactions where batch journals difficult to track.  It will be also helpful on any kind of reconciliation.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Create Journal Entry per transaction or batch

    It depends on the transaction type.  Most clients choose a JE per transaction so you can see the detail in the general ledger, except for payroll entries, where you don't want salary details in the GL.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans