Open Forum

Expand all | Collapse all

Who update the price of Items

  • 1.  Who update the price of Items

    Posted 23 days ago

    Hello Folks, I have had a couple of instances where the Item Maintenance has been updated with the wrong prices. I would like to have a way to identify who updated the item maintenance last. Does GP store somewhere when and who made the last price update? if so, in which tables are these data stored?

    Thanks in advance for your help.

    Kind regards,

    Sam Lyra



    ------------------------------
    Samuel Lyra
    Trudell Medical Limited
    London ON
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Who update the price of Items

    GPUG ALL STAR
    Posted 22 days ago
    Hi @Samuel Lyra

    GP does not be default keep track of old data. There is some audit trail capabilities in GP which can be enabled, but they will only tell you that a user saved a record and not what the data was before and after.

    I recently published free examples using GP P​ower Tools to track changes on Vendors and Customers.  This concept could be extended for Items

    https://winthropdc.wordpress.com/2021/08/20/gppt-tracking-changes-to-customer-and-vendor-cards/

    It won't go back in time for you, but could easily provide the data you want in the future

    Regards

    David

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

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

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

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Who update the price of Items

    SILVER CONTRIBUTOR
    Posted 7 days ago
    Hi Samuel,

    If you have activity tracking enabled in GP, you can use the following script:

    SELECT act.CMPNYNAM, usr.USERNAME, act.DATE1, act.TIME1, act.SECDESC,
    CASE WHEN INQYTYPE = 1 THEN 'user login failed' WHEN INQYTYPE = 2 THEN 'user logging in' WHEN INQYTYPE = 3 THEN 'user accessed form' WHEN INQYTYPE = 4 THEN 'user login denied' WHEN INQYTYPE
    = 5 THEN 'user accessed report' WHEN INQYTYPE = 6 THEN 'user denied report' WHEN INQYTYPE = 7 THEN 'user added master record' WHEN INQYTYPE = 8 THEN 'modified user master record' WHEN INQYTYPE
    = 9 THEN 'deleted user master record' WHEN INQYTYPE = 10 THEN 'user process server used' WHEN INQYTYPE = 11 THEN 'user added utility record' WHEN INQYTYPE = 12 THEN 'user accessed file maintenance'
    WHEN INQYTYPE = 13 THEN 'user file denied' WHEN INQYTYPE = 14 THEN 'user accessed routines' WHEN INQYTYPE = 15 THEN 'user logged out' WHEN INQYTYPE = 16 THEN 'user Went into modifier' WHEN
    INQYTYPE = 17 THEN 'user went into report writer' WHEN INQYTYPE = 18 THEN 'user added transaction record' WHEN INQYTYPE = 19 THEN 'user deleted transaction record' WHEN INQYTYPE = 20 THEN 'user modified transaction record'
    WHEN INQYTYPE = 21 THEN 'user added setup record' WHEN INQYTYPE = 22 THEN 'user deleted setup record' WHEN INQYTYPE = 23 THEN 'user modified setup record' END AS InqType
    FROM DYNAMICS.dbo.SY05000 AS act LEFT OUTER JOIN
    DYNAMICS.dbo.SY01400 AS usr ON usr.USERID = act.USERID
    WHERE (act.USERID LIKE '%%') AND (act.SECDESC LIKE '%item master file%')
    ORDER BY act.DATE1 DESC



    ------------------------------
    Aref Karam
    Data Consultant
    LTI Information Technology
    Ann Arbor MI
    ------------------------------

    Academy - Online Interactive Learning from Experts


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