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.
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
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations