Open Forum

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
------------------------------

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
------------------------------

Original Message:
Sent: Jan 06, 2021 05:46 PM
From: Susan Ferrian
Subject: Need to Void AR cash receipt transactions with future period date

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
------------------------------

Original Message:
Sent: 1/7/2021 9:13:00 AM
From: John Kirsch
Subject: RE: Need to Void AR cash receipt transactions with future period date

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
------------------------------

Original Message:
Sent: Jan 06, 2021 05:46 PM
From: Susan Ferrian
Subject: Need to Void AR cash receipt transactions with future period date

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
------------------------------

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
------------------------------

Original Message:
Sent: Jan 07, 2021 09:51 AM
From: Susan Ferrian
Subject: Need to Void AR cash receipt transactions with future period date

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

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

 

 

Original Message:
Sent: 1/7/2021 9:13:00 AM
From: John Kirsch
Subject: RE: Need to Void AR cash receipt transactions with future period date

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

Original Message:
Sent: Jan 06, 2021 05:46 PM
From: Susan Ferrian
Subject: Need to Void AR cash receipt transactions with future period date

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
------------------------------

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
------------------------------

Original Message:
Sent: Jan 08, 2021 08:46 AM
From: John Kirsch
Subject: Need to Void AR cash receipt transactions with future period date

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

Original Message:
Sent: Jan 07, 2021 09:51 AM
From: Susan Ferrian
Subject: Need to Void AR cash receipt transactions with future period date

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

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

 

 

Original Message:
Sent: 1/7/2021 9:13:00 AM
From: John Kirsch
Subject: RE: Need to Void AR cash receipt transactions with future period date

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

Original Message:
Sent: Jan 06, 2021 05:46 PM
From: Susan Ferrian
Subject: Need to Void AR cash receipt transactions with future period date

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
------------------------------