News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Control Grid Columns V...

Finance | Project Operations, Human Resources, ...

Unanswered

Control Grid Columns Visibility

(0) Share

Report

Report

Posted on by MA-07051407-0

37

I am working on a requirement, where i am updating LedgerJournalTable with voucher Number and Date Columns from the LedgerJournalTransTable, Once

Journal is approved. I want to display theses fields in LedgerJournal ( LedgerJournalTable) Form Grid but i want to display these fields for invoice journals only.

I tried to use active method to control the form control visibility and it's working well but the issue is active method is iterating on all Grid Rows one by one and it's effecting the performance.

Can Someone please tell me any other suitable solution for this.

Thanks

All responses Img

All responses (3)

Answers Img

Answers (0)

MA-07051407-0 37 on at

Like (0)

Report

Control Grid Columns Visibility

Hi Mohit;

Thanks for sharing the relevant information. In my case i want to control grid columns visibility i.e., In case if the journal is of type Vendor invoice Recording i want to change the column visibility to yes.

By default the columns visibility is set to No. As ledgerJournalTable form is same for all Finance Journals but i want fields visibility on invoice journal Only.

Thanks
Mohit Rampal 12,547 Super User 2024 Season 1 on at

Like (0)

Report

Control Grid Columns Visibility

Hi, In addition, you can refer standard code in LedgerJournalTable form
Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

Control Grid Columns Visibility

active() method doesn't iterate records - it's executed once when a record is selected. If you mean that you added such an iteration into active() and now you've realized it was a bad idea, remove it and think your requirements through again.

Are you sure you want to evaluate a condition for each record? Don't you rather want to show or hide the column depending on what type of journals that the form is opened for? You can get that by calling journalFormTable.journalTypeId().

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans