Open Forum

Expand all | Collapse all

Need to Void AR cash receipt transactions with future period date

  • 1.  Need to Void AR cash receipt transactions with future period date

    SILVER CONTRIBUTOR
    Posted 14 days ago
    We have a AR module cash receipt batch that was posted with a mis-keyed document date for the year 7202.  It posted to the current date 12/7/20.  I want to delete all of these transactions so they do not mess up our payment records.  I tried the normal void process, sales - posted transaction, but it will not let me void it because this fiscal year is not setup (which makes me question how the system allowed it to be posted with that date).  I tried changing the void date to match the posting date but it tells me the void date cannot be before the document date.  Anyone know how I can get right of these transactions without setting up a fiscal year for 7202? Thank You



    ------------------------------
    Susan Ferrian
    Guardian Angels of Elk River (GAER)
    Elk River MN
    ------------------------------
    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 2.  RE: Need to Void AR cash receipt transactions with future period date

    SILVER CONTRIBUTOR
    Posted 13 days ago
    Hi Susan,

    I would change the document date in SQL for these transactions to correct the issue.  If you are not familiar or comfortable with SQL, I'd recommend to contact your partner for assistance.  It should be a quick fix.

    I'd also recommend to mark the Doc Date Verify option in PSTL to help guard against this issue in the future.  It will check to make sure you are entering a year which has a fiscal period setup.



    ------------------------------
    John Kirsch
    Director of IT
    Global Optics Inc.
    Green Bay WI
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 3.  RE: Need to Void AR cash receipt transactions with future period date

    SILVER CONTRIBUTOR
    Posted 13 days ago

    Hello John,

     

    Do you know which SQL table I would use for AR?  My IT is great at helping me with SQL if I can provide him the proper tables.

     

    Susan Ferrian

    Accounting Manager

    GA Senior Services logo 2019 color_ 25496_GuardianAngels_logo_CMYK_2019

    Guardian Angels Senior Services

    508 Freeport Ave. NW, Suite A

    Elk River, MN 55330

    Direct: 763-635-5496

    Main: 763-241-4428

    www.GuardianAngelsMN.org

    facebookyoutube https://osiprodeusodcspstoa01.blob.core.windows.net/en-us/media/59621802-1076-4d8a-8ccb-e7ac4af99f1f.png

     




    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 4.  RE: Need to Void AR cash receipt transactions with future period date

    SILVER CONTRIBUTOR
    Posted 12 days ago
    Hi Susan,  the table is RM20101 for Open transactions.  I will again stress to be careful in making SQL changes if this is not familiar and try it in test first to not cause other issues.

    ------------------------------
    John Kirsch
    Director of IT
    Global Optics Inc.
    Green Bay WI
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 5.  RE: Need to Void AR cash receipt transactions with future period date

    SILVER CONTRIBUTOR
    Posted 12 days ago
    Thank you John.  We were able to find the batch and do a replacement on the date.  It worked perfectly.

    ------------------------------
    Susan Ferrian
    Guardian Angels of Elk River (GAER)
    Elk River MN
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


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