Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#54013 - 06/12/19 10:21 AM Sage ACCPAC 6.0
Marlon
Member


Registered: 09/10/11
Posts: 18
Loc: Miami, Fl
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.

Top
#54014 - 06/12/19 10:24 AM Re: Sage ACCPAC 6.0 [Re: Marlon]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7792
Loc: Location, Location
Yes, it's damaged. Use MSSQL to delete the Bank record causing the error.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#54015 - 06/12/19 10:26 AM Re: Sage ACCPAC 6.0 [Re: Jay Converse]
Marlon
Member


Registered: 09/10/11
Posts: 18
Loc: Miami, Fl
Thank you for your reply. Could you specify the actual table?
Top
#54016 - 06/12/19 10:26 AM Re: Sage ACCPAC 6.0 [Re: Marlon]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7792
Loc: Location, Location
Use RVSPY to figure out which table and record.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#55198 - 05/12/22 11:31 PM Re: Sage ACCPAC 6.0 [Re: Jay Converse]
Gerson Lueilwitz
Member


Registered: 04/07/22
Posts: 2
Loc: United States
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).
Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: