PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/11/2020 10:52 PM by  pglibra
Vendor Agreement Reference
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
pglibra
Supply Chain Revenue Coordinator
Private
Veteran Member
(118 points)
Veteran Member
Posts:54


Send Message:

--
11/19/2020 3: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
    Private
    Private
    Veteran Member
    (1248 points)
    Veteran Member
    Posts:434


    Send Message:

    --
    11/22/2020 9:22 AM
    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
    Senior Supply Chain Analyst
    Boston Medical Center
    Basic Member
    (17 points)
    Basic Member
    Posts:9


    Send Message:

    --
    11/30/2020 2: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
    Supply Chain Revenue Coordinator
    Private
    Veteran Member
    (118 points)
    Veteran Member
    Posts:54


    Send Message:

    --
    12/10/2020 8:47 AM

    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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2793 points)
    Veteran Member
    Posts:955


    Send Message:

    --
    12/11/2020 2: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
    Supply Chain Revenue Coordinator
    Private
    Veteran Member
    (118 points)
    Veteran Member
    Posts:54


    Send Message:

    --
    12/11/2020 10:52 PM

    Thank you

    You are not authorized to post a reply.