Skip to main content



No record found.

Microsoft Dynamics NAV forum
Suggested answer

Excel temples picks the first value it finds, but i want the last value.

Posted on by 2
Hello everybody,
Basically the "problem" i have is already described in the title, i work for a company that stores products for other companies. 
We send a detailed excel sheet everyday in wich our customers can see all the items and details they have stored here, we do this by using a self-made excel template.
Two colums in this excel sheet are "Registered date" and "Registered time", this information is taken from the table  "WMS Reg. Transactions Detail" and a filter is used regarding Transaction Type, so that the values are selected only from registered transfers. 
Because these transfers is what its all about, in our excel sheet the customer wants to see the latest transfer per palletcode. But here comes the problem, sometimes a palletcode is transfered multiple times, this means there can be multiple lines in previously named table per palletcode, because the tables in Microsoft Dynamics are standard ordered from old to young this means the excel template picks the oldest transfer date and time connected to a certain pallet code.
The question: Is it possible somehow, to make it so the excel temple picks the last value if there are multiple values found ?  (added a screenshot of the excel template)
thanks in advance,
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 64,237 Super User on at
    Excel temples picks the first value it finds, but i want the last value.
    Hi, I don't know how you made this Excel, but I personally suggest using Query, which is very convenient for getting the last value.
    Hope this helps.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans