Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

sans2174

MIS
Feb 27, 2018
7
US
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,
 
 https://files.engineering.com/getfile.aspx?folder=7b0c4ba5-f252-4f6c-8d71-c551b804d67f&file=ApBalance.docx
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:

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

Part and Inventory Search

Sponsor

Back
Top