Troubleshooting: Delete A/P Invoice Error - Unable to delete the document as it has been processed by payment voucher with imported goods
Question: I want to delete an AP Invoice (Document number: PI-000063). But it shows this error when I delete the AP Invoice (Unable to delete the document as it has been processed by payment voucher with imported goods). What does this error mean? What should I do?
Version: 1.8 / 1.9 / 2.0
Possible Reason:
This A/P Invoice has been already processed as imported good document (using tax code IM-GDS). It is not proper to simply delete this A/P Invoice as it was tied to a payment voucher when Imported Goods Document button was used.
Solution:
You will need to delete the Payment Voucher before deleting the A/P Invoice. However, this action is applicable only before GST is submitted for that particular taxable period.
To know an AP Invoice is tied to which payment voucher, use the following method:
Note: For users, please seek assistance from your software dealer to run the following method.
i. Log in AutoCount Management Studio.
ii. First, Check the document key of the AP Invoice.
Run the query below:
Select * from apinvoice Where docno = 'PI-000063'
PI-000063 is the document number of AP Invoice.
From the result, find out the doc key of the ap invoice.
From here, the doc key is 6102
iii. Next, find out the detail key of 6102.
Run the query below:
select * from apinvoicedtl where dockey = '6102'
6102 is the doc key that we found out in step ii.
Now, find the Dtl key of the doc key.
From here the Dtl key is 6103.
iv. Next, after finding out the detail key, find out the document key in cash book detail table.
Run the query below:
Select * from cbigdtl where sourcedtlkey in ('6103')
6103 is the dtl key that we found in step iii.
Now find the doc key.
From here the doc key is 6104.
v. Then, find out the document number of the payment voucher by using the document key that we found in cash book detail table.
Run the query below:
select * from cb where dockey = '6104'
6104 is the doc key that we found in step iv.
From the result, you can check the document number of payment voucher.
vi. Now, you can go to AutoCount Accounting, go to GL > Cash Book Entry and check the payment voucher.
By: Hui Yan, 180507, KM 180515, P180522
|
AutoCount Accounting 2.0 & 2.1
|
|
AutoCount Accounting 1.8 / 1.9
|
|
AutoCount Payroll
|
|
AutoCount POS
|
|
AutoCount On The Go
|
|
AutoCount Accounting Plug-In Documentations
|