Account Payable-One of the invoice paid still shows as unpaid

[sans2174]

Hi,
We use Macola Progression 7.8.200.Last month our AP clerk posted a batch of manual checks, everything was paid off. Recently, she noticed one of the invoice for one vendor says it's still open, but actually it has been paid already. Now when she attempts to pay it says Amount is greater than Invoice balance as seen in the attachment.
Will appreciate if anybody can advise what needs to be done or which table we may have to check to fix this issue.
Thank you,

 

[dgillz]

If it really has been paid, have manual checks been posted? This is a different menu option than posting computer checks.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[sans2174]

The check was stuck in APADJTRX_SQL table, once we delete that and reprocessed it. It went through fine.. Dgillz, thanks for your help..