Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Sort the scrolling window on RM_Cash_Apply by due date?

Posted on by 5

Using Dexterity, I added an after trigger to the '(L) FillWdw' of window RM_Apply_Document of form RM_Cash_Apply to resort the scrolling window by document due date.  The scrolling window appears to be correct but when I select a document to apply in the scrolling, it applies the wrong document. I can't figure out why it doesn't apply the correct document.  Thanks.

  • DiannFariss Profile Picture
    DiannFariss 21 on at
    Sort the scrolling window on RM_Cash_Apply by due date?
    Were you able to create a dexterity custom to do this?  I have a customer that needs the same change!
    Thanks for your help.
    Diann
  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Sort the scrolling window on RM_Cash_Apply by due date?

    Based on what you’ve found, my hunch is that you’d need create a dexterity customization to change the sorting associated with any code where sorting exists in association with this window. I’m hoping others who have run into something similar while developing a customization will have some more insight for you.

    Dave Musgraves blogs are a really good place to start:

    David Musgrave's Winthrop Development Consultants Blog | This blog will keep you up to date with Winthrop Development Consultants and David’s experiences, tips and tricks as a developer and consultant in the Microsoft Dynamics GP community. (wordpress.com)

  • EricLy Profile Picture
    EricLy 5 on at
    RE: Sort the scrolling window on RM_Cash_Apply by due date?

    Thanks.

    After comparing the scripts, in the 'RM_Applied_Document_Scroll Apply Select CHG on form RM_Cash_Apply' script, the GetDocDate returns differently. This form has a lot of reference fields so it's hard to figure out where the data is coming from but its seems that the rmOpen form has a different order of documents then the scrolling window does since my trigger changes the scrolling window order. I'm not sure where to go from here.  Thanks for any other suggestions.

    'GetDocDate() of form ObjHelper', 0/0/0000, 'rmOpenCredit' of window 'RM_Apply_Document' of form 'RM_Cash_Apply', " of form rmOpen"

           'GetDocDate of form rmOpen', 4-, 0/0/0000

               'GetDocDate() of form rmOpen', 0/0/0000, 4-

  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Sort the scrolling window on RM_Cash_Apply by due date?

    Thank you for using Dynamics Communities. This is Andrea, and I will assist with your question today.

    When you apply sales documents, there are stored procedures and TEMP tables that are populated with those stored procedures that come into play in addition to the dexterity code.

    I’d recommend you gather three specific logs that capture ‘the moment’ you click on the ‘Apply’ button in the Apply Sales Documents window:

    • Dex.sql log
    • Script log
    • SQL trace

    Once you’ve done that, remove your customization and capture the same logs of the exact same process as it occurs in core GP.

    Compare the differences to see why an unexpected document is being applied when your customization is in place.

    I’ve attached instructions for each of these logs (if needed).

    Good luck!

    Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP

    Steps-to-Create-Dexsql.docManual-SQL-Trace-Steps.docxScript-log-instructions.docx

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans