Open Forum

Posted PR Batch to wrong period

  • 1.  Posted PR Batch to wrong period

    SILVER CONTRIBUTOR
    Posted Sep 18, 2020 01:41 PM
    We process payroll using the PR module of SL.  When our Controller released our 9/1/2020 PR batch, he accidently posted it to August instead of Sept.  What is the best way to correct this?  I have some experience with updating fields using SQL but not sure what tables to update or if that is the best method to correct.  Thank you for your help!

    ------------------------------
    Corrie Kumbalek
    Senior Accountant
    KBA, Inc.
    Bellevue WA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Posted PR Batch to wrong period

    TOP CONTRIBUTOR
    Posted Sep 21, 2020 08:36 AM
    Good morning Corrie,

    I would highly recommend not trying to update the tables in SQL....too many tables to update.....there is a 3rd party that would fix period to post issues but below is a "free" trick.....

    The easiest way is to do the following:
    • Go to Initialize Mode
    • Open Journal Transactions
    • In upper left corner, change the Module dropdown to PR
    • Find the PR batch - should be either the top 1 or one of the top ones
    • Copy the transactions into a  new JE screen
    • Save the JE
    • Close Journal Transactions
    • Get out of Initialize Mode
    • Open your JE - make it an auto reverse JE, set the period to post to 08 and release.

    On a side note - don't often see paying in advance vs arrears.....one would think a 9/1 payroll would be for August and not September.

    Let me know of any issues.

    Thanks,
    Michael

    ------------------------------
    Michael O'Neill
    Director of Finance
    Eastex Telephone Cooperative
    Henderson TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Posted PR Batch to wrong period

    Posted Sep 21, 2020 01:40 PM
    If you don't reverse your debits and credits for the August entry, you will double up the entry in August.

    ------------------------------
    Tony Murnion
    Senior SL Consultant
    Velosio
    helena MT
    ------------------------------

    Academy - Online Interactive Learning from Experts