Open Forum

Expand all | Collapse all

Table where check batch approval is

  • 1.  Table where check batch approval is

    SILVER CONTRIBUTOR
    Posted Jan 08, 2019 03:33 PM
    Good afternoon,

    Anyone know the table where the name is stored for who approved a check batch for printing?

    Thanks!!

    ------------------------------
    Angela Harris
    Territorial Financial Systems Administrator
    The Salvation Army-Central THQ
    Hoffman Estates
    ------------------------------


  • 2.  RE: Table where check batch approval is

    TOP CONTRIBUTOR
    Posted Jan 09, 2019 08:36 AM
    Hi @Angela Harris


    Try the WF30100 table - I'm not looking at a client right now that uses workflow so I can't confirm, but that is the "Workflow History" table.​​

    ------------------------------
    Kindest Regards,
    Jo deRuiter , MCP, DCP
    "That GP Red Head"
    AISLING DYNAMICS CONSULTING, LLC
    WEBSITE: https://aislingdynamics.com/
    BLOG: https://community.dynamics.com/gp/b/gplife
    GPUG Academy Instructor
    Dynamics GP Credentialing Council-Vice Chair
    770-906-4504 (Cell)

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



  • 3.  RE: Table where check batch approval is

    GPUG ALL STAR
    Posted Jan 09, 2019 11:26 AM
    Hi @Angela Harris

    It may be in the table that @Jo deRuiter ​​​mentioned.  We don't use WorkFlow so I'm not sure.  You can find it in SY00500 though; column name is: APRVLUSERID.

    ------------------------------
    Frank Heslin
    Financial Systems Administrator
    ExamWorks, Inc.
    Atlanta GA

    GPUG Advisory Committee Member
    Summit Track Leader
    GPUG All Star 2016

    GP2018
    MR CU16
    ------------------------------



  • 4.  RE: Table where check batch approval is

    SILVER CONTRIBUTOR
    Posted Jan 09, 2019 02:24 PM
    Thank you both!! I found that but also looking for historical ones as well.... fun audit request!!

    ------------------------------
    Angela Harris
    Territorial Financial Systems Administrator
    The Salvation Army-Central THQ
    Hoffman Estates
    ------------------------------



  • 5.  RE: Table where check batch approval is

    TOP CONTRIBUTOR
    Posted Jan 09, 2019 02:59 PM
    Angela, For posted AP Check batches you want the transaction batch history table for payables which is PM80100.
    It has two useful columns for auditors:
    1. USERID:  the user who posted the batch!
    2. APRVLUSERID: the user who approved the Batch if you use the feature.  Its also in SY00500 that Frank listed but only until you post. Then that SY00500 record goes away.
    So use PM80100 and display it thru Smartlist w Smartlist Builder for auditors.
    Other modules use other tables to store the APRVLUSERID.

    ------------------------------
    Thaddeus Suter
    Retus, Inc
    HELOTES TX
    ------------------------------



  • 6.  RE: Table where check batch approval is

    SILVER CONTRIBUTOR
    Posted Feb 20, 2019 01:02 PM
    I forgot to post a Thank you!! That is what I needed!!

    ------------------------------
    Angela Harris
    Territorial Financial Systems Administrator
    The Salvation Army-Central THQ
    Hoffman Estates
    ------------------------------