Supply chain | Supply Chain Management, Commerce

Advance query to filter date

(1) Share

Report

Posted on by Teevo

381

Hi guys,

May I know, if lets say in Purchase Order, I want a list of PO that already confirmed and not yet being received which already overdue for about 3 days. How are we going to create this filter ?

Or we want list of PO that will be due tomorrow, is this possible ?

Let say the base is Requested Receipt date.

Can Advance query help us ?

Thanks,

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Waed Ayyad 9,026 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Teevo

Where do you want to add the range by code? You can use GreaterThanDate(1).

Also check the following MS Document about date ranges:

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/advanced-filtering-query-options

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Teevo 381 on at

Like (0)

Report

Hi Waed,

Thank you. I just take a look and looks promising. Although seems it is not as expected (or perhaps I'm doing it wrongly)

So, I tried in my PO like this:

What's in my mind is: I want to show all my PO that the Requested Receipt Date way behind starting 3 days back, and the status not Received or not Invoiced.

I wonder whether my usage of "DayRange(-999, -3)" correct or not.

Because, when I apply, I still have many PO which already past but yet to be received/invoiced, and it doesn't show in the list.

If I take a look back on the Filter, it will be like this:

and, yes, it will show me only 1 rows.

While actually I have more than that:

In fact, that 1 rows after applied (my 1st picture), is wrong, because the Requested Receipt Date is today (12/9/2025), which in my query I want those PO that date is starting 3 days behind.

Was this reply helpful? Yes No