• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Mass PO20 Line Cancellation Through Add-Ins

 11 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
vuleab
Basic Member
Posts: 7
Basic Member
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

vuleab
Basic Member
Posts: 7
Basic Member
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
Veteran Member
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
Veteran Member
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
Veteran Member
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
Veteran Member
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
Basic Member
1/15/2019 8:38 PM
Thank You!  Works Perfectly
NeilG
Basic Member
Posts: 7
Basic Member
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
Basic Member
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
Basic Member
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
Veteran Member
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
Basic Member
12/9/2020 5:59 PM

It worked. Thank you so much