Open Forum

Expand all | Collapse all

Moving PO BACK from History

  • 1.  Moving PO BACK from History

    GPUG ALL STAR
    Posted 17 days ago
    We ran the routine to move completed purchase orders to history.

    We need to reopen some POs (put into status=change order; add some new lines; etc.)

    Can this be done? Move a PO from 'History' back to an 'Open' status?

    Thanks,
    Kyle

    ------------------------------
    Kyle Malone, CPA
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger - https://alacarteGP.com
    Chapter Leader - Louisiana (New Orleans)
    Solugence | Find the software that FITS your business + integrates with GP. Find Software Smarter. https://solugence.com
    ------------------------------


  • 2.  RE: Moving PO BACK from History

    GPUG ALL STAR
    Posted 17 days ago
    Hi @Kyle Malone, CPA

    Hey!  Haven't talked to you in a while!

    There is no way, I know of, to move PO's back from history.

    HOWEVER!  thinking outside the box, you can use the "Copy PO" Functionality to copy the line information from old PO's to a new one​, then change the PO Number.  (Copy PO's from the "Activity" Drop down.  Just have to fill out the header of the PO before you use the Copy functionality



    ------------------------------

    ------------------------------



  • 3.  RE: Moving PO BACK from History

    TOP CONTRIBUTOR
    Posted 9 days ago
    The history and regular PO tables are very similar, it should not be that difficult to write a SQL query to move an historical PO back to OPEN.

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Paradise GP Consulting, Inc.
    Sunrise FL
    ------------------------------



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