Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Invoice Document Lookup from RMA Entry / Update

Posted on by 1,325

Hello,

This is for GP2010. I created an RMA for a specific customer  and customer address ID. The origin document for the RMA is sales invoice. When I click the sales document lookup icon the Invoice Document Lookup window is displayed. However, the list of returned records is only customer number specific. Invoices are listed for all address ID's associated with the specified customer number. Shouldn't the invoices returned in the list be only for the unique combination of customer number and address ID that were specified on the RMA Entry / Update form? How can we change the lookup to only return invoices that are for the customer / customer address ID that were specified on the RMA Entry / Update form?

Thank you.

Larry

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Invoice Document Lookup from RMA Entry / Update

    Larry,

    Sure. You need to create a customization with the trigger for the Invoice Document Lookup after original and set the filter whatever you want to the attached table for this lookup window and refill the window.

    Please let me know if you need  any other information regarding the same.

    Hope this helps!!!

  • Larry Turner Profile Picture
    Larry Turner 1,325 on at
    RE: Invoice Document Lookup from RMA Entry / Update

    Soma,

    Thank you for taking a look at this and for your response. At best this seems to be a deficiency in the GP code. The record selection logic for Invoice Document Lookup should in my opinion include any record address ID that is specified on the RMA Entry / Update form.

    Larry

  • Verified answer
    soma Profile Picture
    soma 24,406 on at
    RE: Invoice Document Lookup from RMA Entry / Update

    The only way is creating a customization in either VBA or Dexterity.

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