Mass PO20 Line Cancellation Through Add-Ins

vuleab

Basic Member

Posts: 7

6/25/2018 4: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

Basic Member

Posts: 7

6/25/2018 4: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

Veteran Member

Posts: 1020

7/9/2018 2:17 PM

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

Veteran Member

Posts: 53

8/6/2018 2:13 PM

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

Veteran Member

Posts: 1020

8/7/2018 12:42 PM

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

Veteran Member

Posts: 165

11/15/2018 8: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

Basic Member

Posts: 4

1/15/2019 8:38 PM

Thank You! Works Perfectly

NeilG

Basic Member

Posts: 7

4/22/2019 2:03 PM

Thank you so much. We have about 4,000 lines to cancel and this was a huge help.

Rani Ilapa

Basic Member

Posts: 5

12/9/2020 12:25 AM

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

Basic Member

Posts: 5

12/9/2020 12:34 AM

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

Veteran Member

Posts: 1020

12/9/2020 2:18 PM

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

Basic Member

Posts: 5

12/9/2020 5:59 PM

It worked. Thank you so much