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) / Transaction report?
Microsoft Dynamics GP (Archived)

Transaction report?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all,

I am new to Dynamics GP and trying to gain a better understanding of the software.

I have been trying to find a transaction report to include the following:

Vendor Name

Item Description

Account code

Cost

PO Number

Date receipted.

I want to be able to see all actual expenditure by inputting an account code, whether this be manual journal entries or the receipting of purchase orders.

Is there a standard report that is accessible within Dynamics? If so, where can I find such a thing?

Thanks in advance!

*This post is locked for comments

  • Alvaro Rodríguez Ochoa Profile Picture
    Alvaro Rodríguez Ochoa 2,395 on at
    RE: Transaction report?

    I think Tami's approach is the best for you, you just need to add the columns with the GL accounts and then filter the results.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Transaction report?

    Thanks Tami. Although this doesn't pull any form of transaction through for me.

    I have looked under Financial > Inventory and can run a couple of reports this way, although it isn't ideal.

    Thanks again.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Transaction report?

    Smart List

    Inventory>Inventory Transactions...you can add the GL accounts.

    and see the transaction type....

    I use smartlists from various modules and export to excel then use Vlookup to link the data...

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Transaction report?

    Thanks Tami, this could be useful. However, I want to be able to specify an account code.

    Also, I want all transactions that have been coded to an account, not just those that are coming from Purchase ledger.

    Is there not a report that does this?

    Thanks again.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Transaction report?

    Use the smart list

    Purchasing> Recievings transactions

    Tami

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,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans