Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Dexterity Mod Failing with Update to 18.3

(0) ShareShare
ReportReport
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.

Categories:
  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,932 Most Valuable Professional 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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans