Skip to main content

Notifications

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

Control Grid Columns Visibility

Posted on by 33
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
  • MA-07051407-0 Profile Picture
    MA-07051407-0 33 on at
    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 Profile Picture
    Mohit Rampal 12,547 Super User 2024 Season 1 on at
    Control Grid Columns Visibility
    Hi, In addition, you can refer standard code in LedgerJournalTable form
     
  • Martin Dráb Profile Picture
    Martin Dráb 230,030 Most Valuable Professional on at
    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().

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans