Vendor Agreement Reference - LawsonGuru.com

pglibra

Veteran Member

Posts: 76

11/19/2020 8:16 PM

Is it possible to change the Vendor Agreement Reference name in PO25?

Reason I ask is because someone created one with a couple of spaces in front of the name and I want to remove the spaces.

When I remove the spaces and hit Change, message on bottom keeps saying "Must inquire before using this function code".

Thank you

Ragu Raghavan

Veteran Member

Posts: 468

11/22/2020 2:22 PM

Since the agreement ref is a key in the primary index, I don't think PO25 or any lawson form will let you change it. You will need to delete and re-add.
You could potentially go behind the scenes (using 4GL, SQL....) and trim the spaces. Be careful of data integrity. Many tables are related using this field (Agreement header, lines, pricing, participant, etc.). All of them will need to be identified and changed to maintain integrity.

JODAMORE

Basic Member

Posts: 10

11/30/2020 7:23 PM

Greetings,

Ragu's answer is 100% accurate. No changes are permitted to this value, and any modifications are highly discouraged due to the chain of impact. You are best suited to close the agreement and recreate.

pglibra

Veteran Member

Posts: 76

12/10/2020 1:47 PM

Thank you both!!

Is there a way to copy an agreement with new name or will I need to recreate entire agreement?

What report can I use to pull all the lines from agreement so I can use Add-ins to upload faster?

Thanks

Kat V

Veteran Member

Posts: 1020

12/11/2020 7:58 PM

PO225 will print a PO25 - but if you have addins it's likely just as easy to query the table for the fields you need.

pglibra

Veteran Member

Posts: 76

12/12/2020 3:52 AM

Thank you