Mass Contract Status Changes

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!

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!

No problem! It is an option under special actions.

How would I access the special actions menu via add-ins to put the entire contract on hold?

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.

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.

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

Thank you everyone for all your help. Jon's method worked perfectly!

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.

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