1 Reply Latest reply on May 24, 2011 3:16 PM by Sandeep Gandhi, Consultant

    Archive details for purchase order

    828602
      Hi,
      We have the requirement as below -
      1. The Purchase orders(70 in number) are cancelled by ASCP plan run and the line quantities have become 0 for those lines with closed_reason as 'Close status rolled up'.
      2. Now business wants to reinstate them.


      Need to know :
      1. from where we can get the old line quantities for these purchase orders.
      2. Is there any place from where we can get the archive data for purchase orders.

      Regards.
        • 1. Re: Archive details for purchase order
          Sandeep Gandhi, Consultant
          You cannot un-cancel a PO.
          But you can find the old quantity from po_line_locations_all table's cancelled_quantity column.
          And then create a new PO.

          Depending on your setup for PO archiving, you will be able to find the old data in the following tables
          po_line_locations_Archive_all
          po_lines_archive_all
          po_headers_archive_all

          Hope this helps,
          Sandeep Gandhi