Open Forum

Expand all | Collapse all

GL Batch Update by SQL

  • 1.  GL Batch Update by SQL

    Posted Feb 11, 2020 01:51 PM
    ​​Hi All,
    I created a batch in GP saying "Batch101" By going through Transaction> Finance> Batches> Batch Entry.
    I need to reassign many JEs to Batch101. I updated BACHNUMB for "Batch1010" in GL10000 & GL10001 via SQL.
    The table s showed the BACHNUMB got updated, but I did not see any JES in the Batch101, I did see the JE has reassigned to Batch101.

    Please advise how to see the JEs in the "Batch101"

    ------------------------------
    Jerry Hing
    Pennymac
    Los Angeles CA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: GL Batch Update by SQL

    TOP CONTRIBUTOR
    Posted Feb 11, 2020 02:27 PM
    Hi Jerry,

    See if running the GL Reconcile for "Batch" will fix it for you...



    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: GL Batch Update by SQL

    GPUG ALL STAR
    Posted Feb 12, 2020 07:42 AM
    Hi @Jerry Hing

    Also, where are you LOOKING to see JEs in Batch 101?

    Essentially, GP holds on to Summary Batch data, like number of transactions and total of the batch in the table SY00500 in each of the separate databases.

    Running the reconcile as @Gerald Buenafe recommends is the best way to update the summary table, but if you want to SEE the summary pull up the batch in the SY00500​​​ table.  I IS possible to also "update" this table, but again, I would recommend the GL Reconcile above manually manipulating the table - its also much easier and more accurate than manual manipulation!

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

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

    Academy - Online Interactive Learning from Experts


  • 4.  RE: GL Batch Update by SQL

    Posted Feb 18, 2020 05:03 PM
    ​Hi Gerald and Jo,

    Thank you very much for your reply. It works. Appreciate that a lot.

    Jerry Hing

    ------------------------------
    Jerry Hing
    Pennymac
    Los Angeles CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


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