9 Replies Latest reply on Oct 26, 2010 6:34 AM by 808201

    PO line cancellation issue

    643952
      12.0.6

      there is a requisition line of 500 autocreated into a PO line of 500

      300 have been receiveed and that its decided that balance 200 is not needed any more from this supplier

      thereby the quantity of 200 is needed back in the auto create pool to make another PO with the desired supplier

      to achieve this, what we did was we cancelled that partially received PO line, and this way the balance quantity to be received was cancelled i.e 200 and it went back to the autocreate pool from where we achieved the functionality

      but the problem lie here, the 300 that was received, it was found out later that 100 from them have to be returned to supplier due to bad quality or any xyz reason, now any returns or corrections are not happening, it says invalid PO number which i think is because of the cancellation of the line which we did to bring the 200 to the auto create pool

      Please dvice with any suggestions or work arounds


      Thanks
      emm
        • 1. Re: PO line cancellation issue
          Sandeep Gandhi, Consultant
          I am surprised you were able to cancel the partially received line.
          Oracle does not let you do that.
          Did you cancel from the backend?
          • 2. Re: PO line cancellation issue
            643952
            I am surprised you were able to cancel the partially received line.
            Oracle does not let you do that.
            That is possible
            Did you cancel from the backend?
            no..not from backend
            fromt front end by using control actions

            The line of 500, which is recvd 300 and than if you cancel the line, only the balance quantity of 200 gets cancelled thought the line is marked as cancelled
            but if you query the line > shipments, it shows quantity orders 500, quantity rcvd 300 and quantity cancelled 200

            what workaround would you suggest to perform my case
            • 3. Re: PO line cancellation issue
              Sandeep Gandhi, Consultant
              You are pretty much out of luck.
              You may have to do a misc. txn to issue the inventory out.
              I assume you have not received/paid the invoice.
              • 4. Re: PO line cancellation issue
                643952
                Sandeep

                now the question is
                if a similar case comes again

                that is

                a 2000 unit PO line has been made from a requisiton line of 2000 units

                1800 have been received via PO receipt..now the balance 200 , we dont want to get it..how we cancel it in such a way that 200 requisition line comes back in the autocreate pool

                in Purchasing Options which are set at OU level, we have set cancel requisitions to 'NEVER'
                • 5. Re: PO line cancellation issue
                  Sandeep Gandhi, Consultant
                  Why cancel the line?
                  You should reduce the quantity on the po line.

                  Hope this helps
                  Sandeep Gandhi
                  Omkar Technologies Inc.
                  Independent Techno-functional Consultant
                  513-325-9026
                  • 6. Re: PO line cancellation issue
                    643952
                    a 2000 unit PO line has been made from a requisiton line of 2000 units

                    1800 have been received via PO receipt..now the balance 200 , we dont want to get it..how we cancel it in such a way that 200 requisition line comes back in the autocreate pool

                    in Purchasing Options which are set at OU level, we have set cancel requisitions to 'NEVER'




                    if i reduce the quantity on PO line from 2000 to 1800, the 200 reduced wont show up in the requisition pool autocreate window.

                    This is the problem
                    • 7. Re: PO line cancellation issue
                      719560
                      Hi emm, do u have any solution now? I encountered a similar problem.

                      Thanks,
                      Henry
                      • 8. Re: PO line cancellation issue
                        643952
                        what is the problem that you encountered

                        i found out many work arounds for it
                        • 9. Re: PO line cancellation issue
                          808201
                          Hi All,

                          This is one of the frequent issue faced by us.canceled and finally closed lines needs to be reopened to return to vendor

                          we have developed uncancellation and unclosed program to resolve the above issues

                          here i am attaching a sample script considering PO line is canceled with out receiving


                          --------------------uncancellation for lines--------------
                          UPDATE PO_LINES_ALL
                          SET CANCEL_FLAG='N',
                          QUANTITY=&cancelled_quantity,
                          CANCELLED_BY=null,
                          CANCEL_DATE=null,
                          CANCEL_REASON=null
                          WHERE po_line_id=&po_line_id
                          ------------------------uncancellation for shipment------------------
                          Update po_line_locations_all
                          set QUANTITY_CANCELLED=0,
                          CANCEL_FLAG='N',
                          CANCELLED_BY=null,
                          CANCEL_DATE=null,
                          CANCEL_REASON=null
                          where LINE_LOCATION_ID=&LINE_LOCATION_ID

                          -----------------uncancellation for distributions-------------------
                          Update po_distributions_all
                          set QUANTITY_CANCELLED=0,
                          GL_CANCELLED_DATE=null
                          where LINE_LOCATION_ID=&LINE_LOCATION_ID

                          Hope this helps
                          Thanks&Regards,
                          Syam