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

LookUp() function usage to calculate field value

(1) Share

Report

Posted on by BBC_Astha

160

can you please explain how Lookup() works in Business Central AL Code?

I am trying to understand the following code:-

CalcFormula = Lookup(/Sales Shipment Header/./Shipment Date/ where(/No./ = field(/Last Shipping No./)));

According to my understanding,

This function will return Shipment Date. but how it is able to filter? I am not able to understand /where/ part.

one thing I am sure of ,the two fields inside where will have same datatype, one is from sales shipment header and other one will from Sales Header table as this code is from SalesHeader.dal

Can someone please explain me this?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (0)

Report

Hi

I hope this can help you, and give you some hints

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

best regards

Gerardo

Was this reply helpful? Yes No
Suggested answer

Dustin Wolf 30 on at

Like (0)

Report

In this instance, the look up is going to a specific record, and since you have Sales Shipment Header . Shipment Date, the look up is specifically looking for that field from that record.

the Where is basically telling the system the specifics.

Where( "No." (the sales shipment No.) = field(" Last Shipping No. ") (the field on the sales header) )
this tells the calcformula that it has a 1 to 1 relationship. So it knows how to pull that specific shipment, and the specific date.

Dustin Wolf, MS

Senior Developer

Accent Software, Inc.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, If you can use VLOOKUP in Excel, this part can be understood as finding Lookup value (3) in Lookup column (ID), and Sales Shipment Header.Shipment Date is Result.

More details: https://www.simplilearn.com/tutorials/excel-tutorial/vlookup-in-excel

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No