Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Modify fields in Financial Inquiry

Posted on by 120

I would like to know if there is a way to change what fields show when looking at a detail inquiry (Inquiry->Financial->Detail).  I would like to bring in the vendor name so I don't have select Journal entry and then source document to get at that information.  I also tried to bring the Vendor name as a field in a smart list, but I wasn't able to find that as an option either.  Either option would make researching expenses much easier.

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Modify fields in Financial Inquiry

    Hi again,

    Here's what the window looks like that includes the additional fields:

     

     

    Kind regards,

    Leslie

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Modify fields in Financial Inquiry

    Hi,

    The Financial Detail Inquiry window can definitely be modified to include the Vendor ID. As Mahmoud said, the field you need to add to the window is the Originating Master ID. I have modified this window, and the GL Transaction entry window, many times so that it included this information.

    I am happy to share the package file of my modified windows with you if you are interested in making that kind of change.

    Please e-mail me directly to leslievail@earthlink.net if you would like the package file. I will not be monitoring this post, so adding a reply to the post will not cause me to send you the file (because I will not see it).;

    Kind regards,

    Leslie

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Modify fields in Financial Inquiry

    I do believe you could consider another solution for this specific requirement, instead of modifying the "Financial Detail Inquiry" which includes all journal entries originating from all Dynamics GP modules, you can create a separate report to be added into any of the vendors inquiries. Something like "Vendor Ledger Statement", so when you go to vendor inquiry, clicking on this add-on shall generate all related transactions for this specific vendor along with the journal entry. 

    You may check MVP Victoria script as a start, which shows SQL view for Payables invoices originating from POP in Dynamics GP

    As for the Smart List, in case you are talking about the "Account Transactions" smart list, there is a field (Originating Master ID), which retrieve the ID of the master entity, either vendor, customer ..etc

    Your feedback is highly appreciated, 

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans