List of Vendors with no transactions

(0) Share

Report

Posted on by Community Member

I have a requirement where I need to list out all the active vendors which have no transactions since some date(say 2018). How do I list out all those vendors in AX 2009?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report
Copy link

Link copied!

Two ways of doing this: 1. SQL query if it's one time request 2. Write code in AX. Query in both cases would be like: Select * from vendtable where not exists (select vendor account from VendTrans where transdate > your cut off date). See if you have additional requirements where in u have to remove vendor from this list if they have open PO etc.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes, I have a requirement where I need to exclude the vendors with an open balance from the above list. How can that be achieved?

Was this reply helpful? Yes No