Error When Trying to use "View/Cancel Checks"

Bills / Vendors / Check Issuing / Purchase Orders / PO Processing

Error When Trying to use "View/Cancel Checks"

by isabelleslighting » Mon Apr 20, 2009 7:46 pm

Hello,

I am trying to cancel (or delete) a check entered in error. but it is not working according to the video and help document. I had a similar issue with this "void payments", but the instructions I was given by "admin" didn't work this time. Here is my issue . . .

1. I went through the path "Payables> Checks > View/Cancel Checks"
2. I choose a vendor (obviously the one I wrote the check to).
3. I click on the blue "Next" arrow.
4. The check I wrote is displayed (it happens to be an EFT payment for $27.46).
5. I check the "Void" box and the check amount ($27.46 in this case) shows below the check box.
6. I click "Save" and a pop-up window appears with the text "Are you sure you want to process the selected checks?"
7. I click the "OK" button.
8. The screen displays . . .

GL entries for this check not found.: 0

How can I fix this?

Again, thank you in advance for your time and help!
--
Tom Isabelle
Lighting Specialist
http://www.isabelleslighting.com
Bright Ideas, Brilliant Results™

isabelleslighting
 

Re: Error When Trying to use "View/Cancel Checks"

by admin » Fri Apr 24, 2009 1:23 pm

Looks like you deleted the vendor bill before voiding the check. The check needs to be voided before the bill is deleted. Fixing this now would be complicated. If you would like help with this, we can assist you for a small support fee. Please contact us at support@nolapro.com


NolaPro Support
admin Site Admin  

Re: Error When Trying to use "View/Cancel Checks"

by isabelleslighting » Fri Apr 24, 2009 6:53 pm

Hello,

Thank you for your reply. In an email you sent me already, you suggested the following (reply in bold/italics). . .

On Wed, Apr 22, 2009 at 11:40 AM, NolaPro Support Dept <support@nolapro.com> wrote:

Tom,

If you can look at the database and find the entry in arinvoicepaymentdetail for the payment you are trying to delete, you will see an entry in the table called voucherid. Then you need to go to gltransvoucher table where id=voucherid (the voucherid from the arinvoicepaymentdetail table) and change the entry called cancel to zero.

NolaPro Support


. . . since I have root access to my database, the instructions you gave me were quite straight forward. They work perfect for "ar" payments. My question, however, was regarding "ap" payments. Please review my original posting. Could you point me to the proper tables for this?

Maybe it would be helpful if the software would not allow this to have happened in the first place. Please consider for future versions.

Thank you for your assistance! I appreciate it very much!
--
Tom Isabelle
Lighting Specialist
http://www.isabelleslighting.com
Bright Ideas, Brilliant Results™

isabelleslighting
 

Re: Error When Trying to use "View/Cancel Checks"

by nww » Mon Jan 25, 2010 11:37 pm

I have the same issue with the "ap" payment side. Did you find an answer?

Thanks
nww  


Return to Payables / AP



Fatal: Not able to open ./cache/data_global.php