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
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
    Posts: 476
    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
      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
        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
          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
            Posts: 76
            Veteran Member
            12/12/2020 3:52 AM

              Thank you