Filter in NAV

(0) Share

Report

Posted on by Community Member

I want to set a Order Date filter - showing me orders made LAST MONTH. (I'm in a Danish version). I can select "P" - showing this month. I can Select "P-1M" - but showing me last month - but only almost as doing it in November it makes me see orders from 1/10-30/10 (As this period only has 30 days). Then I mish orders made the 31st of October.

How can I save a filter always showing me the period of last month ? Thank you for you reply.

Helle

I have the same question (0)

All responses (4)

Answers (1)

Community Member on at

Like (0)

Report
Copy link

Link copied!

Madsen Scan Wear wrote the following post at 17 Nov 2021 11:26 PM:

I want to set a Order Date filter - showing me orders made LAST MONTH. (I'm in a Danish version). I can select "P" - showing this month. I can Select "P-1M" - but showing me last month - but only almost as doing it in November it makes me see orders from 1/10-30/10 (As this period only has 30 days). Then I mish orders made the 31st of October.

How can I save a filter always showing me the period of last month ? Thank you for you reply.

Helle

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Madsen,

I am in a US version so I will try to answer using my version... On the Sales Order List, I will set the filter so I only see Order Dates from Last Month. NOTE: My Sandbox shows Work Date = 5/25/21 so the results are correct.

Now to save this follow these steps:

1. Click the Floppy Icon next to the word ALL

2. You will enter a Name to save the Filtered View

3. Now you can switch between different Views clicking into the Views List show below.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply.

Though I was looking for a fixed filter to save. I found the solution for my question:

This is the date filter I was lookin for. This will always give me a view of last month - not having to set in the filter every time for the new period

Order date filter:

-lm-1m..-lm-1d

Was this reply helpful? Yes No
Verified answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Great work, thank you for sharing final outcome.

Was this reply helpful? Yes No