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

It worked. Thank you so much