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