Troubleshooting: Year End error - ARCN record not found

From AutoCount Resource Center
Jump to navigation Jump to search

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?


Arcn nf1.png


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.


Arcn nf2.png


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

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations