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)

Suggested answer

Nitin Verma 21,666 Moderator on at

Like (2)

Report

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

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
Suggested answer

YUN ZHU 92,429 Super User 2025 Season 2 on at

Like (0)

Report

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

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

Inge M. Bruvik 1,037 Moderator on at

Like (0)

Report

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

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
Hein Kruger 629 on at

Like (0)

Report

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

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