Finance | Project Operations, Human Resources, ...

Sort the scrolling window on RM_Cash_Apply by due date?

(1) Share

Report

Posted on by EricLy

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.

Categories:

Microsoft Dynamics GP

All responses (4)

Answers (0)

DiannFariss 22 on at

Like (0)

Report

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 3,437 on at

Like (0)

Report

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 5 on at

Like (0)

Report

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 3,437 on at

Like (0)

Report
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.doc Manual-SQL-Trace-Steps.docx Script-log-instructions.docx