Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Vendor Agreement Reference

 5 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
pglibra
Veteran Member Send Private Message
Posts: 76
Veteran Member
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 Send Private Message
Posts: 477
Veteran Member
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 Send Private Message
Posts: 10
Basic Member
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 Send Private Message
Posts: 76
Veteran Member
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 Send Private Message
Posts: 1020
Veteran Member
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 Send Private Message
Posts: 76
Veteran Member
12/12/2020 3:52 AM

Thank you