Max in a flowfield

deepblue · 2006-12-15

Hello,

In the Item Card, i'm trying to have a field that contain the posting date of the last entry in the Item Ledger Entry.

In the CalcFormula of the Flowfield I wrote

Max("Item Ledger Entry"."Posting Date" WHERE (Item No.=FIELD(No.),Posting Date=FIELD(Date Filter)))

The problem is the result is not the last date but the date in the last entry.
:-k

Can you help me?

David_Cox · 2006-12-15

This is due to the key, it will use "Document No.", "Posting Date" as a best match.

Doc No. Date
1234567 12/01/06
1234568 12/16/06
1234569 12/06/06
Will return the last 12/06/06 and not 12/16/06

Create a key starting with "Posting Date" and try again

deepblue · 2006-12-18

there is a key starting with "posting date" but how can I set it for the flowfield?

David_Cox · 2006-12-19

deepblue wrote:

there is a key starting with "posting date" but how can I set it for the flowfield?

Sorry looked again the Key needs to be "Item No.", "Posting Date"

Max in a flowfield

Comments

Categories