Troubleshooting: Delete A/P Invoice Error - Unable to delete the document as it has been processed by payment voucher with imported goods

From AutoCount Resource Center
Jump to navigation Jump to search

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?


Delete ap inv IG1.png


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.


Delete ap inv IG2.png

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.


Delete ap inv IG3.png


From the result, find out the doc key of the ap invoice.

From here, the doc key is 6102


Delete ap inv IG4.png



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.


Delete ap inv IG5.png


Now, find the Dtl key of the doc key.

From here the Dtl key is 6103.


Delete ap inv IG6.png


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.


Delete ap inv IG9.png


Now find the doc key.

From here the doc key is 6104.


Delete ap inv IG7.png


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.


Delete ap inv IG10.png


From the result, you can check the document number of payment voucher.


Delete ap inv IG11.png


vi. Now, you can go to AutoCount Accounting, go to GL > Cash Book Entry and check the payment voucher.


Delete ap inv IG12.png


By: Hui Yan, 180507, KM 180515, P180522



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