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

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

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