web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to filter the late...

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

Suggested Answer

How to filter the latest data using flow field in Business Central?

(0) Share

Report

Report

Posted on by Inkey Solutions

2,102

Hi all,

In the image above, I created a new custom flow-field where I want to store the value of the last purchase order of a particular Item, the field is named as "Last received" and this field is stored on the Items card.

Problem: I am not getting the date of the latest Order when it was created instead I am getting the value of the first created order's date.

Can anyone please help me with this?

Thanks in Advance

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

Would the “Posting Date” from the purchase receipt line table make more sense here?

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,300 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

CalcFormula is quite limited on the functionality. Try using max, instead of lookup, and see if you can get the "maximum" date.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,986 Super User 2026 Season 1

#2

YUN ZHU 1,071 Super User 2026 Season 1

#3

Dhiren Nagar 975 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans