Open Forum

Expand all | Collapse all

Remove Completed Purchase Orders

  • 1.  Remove Completed Purchase Orders

    Posted 21 days ago
    ​​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
    ------------------------------


  • 2.  RE: Remove Completed Purchase Orders

    GPUG ALL STAR
    Posted 21 days ago
    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.​

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

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



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