PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/09/2020 12:59 PM by  Rani Ilapa
Mass PO20 Line Cancellation Through Add-Ins
 11 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
    (2747 points)
    Veteran Member
    Posts:939


    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
    Veteran Member
    (107 points)
    Veteran Member
    Posts:53


    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
    (2747 points)
    Veteran Member
    Posts:939


    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
    (377 points)
    Veteran Member
    Posts:165


    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
    Neil Goldstein
    Private
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    04/22/2019 10:03 AM
    Thank you so much.  We have about 4,000 lines  to cancel and this was a huge help.
    Rani Ilapa
    Sr. Business Analyst
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    12/08/2020 7:25 PM

    I am trying to use the same Query and it gives me results as Change complete.But PO line is not cancelled. Can someone assist me?

     
    Rani Ilapa
    Sr. Business Analyst
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    12/08/2020 7:34 PM

    I did not understand what is this mean " If you send a 1 to (H),_f218;0,CANCEL-XMIT-FLAG1" I see F214:0 has the Cancel-XMIT-FLAG. I really apreciate your assitance with this. Thank you 
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2747 points)
    Veteran Member
    Posts:939


    Send Message:

    --
    12/09/2020 9:18 AM
    You need a spreadsheet with the following columns:
    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)
    Depending on which version of Lawson you have you need the additional column:
    (H),_f218;0,CANCEL-XMIT-FLAG1 (just put 1 in all rows)
    Rani Ilapa
    Sr. Business Analyst
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    12/09/2020 12:59 PM

    It worked. Thank you so much
    You are not authorized to post a reply.

    Forums User Experience Lawson Add-Ins for Microsoft Office