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
If you only have a few hundred vendors you might be safer using a macro to mass update the payment terms.
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.
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.
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
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
