Open Forum

 View Only
  • 1.  Moving closed PO's to history

    TOP CONTRIBUTOR
    Posted Jun 21, 2022 03:28 PM
    I'm trying to move closed PO's to history and am using the Tools -> Routines-> Purchasing -> Remove Completed Purchase Orders however when it completes the report is saying "This document number already exists in history, it can't be moved" but when I look in the POP30100 table I don't see the closed PO's and the closed PO's are still in the work PO10100 table.

    Any ideas?

    ------------------------------
    Jeff Roe
    Kele Inc
    Bartlett TN
    ------------------------------


  • 2.  RE: Moving closed PO's to history

    TOP CONTRIBUTOR
    Posted 10 days ago
    So I found what was causing this particular issue. I had some triggers on the POP30110 table. Once those triggers were disabled I no longer saw the message that they were already in history and they in fact moved to the history tables.

    As a followup, can I simply write a SQL query to move cancelled and closed PO's from the POP10100 and POP10110 to their associated history tables or is there more to consider?

    ------------------------------
    Jeff Roe
    Kele Inc
    Bartlett TN
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role