Open Forum

Expand all | Collapse all

Deleted SOP lines

  • 1.  Deleted SOP lines

    Posted Feb 18, 2020 01:44 PM
    ​Can anyone tell me where in the database you can find deleted sales order line items or entire deleted sales orders?


    ------------------------------
    Helen McElwain
    Buyer/AR
    Yerecic Label
    New Kensington, PA
    ------------------------------


  • 2.  RE: Deleted SOP lines

    GPUG ALL STAR
    Posted Feb 19, 2020 02:40 AM
    @Helen McElwain

    Delete data is just that... Deleted.  Sorry, it will not be available anywhere in your system (other than maybe a database backup).

    If you don't want users to be able to delete sales orders, you can disable deleting or require a password to delete.  Then a transaction can only be voided. Voided transactions can be located in the history tables SOP30200 & SOP30300.

    To change the Delete Documents setting go to Sales >> Setup >> Sales Order Processing >> Sales Document Setup.

    Regards

    David


    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------



  • 3.  RE: Deleted SOP lines

    Posted Feb 19, 2020 07:17 AM

    Thanks for your help.

     






  • 4.  RE: Deleted SOP lines

    Posted Feb 19, 2020 01:17 PM

    You can also lock that down using Field Level Security.  That is what we do so the option isn't available.

    Regards,

    Greg



    ------------------------------
    Greg Ristow
    Senior ERP Administrator
    McGann and Associates
    ------------------------------



  • 5.  RE: Deleted SOP lines

    Posted Feb 19, 2020 01:55 PM

    Thanks Greg,

     

    We are not concerned with our users deleting lines or Sales Orders, we were just wondering if there is record of it anywhere in the database that we can reference so we know a line or entire order has been deleted.

     

    Helen

     






  • 6.  RE: Deleted SOP lines

    GPUG ALL STAR
    Posted Feb 19, 2020 04:21 PM
    @Helen McElwain,

    Rockton Software (there may be others) makes a nice product called "Auditor" which tracks changes to GP data. It allows you to require users to enter a note when changes are made, if you wish.

    Regards,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List as of 12-Nov-2019
    ------------------------------



  • 7.  RE: Deleted SOP lines

    GPUG ALL STAR
    Posted Feb 20, 2020 02:27 AM
    @Helen McElwain and @Steve Erbach

    GP Power Tools can also be set up to track changes to specific data fields or deletion of data and send an email, write a log entry or write to a table in SQL.

    For an example, see

    https://winthropdc.wordpress.com/2017/11/09/gppt-using-gp-power-tools-to-track-specific-changes/

    Regards

    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------



  • 8.  RE: Deleted SOP lines

    Posted Feb 21, 2020 10:48 AM

    Hi David,

     

    We are looking for an auditing solution and was not aware Winthrop provided one.  Can you tell me what the cost structure is and our management team may be interested in a demo if possible.

     

     






  • 9.  RE: Deleted SOP lines

    GPUG ALL STAR
    Posted Feb 26, 2020 01:29 AM
    @Greg Ristow

    Please note that GP Power Tools is not a specific auditing tool. It has many features for users, administrators, consultants, support staff and developers. The developer tools module can be used to perform many customisations which include tracking specific changes in the tables.  But this is only one of the almost infinite possibilities.

    I suggest that all partners and customers review the benefits presentation so you can see why every GP customer globally should have GP Power Tools: https://www.winthropdc.com/ftp/pub/GPPowerTools_Benefits.ppsx

    You can also watch the demonstration videos at https://winthropdc.wordpress.com/gp-power-tools-portal/gp-power-tools-videos/.

    To understand what is in each module look at the following posts:

    https://winthropdc.wordpress.com/2018/03/05/gppt-gp-power-tools-whats-in-each-module-series/

    https://winthropdc.wordpress.com/2016/07/05/gppt-faq-what-features-belong-to-each-gp-power-tools-module/

    All sites are going to want the Administrator Tools module. If upgrading, changing server or creating test environments I would suggest that getting the Database Tools module which includes Database Validation which can find and fix many upgrade issues before that cause problems (You should install on the pre upgrade version.). If you want the ability to actively debug, customize GP or write self-help scripts then you should also get the Developer Tools module.

    The pricing is on the website, and you can get a quote or place the order using the online form. In summary, the customer pricing for an annual subscription is US$500, US$900, US$1300 (or AU$500, AU$900, AU$1300 plus GST in Australia) for 1, 2 or 3 modules respectively. This is a per system cost and is not affected by the number of users, companies or workstations.

    Customers can also just install the code and activate a free 30 day trial period to try out all the features to help you decide on what modules you want.

    ​Regards
    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------



  • 10.  RE: Deleted SOP lines

    Posted Feb 26, 2020 10:03 AM

    Thanks David,  we will look into this.

     






  • 11.  RE: Deleted SOP lines

    Posted Feb 21, 2020 09:28 AM
    Edited by Kevin Droz Feb 21, 2020 11:05 AM
    You can the GP Audit function that will tell you that a record has been modified or deleted. It won't tell you what data was changed or deleted.

    One suggestion would be is to have your GP partner or local in house IT create a shadow table with triggers that would keep all lines and document history. We used one for PTE in Project Accounting by MS to track a few issues we had with missing data with documents being deleted during the workflow process.

    Unfortunately there is nothing out of the box to do this unless you use a 3rd party product.

    Thanks,
    Kevin

    ------------------------------
    Kevin
    ------------------------------



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