0

Most Recent Version No.

Hi,

I have a simple NL Rows line

=@NL("Rows","Sales Header Archive",,"Document Type","Order","Sell-to Customer No.",Customers!$C$4:$C$15)

Returning the fields:

No.

Sell-to Customer No.

No. of Archived Versions

Amount

Order Date

Version No.

However, the same order "No." obviously has multiple versions how can I set it so it brings all the orders back but only with the information relating to the most recent "Version No."?

 

2 comments

Please sign in to leave a comment.