Troubleshooting:Delete AP Payment error - This document was posted from A/P Payment, you must go A/P Payment to delete it

From AutoCount Resource Center
Revision as of 08:23, 20 February 2020 by LaySwan (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Question: Error message prompted out ‘This document was posted from A/P Payment, you must go A/P Payment to delete it’ when deleting an AR Payment? What can’t I delete an AR Payment?

Version: 1.8

Pymt disc cn1.png

Possible Reason:

When knocked off Purchase Invoice or Debit Note, you have keyed in discount amount for a particular Purchase Invoice or Debit Note (Refer to Image 1). System will auto create CN to Knock off the Purchase Invoice or Debit Note that posted from A/P Payment (Refer to Image 2). Thus, you couldn’t delete the A/P Payment as it is linked to an APCN.

Pymt disc cn2.png

Image 1

Pymt disc cn3.png

Image 2


Note: If you are customer, please refer to your dealer.

1. BACKUP the account book.

2. Install SQL management studio or login to AutoCount SQL Management Studio.

3. Run the query as below to find out which CN no is linked with this A/P Payment:

Select * From APPayment Where DocNo='PV-00001'

note that pv-00001 is the document number.

4. From the result, you can check which CN the PV is referred to.

Pymt disc cn4.png

5. From the screenshot above, it shows that there is an CN linked with this AP Payment because it has ReferCNDocKey, ReferCNDocDate and ReferCNDocNo

Pymt disc cn5.png

5. Run the query below to clear the linkage between A/P Payment and CN:

Update APPayment set ReferCDocKey=, ReferCNDocDate=,ReferCNDocNo= Where DocNo='PV-00001'

6. After run the query, you may delete the related AP Payment & CN.

By: Hui Yan 180413, KM 80416, P180427

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