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

(0) Share

Report

Posted on by Govinda Kumar

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.

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

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

All responses (5)

Answers (0)

AJ-21080818-0 60 on at

Like (0)

Report

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 2,203 Super User 2024 Season 1 on at

Like (0)

Report

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.

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.

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 60 on at

Like (0)

Report

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 2,203 Super User 2024 Season 1 on at

Like (0)

Report

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 60 on at

Like (0)

Report

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?