web
You’re offline. This is a read only version of the page.
close
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 / Finance | Project Operations, Human Resources, ... / Great Plains
Finance | Project Operations, Human Resources, ...
Unanswered

Great Plains

(0) ShareShare
ReportReport
Posted on by Community Member

I would like to know if there is a way to display both sides of a journal entry by selecting two specific accounts.  I am new to GP and am having a bit of a challenge with running a report that displays all journal entries for specific account combinations (i.e. display all journal entries that have only the prepaid and A/P accounts).  I attempted a number of combinations for a specific account segment but was unable to pull the offsetting account string.

Any assistance is appreciated.

Thank you.

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at

    Hello Milla.

    Thank you for your question on the forums today.

    I think the best approach would be to use the Account Transactions Smartlist. You can filter on the Account Number.

    Give the following a try:

    1. Open Smartlist.
      1. Dynamics GP | Smartlist
    2. Expand the Financial Folder.
    3. Expand Account Transactions.
    4. Select the * and the smartlist should now display.
    5. Click the Search Button.
    6. In the search window, create two Searches.
      1. The first one.
        1. Column Name = Account Number.
        2. Filter = is equal to
        3. Value = First Account Number.
      2. The Second one.
        1. Column Name = Account Number.
        2. Filter = is equal to
        3. Value = Second Account Number.
      3. Click Ok.
    7. Now it should filter all transactions by this Account.
    8. Alternatively, you could use the Journal Entry Number as the search and it will only display the accounts for the Journal Entry.

    I hope this helps!

    Microsoft Support Engineer | Brandon Jarrett

  • Community Member Profile Picture
    Community Member on at

    Thank you for your suggestion.  Using multiple searches was one of my first attempts to pull both sides of several journal entries; it did not work.  In addition, I singled out one segment of the account number to be specific and that did not work as well.  I am looking to review a high volume of journal entries and pulling them singularly would take a significant amount of time.  I appreciate your time.

  • Gerald Buenafe BTP Profile Picture
    Gerald Buenafe BTP 280 on at

    Hi Milla,

    You may need to do it in a sql query to pull the data out. let me know if you need help building that query

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans