Open Forum

Posted PR Batch to wrong period

  • 1.  Posted PR Batch to wrong period

    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

  • 2.  RE: Posted PR Batch to wrong period

    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 would think a 9/1 payroll would be for August and not September.

    Let me know of any issues.


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

  • 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
    helena MT