Open Forum

Expand all | Collapse all

Moving PO BACK from History

  • 1.  Moving PO BACK from History

    GPUG ALL STAR
    Posted Mar 23, 2020 12:57 PM
    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
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Moving PO BACK from History

    GPUG ALL STAR
    Posted Mar 23, 2020 01:06 PM
    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



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

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

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Moving PO BACK from History

    TOP CONTRIBUTOR
    Posted Mar 31, 2020 10:29 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


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