PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/15/2019 3:38 PM by  Pdudow
Mass PO20 Line Cancellation Through Add-Ins
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
vuleab
Applications Analyst
Private
Basic Member
(13 points)
Basic Member
Posts:7


Send Message:

--
06/25/2018 12:15 PM

    Hello,

    I am trying to do an upload through add-ins to cancel PO lines in PO20.  I am getting a message "Hit change again to confirm line cancellation."  I would run change again, but the lines are still not cancelled.

    Does anyone know how to get this to work through Lawson add-ins?  I have hundreds of lines.    I am on version 10.0.7.0.

     

     

     

    Thank you!

    vuleab
    vuleab
    Applications Analyst
    Private
    Basic Member
    (13 points)
    Basic Member
    Posts:7


    Send Message:

    --
    06/25/2018 12:50 PM
    Add-ins Results from PO20.1
    Hit Change again to confirm line cancellation (_f0)

    (_f0) = (H),_f0,TC

    Looks like I have to add this column into my spreadsheet. If so, what should be the value of this hidden key?

    Thank you!
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2252 points)
    Veteran Member
    Posts:768


    Send Message:

    --
    07/09/2018 10:17 AM
    We upload Cancel PO Line with the following map to PO20.1
    f4, PCR-COMPANY (company)
    (H) f5, PCY-PROCURE-GROUP (PO Group)
    f12, PCR-PO-NUMBER (PO#)
    f14, PCR-PO-CODE (PO Code)
    f31, PT-PLI-LINE-NBR (Line Number)
    f214:0, LINE-FC1 (L for Cancel)

    Upload as Change only and then Run PO190 after to close out any headers that need it.

    NatalieD
    Analyst II, Report Writer
    Private
    Advanced Member
    (96 points)
    Advanced Member
    Posts:48


    Send Message:

    --
    08/06/2018 10:13 AM
    Kat - What result do you get on the line with the wizard you mention? I do the same wizard as change only and still get "Hit Change again to confirm line cancellation (_f0)" as the result - same as when I do a manual line cancellation.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2252 points)
    Veteran Member
    Posts:768


    Send Message:

    --
    08/07/2018 8:42 AM
    I get change complete continue. Although I don't think I get the extra popup when I manually cancel a line? We're in the middle of refreshing our test server so I can't verify. I also know there's a self contained workbook for cancel remaining available through Infor - maybe reach out to Don Petersen?
    brupp
    Mgr Supply Chain Systems
    UC Health
    Veteran Member
    (343 points)
    Veteran Member
    Posts:147


    Send Message:

    --
    11/15/2018 3:14 PM

    This is an old thread but in case anyone else runs in to this, Don Peterson was able to assist - 

    If you send a 1 to 

    (H),_f218;0,CANCEL-XMIT-FLAG1

    the line(s) will successfully cancel.
    Pdudow
    Contracts/Purchasing
    Hospital
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    01/15/2019 3:38 PM
    Thank You!  Works Perfectly
    You are not authorized to post a reply.

    Forums User Experience Lawson Add-Ins for Microsoft Office