Troubleshooting: Drill down from Ledger error – ARPayment record not found (DocKey=xxx)

Question: ARPayment record not found error when I double click to drill down into AR payment document. I cannot find this document number in Cash Book entry and A/R Receive Payment. Why?

Version: 1.8 / 1.9 / 2.0

Possible Reason :

The document in Cash Book and AR Payment table was deleted from the database during repair database, but the account posting to GL remained in GLDTL table, so when you view Ledger the record is still there.

Solution :

1) Do backup and request all other users to logout the account book.

2) Login to AutoCount Accounting Management Studio, go to Data Consistency > Rebuild GL Transactions, click on Start Rebuild. This function will rebuild the GLDTL and PBALANCE table from Cash Book Entry, Journal Entry, and A/R and A/P documents.

3) After rebuild is done, the records should no longer shown in the Ledger.

4) Please check the Trial Balance, P&L and Balance Sheet report as rebuild may cause changes to account posting if the setting for posting is changed.

By : Zhi Xuan 210406, Lay Swan 210422, P210426

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations