Question

Supplier Payment Term

  • 17 March 2023
  • 1 reply
  • 42 views

Userlevel 4
Badge +10

Good Morning - Can anyone assist with the queries below relating to Supplier Payment Terms:

Thank you for your support

  1. Is there a search function that will be able to pull out a list of suppliers who have had their payment terms changed since 1st March 2023=
  2. Assuming above is "yes", is there way to "bulk update" any impacted PO's with the correct terms, rather than go through each supplier one-by-one.
  3. Is there a search functionality that will bring up a report for all Suppliers Payment Term.

1 reply

Userlevel 7
Badge +28
  1. You can do this only if you have first enabled history log tracking for this field.  It is not on by default.
  2. The only way you could do this is by creating a migration job, otherwise there is no out of the box function to do this.
  3. Do you want the terms currently on the PO or the terms currently set against the supplier?  In either case, a quick report or using the SQL query tool is going to be the way to get to this information.  I don’t recall a screen that has this field exposed so you can do a straight search.  You could on the POs, but not against the Supplier.

Reply