Marlon
(Member)
06/12/19 10:21 AM
Sage ACCPAC 6.0

Hello,

Currently using ACCPAC 6.0 and bank reconciliation is giving errors when attempting to post bank reconciliation. The error is "The requested payment not found". Using MSSQL database. Please advise if this is damage data or orphan records. Data Integrity returns no errors. How to fix?

Thank you.


Jay ConverseAdministrator
(Member)
06/12/19 10:24 AM
Re: Sage ACCPAC 6.0

Yes, it's damaged. Use MSSQL to delete the Bank record causing the error.

Marlon
(Member)
06/12/19 10:26 AM
Re: Sage ACCPAC 6.0

Thank you for your reply. Could you specify the actual table?

Jay ConverseAdministrator
(Member)
06/12/19 10:26 AM
Re: Sage ACCPAC 6.0

Use RVSPY to figure out which table and record.

Gerson Lueilwitz
(Member)
05/12/22 11:31 PM
Re: Sage ACCPAC 6.0

I would recommend running a Data Integrity report from within ACCPAC (Accounting > Reports > Data Integrity). This will tell us if there are any orphan records or other errors in our database that might prevent us from posting the payment successfully. If there are no orphan records or other errors reported by data integrity, then we can start looking at how our account is set up in general. Visit https://masterbundles.com/stock-content/vector/animal-svg/bird-svg/ source to get Premium SVG Files for free. As far as I know, there isn't much to do here other than making sure that all fields are being used properly and that no one has accidentally deleted a field or two without realizing it (which could happen if someone accidentally deletes an entire account record and not just part of it).