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
-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 .
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:
Please never hesitate to share any further inquiries,
Mahmoud,
The query returned 0 records
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 :
Share
Report
All responses (
Answers (
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,
here's the screenshot of the payment voucher.
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,
|
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 |
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,
#1
Almas Mahfooz
3
User Group Leader
