News and Announcements icon

Dynamics 365 CommunityForums Finance forum Compare 2 Columns by f...

Finance forum

Unanswered

Compare 2 Columns by filtering - List Page

(1) Share

Report

Report

Posted on by SyrusBauzigur

42

For Vendor , Customer Master, All Sales Orders etc.

Some of the Customers have 2 accounts - one as Customer account and 2nd as Invoice account ( like chain account or Parent/Child account)
So I want to filter the records where customer account is NOT equal the Invoice account

How do I do that using the front end and filtering option?

Categories:

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

André Arnaud de Cal... 290,115 Super User 2024 Season 2 on at

Like (2)

Report

Compare 2 Columns by filtering - List Page

Hi Syrus,

On one of the fields in the advanced query form, you can enter SQL statements between brackets. In your case you should enter the next filter value:

(CustTable.AccountNum != CustTable.InvoiceAccount)

Helpful resources

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,115 Super User 2024 Season 2

#2

Martin Dráb 227,971 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans