AP Vendor Inactivation or SQL to make vendors inactive in BULK

(0) Share

Report

Posted on by Community Member

Hi All,

We are looking at options of cleaning our AP Master Data for Vendors.

A consultant has advised us to use the Vendor Inactivation in Procurement and Sourcing >Periodic>Vendors>Vendor inactivation, however, it still allows newly created vendors to be inactive.

I was thinking running an SQL script to find all vendors that are active, and has not been used for 18 months to be updated to inactive.

Does any one have any options to clean vendors in bulk ?

Cheers,

Phung Huynh

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi Mhuynh11,

Can you please explain what is wrong with "Vendor inactivation" periodic operations and what your SQL script should do that Vendor inactivation does not ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi ievgen,

The vendor inactivation still makes new vendors that I recently created to be "ON HOLD".

The inactivity period (indays) 568

Grace time before next hold (in days) 1 day

Includes employees : NO

Is my set up done incorrectly?

so the script I want to do is that it can get me a list of all active vendors that hasn't been used since 2016 and then update to make it "ON HOLD" / inactive .

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

I would not suggest changing AX database data with direct SQL queries. This can cause issues because of application caches, RecVersion fields and so on.

Instead write a x++ class or job to make your changes through the application.

Was this reply helpful? Yes No
Douglas Noel 3,907 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think the real problem is the missing exact definition of: What is a vendor, which isn't used since xyz.

If a vendor hasn't any transactions after xyz it is not used after xyz. Even a new one.

Maybe it makes sense to check the number of transactions (if any exist) for a given vendor and skip vendors without transactions (or make an additional check in that case, which, for example checks the creation date of the vendor, to distinguish between new vendors without transactions and really old one)

Regards Douglas

Was this reply helpful? Yes No