Skip to main content

Notifications

Small and medium business | Business Central, N...
Unanswered

Maintaining Consistent Column Values for All Records in Business Central Document Page with List Parts

Posted on by 2,203 Super User 2024 Season 1

I have created a Business Central document page with a grid component and several columns above it. These columns are not part of the grid's data table but are instead defined as global variables on the page. Additionally, I have attached two list parts to this page.

pastedimage1675837675526v1.png

When I enter values into the columns above the grid, I noticed that the values are reset for every record in the grid.

pastedimage1675837759776v2.png

pastedimage1675837800319v3.png

I would like for the values entered in these columns to remain the same for all records in the grid, regardless of which record is selected.

Can you provide guidance on how to achieve this? Any help would be greatly appreciated, and I would be happy to provide additional details about the attached list of parts if needed

Thanks and Regards


Govinda Kumar

  • AJ-21080818-0 Profile Picture
    AJ-21080818-0 60 on at
    RE: Maintaining Consistent Column Values for All Records in Business Central Document Page with List Parts

    This is technical issue so better send page/parts source code.

  • Govinda Kumar Profile Picture
    Govinda Kumar 2,203 Super User 2024 Season 1 on at
    RE: Maintaining Consistent Column Values for All Records in Business Central Document Page with List Parts

    Hi Aleksandrs,

    Thanks for your suggestion. Let me give you a bit more context about my pre-allocation page. Essentially, it's a form that I use to import data from an external source. It has two main sections, Performers and Productions, consolidating the imported data, and a Find/Replace feature that works well and can handle a huge number of records.

    6204.png

    One of the main purposes of this page is to let users select records from the grid and match them with available data in Business Central. This process includes matching/unmatching performers and productions. To make it easier for users, I've added the criteria selection section above the grid to either work with productions or performers.

    782145.png

    2728.png
    The issue I'm currently facing is that whenever I select a new record from the grid, the criteria selection resets. I was hoping to find a solution that will keep the criteria selection the same for all records.

    I hope that helps provide a better understanding of my pre-allocation page and what it does.

    regards.

  • AJ-21080818-0 Profile Picture
    AJ-21080818-0 60 on at
    RE: Maintaining Consistent Column Values for All Records in Business Central Document Page with List Parts

    Hi, Why don't you use BC standard search/filter features on the page/grid with update button where you show another page and user enters field, new value (maybe some selection criteria) and presses update button and code does the job?

    If you could export your objects and attach them I might have a look.

  • Govinda Kumar Profile Picture
    Govinda Kumar 2,203 Super User 2024 Season 1 on at
    RE: Maintaining Consistent Column Values for All Records in Business Central Document Page with List Parts

    Hi Aleksandrs Judovs

    I have four columns that I use to find and replace data in the grid. The logic works perfectly and I have tested it. However, I have noticed that when I select a record in the grid, only the page part for that specific record disappears. I would like to make the page part disappear for all records in the grid, not just one selected record.

    regards

  • AJ-21080818-0 Profile Picture
    AJ-21080818-0 60 on at
    RE: Maintaining Consistent Column Values for All Records in Business Central Document Page with List Parts

    Hi,

    What is the purpose of 4 windows on left top? Do you want to filter / sort / update data represented in the grid?

    What exactly you wanted to achieve with this page?

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,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans