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.
Well done on sorting it out.
David
Problem solved. The GL_YTD_TRX_ALL was really GL_YTD_TRX_ALL_View. Such an easy fix.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148