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

Show only the last 4 digits of a field - AL Code

(0) Share

Report

Posted on by kjjson

I have a flow field that I want to show the account number for the bank account selected in a payment journal. What I would like to do is actually just show the last 4 digits of the field. Is there a way to do that within my AL code?

field(50103; "AccountNo"; text[30]){

FieldClass = FlowField;

Editable = false;

CalcFormula = lookup("Bank Account"."Bank Account No."

where("No." = field("Bal. Account No.")));

}

I have the same question (0)

All responses (4)

Answers (0)

Hein Kruger 666 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The Calcformula doesnt allow for functions like "Trim" to work inside or outside the Lookup function.

I would suggest to create a new field Bank Account called "Last Digits". Let this field populate on the Onvalidate Trigger of the Account No.

Let the lookup look to the new field created.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,165 Moderator on at

Like (0)

Report
Copy link

Link copied!

You have the extended data type property that you can use to mask a field:

learn.microsoft.com/.../devenv-extendeddatatype-property

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, You can't do it with Flowfield, you need to add another field.

Then use the following two methods should be able to get the last four digits.

Text.CopyStr(Text, Integer [, Integer]) Method

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/text/text-copystr-method

Text.MaxStrLen(Variant) Method

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/text/text-maxstrlen-variant-method

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,794 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi,

Can you try this instead of Flow field?

trigger OnAfterGetRecord()

var

BankAccount: Record "Bank Account";

begin

lastDigit := '';

if BankAccount.get(<youraccountno.>) then

lastDigit := CopyStr(BankAccount."Bank Account No.", 1, 4);

end;

var

lastDigit: Code[4];

Was this reply helpful? Yes No