3,795
There is an Invoice with HISTORY status, unapplied amount=0 has been applied with a payment voucher. But the voucher has already missing.
In other words, there is an invoice (History) has applied information but the payment voucher is lost.
http://img199.imageshack.us/img199/3610/20100621204000.png
How do can I get back the payment voucher. Many thanks in advance.
*This post is locked for comments
Hi, Ian,
Many Thanks for your reply. About both SQL queries, they do not any records.
Select * from PM30300 where APTVCHNM = 'HPV09/12/154'
SELECT * FROM PM30200 WHERE VENDORID = 'VSKL10001' AND VCHRNMBR = 'HPV09/12/154'
What happens if you run:
SELECT * FROM PM30200 WHERE VENDORID = 'VSKL10001' AND VCHRNMBR = 'HPV09/12/154'
You could also look in the PM30300 (apply to history table)...
Select * from PM30300 where APTVCHNM = ''HPV09/12/154'
Ian
Hi, Ian,
Many thank your reply. The result for the SQL query is no record found. Or even if I run the below query is also no return result.
SELECT * FROM PM30200 WHERE LEN(DOCNUMBR) < 1
if I run the below SQL query and the result is in the link below.
SELECT * FROM PM30200 WHERE VENDORID = 'VSKL10001' AND DOCNUMBR ='MPRO/09/09'
http://img690.imageshack.us/img690/3500/20100623184850.png (the output is arranged vertically for easy image viewing)
Hi William,
This looks like a case of data corruption. Can you run the following query in MSSQL:
SELECT * FROM PM30200 WHERE DOCNUMBR = ''
(The '' at the end is two apostophes, and not a double quotation mark).
See what results you get.
Ian.
Hi Ian,
Many thanks again for your reply and info.
The said payment transaction was unable to found in GP and the same voucher number is allow for "re-use".
FYI, no import is used so far and no third party products was integrated. You can refer to my first post which the screen shots required was attached.
And, I have included another screenshot for your reference, http://img534.imageshack.us/img534/7759/20100623123224.png
Please advise and many thanks in advance.
Hi William,
When I said re-create the payment, I meant recreating it directly in the tables using a SQL Query...this would be a possible solution if the payment was erroneously deleted from the tables in some way.
Are you sure that the payment was ever posted? If GP is letting you enter the same document number, then possibly the payment was never posted? Could the Invoice have been matched to a Credit Type document? Can you post a screen shot of the Document in Payables management enquiry...and a screen shot of its apply record?
How was the data input into GP...was it imported in some way? It could be that the Apply data for the invoice was imported incorrectly?...ie showing that it is applied, but maybe the corresponding record was not imported.
Have you any third party products integrating into the PM system.
Best regards,
Ian.
The missing payment number cannot be found in the Chequebook Register Inquiry, so I cannot drill back to original payment transaction also.
Do you mean i need to create a new payment trasaction for the missing payment voucher? Hmmm... when i create a manual payment with the same voucher number and GP do not prompted me about this number is already used.
May be I will just re-create a payment, but my next worry is the effects of this re-create, for example the checkbook account and Cash Account -- may get double updates (one is for the missing payment, and one is for the re-create payment).
Please advise and many thanks in advance.
HI, if the payment voucher is missing, you can't get it back, as such. You could try re-creating the payment transaction in the relevant tables. If you know the payment number, have a look in your cheque book (enquiry >> Financial >>chequebook register) - if its here, can you drill back to the original transaction?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (