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

(0) Share

Report

Posted on by Inkey Solutions

2,075

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 (2)

Answers (0)

Suggested answer

Teddy Herryanto (Th... 14,046 Super User 2025 Season 2 on at

Like (0)

Report

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

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

JAngle 113 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No