Orphaned Payment Correction

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

Orphaned Payment Correction

by gordon1986 » Wed Mar 18, 2009 4:10 pm

We have 2 EFT payments in 2 bank accounts that have no journal entries (long story, but it has to do with a lot of adding/deleting to try to fix a problem made in entering a bill paid by credit card). This is causing 3 problems:

1) Both of these show up in the Bank Reconciliation, and if we select them, it changes the bank balances.

2) One of the payments is showing up as an AP check #0 (EFT) that is not applied to anything. It would be nice to delete this.

3) One of the payments is applied to the credit card bill as a partial payment, but the bill is in reality fully paid as far as the credit card company is concerned. Specifically, the Bill is for $4003.77 and the payment is for $4000, showing a net due of $3.77. The credit card company has received the $4003.77, via a direct payment from another credit card. If I could delete these EFT payments, I can correct the related bills and get the system balanced again. But since these payments have no journal entries, we cannot find a way to get rid of them, or to unapply the payment from the bill.

Please HELP!!!!
gordon1986  

Re: Orphaned Payment Correction

by admin » Tue Mar 24, 2009 8:57 am

EFT payments can be voided at Payables>Checks>View/Cancel Checks.

NolaPro Support
admin Site Admin  

Re: Orphaned Payment Correction

by gordon1986 » Fri Apr 17, 2009 3:22 am

These cannot be voided because they have no entries!!!!
GH
gordon1986  

Re: Orphaned Payment Correction

by isabelleslighting » Sat Apr 25, 2009 9:50 am

Hi 'gordon1986',

It appears you and I have run into a similar issue (read my posting under "Payables / AP", titled 'Error When Trying to use 'View/Cancel Checks'"). It seems that Nolapro has a slight flaw in their software. If Nolapro's 'admin' could fix this in a preceding software revision, we would not longer be able to have this problem.

In the mean time, I hope that Nolapro's 'admin' will post a reply to either of us, for all to view with details on how to fix the error. If you have root access (like myself) 'm sure it's as simple as modifying something in the mySQL database.

Stay tuned!
--
Tom Isabelle
Lighting Specialist
http://www.isabelleslighting.com
Bright Ideas, Brilliant Results™

isabelleslighting
 

Re: Orphaned Payment Correction

by gordon1986 » Sat Apr 25, 2009 10:04 am

I agree, it is just a matter of knowing what to change in the SQL tables. We are hesitant to try to figure out what to change ourselves, since we don't know the table relationships and what a change might make worse!
GH
gordon1986  


Return to Payables / AP



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