PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 6/25/2015 4:15 PM by  SCMaster-jk2
Mass Contract Status Changes
 10 Replies
Sort:
You are not authorized to post a reply.
Author Messages
SCMaster-jk2
SCM Analyst
Private
Veteran Member
(240 points)
Veteran Member
Posts:100


Send Message:

--
6/22/2015 5:31 PM

    I'm trying to clean up our vendor agreements area and need to put a lot of contracts on hold. I've tried to do this with add-ins but I'm not sure which field to use to put the contract on hold.

     

    I mapped my columns as so:

     

    Group Contract Left Column Check Status

    _f2,PVH-PROCURE-GROUP _F6,PVH-VEN-AGRMT-REF Left Column Check (H),_f4, PVH-STATUS

     

    When I put "H" into the status column for "hold", nothing happens. Can anyone assist?

    Stephanie
    Director
    RPI Consultants
    Veteran Member
    (246 points)
    Veteran Member
    Posts:86


    Send Message:

    --
    6/22/2015 6:44 PM
    Hello,

    There is no such status as "hold", this is a numeric field. A value of 0 is unreleased, 1 is released, 2 is revised, 3 is closed. However there is a Hold-Flag field that you would upload to "Y". I believe PO25 also requires the HK as part of the upload. Hope this helps!
    Stephanie Kowal | skowal@rpic.com
    SCMaster-jk2
    SCM Analyst
    Private
    Veteran Member
    (240 points)
    Veteran Member
    Posts:100


    Send Message:

    --
    6/22/2015 7:33 PM
    Where would the hold flag be on PO25? I know there's one in PO25.6 but I haven't seen on in PO25. Thank you so much!
    Stephanie
    Director
    RPI Consultants
    Veteran Member
    (246 points)
    Veteran Member
    Posts:86


    Send Message:

    --
    6/22/2015 7:45 PM
    No problem! It is an option under special actions.
    Stephanie Kowal | skowal@rpic.com
    SCMaster-jk2
    SCM Analyst
    Private
    Veteran Member
    (240 points)
    Veteran Member
    Posts:100


    Send Message:

    --
    6/22/2015 7:59 PM
    How would I access the special actions menu via add-ins to put the entire contract on hold?
    MK
    Private
    Private
    Advanced Member
    (69 points)
    Advanced Member
    Posts:23


    Send Message:

    --
    6/23/2015 11:54 AM
    You cannot use MS Add-Ins to put a contract header on hold but it can be used to put lines on hold. I suggest contacting Don Peterson ( don.peterson@infor.com )
    with Infor Lawson and see if he can create a self contained file for you. It is an Excel file that uses all the Lawson security to perform advanced form functions like the special action of Hold.
    JonA
    Private
    Private
    Veteran Member
    (3449 points)
    Veteran Member
    Posts:1147


    Send Message:

    --
    6/23/2015 12:11 PM
    Addins only supports the standard actions- Add, Change, Delete and not special actions. Although on the PO25 screen the only way to put the agreement on hold is to select the Hold special action, you CAN use Addins to CHANGE the HOLD-MSG field to Y even though there is not an actual field on the screen. The flag is behind the scenes. Map these fields:

    _f2,PVH-PROCURE-GROUP
    _f6,PVH-VEN-AGRMNT-REF
    _f7,HOLD-MSG

    The agreement header will be on hold and each line will be on hold just as if you selected the hold special action manually in PO25.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Michelle Wetzel
    Lawson Procurement Systems Specialist
    Carle Foundation Hospital
    Veteran Member
    (525 points)
    Veteran Member
    Posts:183


    Send Message:

    --
    6/23/2015 12:39 PM
    Another useful trick in cleanup is to inactivate the vendor item on PO13.3 (Vendor Items). This in turn will automatically put the item on the agreement on hold and will also mark the vendor item as inactive. It won't help you put the entire agreement on hold but it is useful for individual changes.

    PO 13.3 Vendor Items
    _f2,PIV-PROCURE-GROUP
    _f4,PIV-ITEM
    _f5,PIV-VENDOR
    _f13:0,LINE-FC1
    _f14:0,PIV-VEN-ITEM1

    Use "T" for your FC code to inactivate the vendor item.

    Michelle




    SCMaster-jk2
    SCM Analyst
    Private
    Veteran Member
    (240 points)
    Veteran Member
    Posts:100


    Send Message:

    --
    6/23/2015 2:38 PM
    Thank you everyone for all your help. Jon's method worked perfectly!
    Stephanie
    Director
    RPI Consultants
    Veteran Member
    (246 points)
    Veteran Member
    Posts:86


    Send Message:

    --
    6/25/2015 12:31 AM
    Thanks Jon!

    SCMaster - do you know about Ctrl+Shift+V? This is a helpful tool to use when you don't always know what you are looking for.
    Stephanie Kowal | skowal@rpic.com
    SCMaster-jk2
    SCM Analyst
    Private
    Veteran Member
    (240 points)
    Veteran Member
    Posts:100


    Send Message:

    --
    6/25/2015 4:15 PM

    Oh man - that's great! I only knew about ctrl+shift+o.

    You are not authorized to post a reply.