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

How do I turn a flowfield column into a plain Text[35] column on any List?

(1) Share

Report

Posted on by Joseph.Candava

183

Hello,

I have a column where a value is referencing another field in the Sales Invoice Header to the Posted Sales Invoice Line List.

When I observe the Posted Sales Invoice Line List, it apparently has a link to something like the row's corresponding customer card on it (unsure if it is from someone's extension or from the Business Central 23.1 update), hindering it from making it searchable if I type the value of the cell as it appears to the eye. So, when I search for 600001 for example, the document is not found even though visually it says 600001.

Posted Sales Invoice List (Illustrative purposes only)

Document No.	Unsearchable column (because it has a link)	Desired searchable column (plain text)	Searchable External Document Number (Current Output So Far)
I-001-00001	600001	600001
I-001-00002	600002	600002
I-001-00003	600003	600003

Using AL, my approach was to introduce another field where it can capture that surface value (the part that is not the link, 600001 for example) and use that for the cell values of the new column.

Unfortunately, the starting field on the Posted Sales Invoice List is using FlowField to perform

has caused this link (to the customer card) effect to occur when its intent is to retrieve the Sales Invoice Header's original values (which I checked is also in Text[35] format).

Is there another line that I can add that could unset the link-to-customer-card effect?

Your help is much appreciated.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Gerardo Rentería Ga... 27,310 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

I hope this can help you. You can get the value from the flowfield field and copy it to the other text field.

Dynamics 365 Business Central: FlowFields (Sum, Average, Exist, Count, Min, Max, Lookup) | Dynamics 365 Lab (yzhums.com)

BR

Gr

Was this reply helpful? Yes No
Suggested answer

Tech-Lucky 1,288 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

As per your requirements and the code provided above, you need to save the calculated flow field value into a standard field. To achieve this, you will have to modify the "each" record every time your page runs the "OnOpenPage" trigger. However, this may cause performance issues

the corrected code would be as follows.

trigger OnOpenPage()

begin

Rec.CalcFields(ExternalDocumentNo);

Rec.ExternalDocumentNoTxt := Rec.ExternalDocumemtNo;

Rec.Modify();

end;

I would recommend against using this approach. Instead, you should modify the new field in bulk by creating a batch only once. Then, you can devise logic to directly insert the value of the external document number into the New field each time a new sales invoice line is inserted.

Was this reply helpful? Yes No
Joseph.Candava 183 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for your responses.

I have applied this code onto my page extension.
trigger OnOpenPage() begin Rec.CalcFields(ExternalDocumentNo); Rec.ExternalDocumentNoTxt := Rec.ExternalDocumemtNo; Rec.Modify(); end;

Upon opening Posted Sales Invoice Lines page, I get an error message saying I lack permissions to use the Rec.Modify(); portion of the code.

This was an unusual behaviour because I have been granted a "Yes" on the Modify permission for Table Data 113 when I go to the Users page.

Upon checking "Effective Permissions" under my account, I discovered that my license does not allow me to modify Table Data 113.
Which license will allow me to perform this?

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,736 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Candava,

To resolve the permissions error, you will need to provide the permission on the pageExt where you run the .Modify() function.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-permissions-property

Most, if not all, of the posted tables are not modifiable unless permissions are provided on the code/function.

Was this reply helpful? Yes No