Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

Dexterity Mod Failing with Update to 18.3

Posted on by Microsoft Employee

I have a client for whom I did some Dex mods to their GL Detail Inquiry screens. When we updated to GP 2018, and the current and history detail inquiry windows combined, I was all set for problems, however my code updated without an issue.

A week ago, I applied the GP 18.3 update, and we are failing miserably. I just figured I needed to rework the mods.

I'm down to a trigger that fills 2 reference type fields. (L) Conditional_Reference_1 is on row 1 and (L) Conditional_Reference_2 is on row 2. Effectively, if there is a master name for the record, it prints on the top line, and the GL reference prints on the second line. Otherwise the GL reference prints on the top line.

The below trigger compiles okay, but the fields are not populating with anything. I see that the GL_YTD_TRX_OPEN is still listed as a table on the GL_Inquiry_Current_Detail form, but there is no GL_TRX_HIST. Instead there is a table called GL_YTD_TRX_ALL, which I am assuming is a temp table combining current and history.

Has anyone dealt with these GL changes on the backend and can share how to deal with this new configuration?

My Trigger code:

if empty('Originating Master Name' of table GL_YTD_TRX_OPEN)
then set '(L) Conditional_Reference_1' of window Current_Detail_Scroll of form GL_Inquiry_Current_Detail to Reference of table GL_YTD_TRX_OPEN;
else
set '(L) Conditional_Reference_1' of window Current_Detail_Scroll of form GL_Inquiry_Current_Detail to 'Originating Master Name' of table GL_YTD_TRX_OPEN;
set '(L) Conditional_Reference_2' of window Current_Detail_Scroll of form GL_Inquiry_Current_Detail to Reference of table GL_YTD_TRX_OPEN;
end if;

Any thoughts would be greatly appreciated.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,831 Moderator on at
    RE: Dexterity Mod Failing with Update to 18.3

    Well done on sorting it out. 

    David

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dexterity Mod Failing with Update to 18.3

    Problem solved.  The GL_YTD_TRX_ALL was really GL_YTD_TRX_ALL_View.  Such an easy fix.

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans