Troubleshooting: Year End error - ARCN record not found

Question: I'm doing year end processing for year 2016 account, an error message prompted: ARCN record not found (DocKey=13). What should I do?

Version: 1.8 / 1.9 / 2.0

Possible Reason:

Most probably you have allowed a discount in AR Payment while knocking off an invoice, a CN was then created automatically to record the discount given; and this CN has been somehow deleted, thus, AR Payment couldn't find the related CN.

Solution

1. Go to Microsoft SQL Management Studio, run the query as below to clear the linkage between the AR Payment & AR CN.

Step 1: Find out the AR Payment

Select * from ARPayment where ReferCNDocKey = '13'

Step 2: Clear the linkage for AR CN

update arpayment set ReferCNDocKey=NULL, ReferCNDocDate=NULL,ReferCNDocNo=NULL,ReferCNReason=NULL where docno='Doc. Number'

Proceed to perform year end closing after run the above query.

2. Delete the AR Payment and create a new AR Payment if GST have not been processed for that particular month.

Note: Please backup your account book Before doing any update on the query. Contact your dealer if there is any doubt on the query.

By: CK 170815, KM 170815, P170816

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