Open Forum

Expand all | Collapse all

Remove Completed Purchase Orders

  • 1.  Remove Completed Purchase Orders

    SILVER CONTRIBUTOR
    Posted Mar 19, 2020 12:36 PM
    ​​I move completed POs to history every week.
    I use the report generated to close associated Campaigns in CRM.
    Working remotely my computer froze while printing the report and closed GP.
    Is there a way to reprint this report?
    Is the date moved to history stored in a SQL table?

    ------------------------------
    Sue Ziegler
    Mgr, Financial Systems
    Wisconsin Milk Marketing Board, Inc.
    WI
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Remove Completed Purchase Orders

    GPUG ALL STAR
    Posted Mar 19, 2020 12:39 PM
    Hi @Sue Ziegler

    In the POP30100 is a field called DEX_ROW_TS which is a timestamp of when it was added to the history table.

    See if that will work for you, its what I've used in the past to find whats moving over there.​

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

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

    Academy - Online Interactive Learning from Experts


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