Payables- Void a $0 Payment on Invoice

(0) Share

Report

Posted on by Community Member

We have an invoice which somehow ended up with a $0 payment fully applied to it. The payment is in history but does not appear in the Void Historical Payables Transactions. Any Ideas how to resolve this?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Mahmoud Saadi 32,738 on at

Like (0)

Report
Would you please run the following queries and provide the set of results ?

SELECT VCHRNMBR , VENDORID , DOCTYPE , DOCDATE , DOCAMNT , CURTRXAM , VOIDED FROM PM30200 WHERE VCHRNMBR = 'VoucherNumber' SELECT VENDORID , DOCDATE , VCHRNMBR , DOCTYPE , APFRDCNM , APTODCNM FROM PM30300 WHERE VCHRNMBR = '#VoucherNumber'

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

VCHRNMBR
VENDORID DOCTYPE DOCDATE DOCAMNT CURTRXAM VOIDED

57256 TW29383-LA      6 9/3/2014 2800.33 0 0

57256 WHITFIELD       1 11/2/2014 1755 0
0

Query 2

VENDORID DOCDATE VCHRNMBR DOCTYPE APFRDCNM APTODCNM

TW29383-LA      9/3/2014 57256 6 184195 844830322229384 5/8

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Ken

Where is the zero payment ! The payment number is (57256) for the vendor (TW29383-LA), the apply record seems corrupted which amount is (187195) while the payment amount is (2800.33).

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

here's the screenshot of the payment voucher.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
Apparently, there is some sort of corruption occurred which resulted with such data deformation. There is no apply record for the invoice. I just want to make sure that there is no records for the invoice in the open table, would you run the below query :

USE TWO SELECT VCHRNMBR , DOCNUMBR, VENDORID , DOCTYPE , DOCDATE , DOCAMNT , CURTRXAM , VOIDED FROM dbo.PM20000 WHERE VCHRNMBR = '#VoucherNumber'

Does it return any values ?
Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Mahmoud,

The query returned 0 records

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Okay Ken, we are clear then

There is some sort of posting corruption which resulted in moving the AP transaction from the open file to the history file (as it was supposed to be applied). Although, the invoice has no apply records and the amount remaining should be same as the document amount.

In such a case, I usually consider database correction in order to get records properly recorded as it was supposed to. If you don't have the proper technical expertise in manipulating records with SQL Management Studio, you need to definitely consult your partner. Otherwise, here is the correction criteria to consider:

Move the invoice record from the history table to the open table

update the current transaction amount to be the same as the document amount

Please never hesitate to share any further inquiries,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

-Update

We resolved the issue by removing transaction history for the $0 payment voucher . Microsoft Dynamics GP>>Utilities>>Purchasing>>Remove Transaction History

we then created a Manual GL entry to back out the for the distributions that were posted to the GL .

Was this reply helpful? Yes No