GP 2013 vendor card - mass modify

(0) Share

Report

Posted on by PamE

110

We would like to change the default payment terms on all of our vendor cards. (I don't think that there is a company default and payment terms are all on the vendor level, correct me if I'm wrong) Is there a way to modify vendor terms in mass?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Kelsey Koep on at

Like (0)

Report

If these Vendors have a common Vendor Class ID, then I would suggest that you modify the Payment term of this Vendor Class ID in the Vendor Class Setup Window (Setup>>Purchasing>>Vendor Class), click Save and ROLL DOWN the changes.

This would automatically update the Payment term of those Vendors under this Vendor Class.

Another option for you is to make a Vendor Class ID that has this Payment term and assign these Vendors to this Vendor Class.

Hope this was helpful!

Kelsey

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

You could also update payment terms via SQL script.

UPDATE PM00100

SET PYMTRMID = 'your payment term ID'

Be sure you take a backup of the database before running any scripts in production.

Was this reply helpful? Yes No
PamE 110 on at

Like (0)

Report

Kelsey thank you for directing me to the vendor classes, as we are not consistently using classes which is a process improvement we need to address. however, since class assignments are not up to date, the work will be the same.

Was this reply helpful? Yes No
PamE 110 on at

Like (0)

Report

Frank, sounds like a great solution, only wish I knew how. Anything you can point me to for basic training would be great.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (1)

Report

If you haven't experience in this Pam, you'd be well advised to enlist the help of your IT department and if they haven't the experience, then your GP partner, and if they haven't the experience, let me know. We'll get you some help somehow.

Was this reply helpful? Yes No
KirkLivermont 5,985 on at

Like (0)

Report

If you only have a few hundred vendors you might be safer using a macro to mass update the payment terms.

Was this reply helpful? Yes No