Supply chain | Supply Chain Management, Commerce

Purchase order lines with confirmed delivery date exceeding delivery date

(0) Share

Report

Posted on by M DEWEVER

Is there a way to filter a view to show open purchase order lines where the confirmed delivery date is greater than the delivery date? I want to automate (or create a tile) to show purchase order lines where we receive a confirmed delivery date greater than or equal to (X DAYS) more than the date we requested on our PO.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Danny Bilodeau 4,934 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello M Dewever,

There is out of the box functionality In D365 F&O to use a field value as an input to filter another value (even without the logical operator). You can of course extract in Excel or use Power BI. But if you want to create a tile in D365, you would need to add a new calculated field on teh Purchase Order lne that calculates the number of days between the two dates and you would apply to logical greater or equal filter on that new field.

Regards,

Danny

Was this reply helpful? Yes No
Suggested answer

ColbyGallagher 3,668 on at

Like (0)

Report
Copy link

Link copied!

Yes, use the actual column names from the PurchLine table in the range for any OTHER field and use standard SQL logic, you'll get what you want:

Was this reply helpful? Yes No
Danny Bilodeau 4,934 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Wow! Good tip. Learn something new everyday.

Was this reply helpful? Yes No
M DEWEVER 10 on at

Like (1)

Report
Copy link

Link copied!

Thank you! worked perfectly.

Was this reply helpful? Yes No
ColbyGallagher 3,668 on at

Like (0)

Report
Copy link

Link copied!

M DEWEVER please mark answer as verified so I get internet points! And so people find this answer more easily in the future.

Was this reply helpful? Yes No