web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Create Journal Entry per transaction or batch

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,633 Moderator on at

    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.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    12 on at

    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.

  • L Vail Profile Picture
    65,271 on at

    I'm on board with Frank Hamelly

  • Verified answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    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,

  • Richard Wheeler Profile Picture
    75,852 Moderator on at

    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
    Heather Roggeveen Profile Picture
    9,150 on at

    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

  • Ian Grieve Profile Picture
    22,784 on at

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

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,633 Moderator on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans