Views:

If you have a check in AP that is cleared with a C status, you can unclear the check in SQL Server Management Studio.  You can contact support to assist with the below queries.

Note: As a precaution, confirm backups of your SL databases exist before proceeding.

select * from apdoc where refnbr = 'XXXXXXX' 

Note:  Put the AP check number within the single quotes in place of the XXXXXX.  Run the query and check that the status is a C in apdoc.  If so, you can run these queries.

update apdoc set status = 'O' where refnbr = 'XXXXXXX'

update apdoc set cleardate = ''where refnbr = 'XXXXXXX'

update apdoc set clearamt = '0' where refnbr = 'XXXXXXX'

If you clear checks in AP Check Reconciliation, you may also need to delete an aptran record with a drcr of R

Delete from aptran where drcr = 'R' and refnbr = 'XXXXXX' and vendid = 'XXXXXXX'

 

Keywords: unclear,check,cleared,status,accounts payable,vendor