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

(0) Share

Report

Posted on by Govinda Kumar

2,304 Moderator

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

I have the same question (0)

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

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?

Was this reply helpful? Yes No
Govinda Kumar 2,304 Moderator 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

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
Govinda Kumar 2,304 Moderator 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.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No