You’re offline. This is a read only version of the page.
1,540
I found this post https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/415103/manual-payment-couldn-t-be-posted-in-gp/1157692#1157692
This just happened to us. However, the invoice is not in PM20000. It is in PM30200.
The Hist apply record is in PM30300 but is not found in GP (subledger). It is in the GL20000 and PM30600 and PM00400.
Then another payment that was actually the one processed to the vendor is in PM20000 but not applied to anything, and has a different voucher and trx source.
I restored this company into test to try some things. Nothing comes up in Checklinks. Vendor summary changed when I reconciled Vendor.
Seems like I need to get the system to think that the second payment in PM20000 is actually the payment seen n PM30300. No idea how to go about that.
Tried:
- Voided the open payment just to see what would happen -> no impact on missing doc.
- Re-entered manual payment with original voucher # but this stayed in PM20000 and could not apply to Hist invoice
- Cleared CURTRXAM from invoice in PM30200 but still could not apply payments to it (needs to be in PM20000)
Any ideas? Can I "insert into" PM30300??
I wanted to update you on the fix we did for this.
We found all the records in the following tables after finding the trx sources, vouchers, etc)
GL20000, PM20000, PM20100, PM30200, PM30600, PM30300, PM00400
1) Back-end (SQL): Update the Invoice record in Payables History Table to change the amount outstanding from $0.00 to the document amount. This is so the system thinks that document doesn't have a payment applied.
UPDATE PM30200 SET CURTRXAM=DOCAMNT WHERE DOCNUMBR='XXXXXXX' AND DEX_ROW_ID=99999
2) Back-end (SQL): Delete the corrupt payment record from Payables Apply History Table
DELETE FROM PM30300 WHERE VENDORID='THEVENDOR' AND VCHRNMBR='012345' AND DEX_ROW_ID=99998
3) GP: Use Remove Transaction History Utility in GP to remove the original invoice (be sure to insert both Doc Type and Voucher Number)
4) GP: Re-enter the Invoice and post it in GP from payables window. Delete the GL Batch that was left unposted. We don't want anything to post to the GL.
5) GP: Apply the open payment to the Invoice in GP
6) Back-end (SQL): Delete the corrupt payment distributions from Payables Distribution History table
DELETE FROM PM30600 WHERE DOCTYPE=6 AND VCHRNMBR='012345'
We also added notes to the original Journal Entries as they no longer link to anything.
Hello Barb,
Thank you for your response.
With the working from home, we did start seeing cases with network issues like this. Our systems team put out a blog on tips from working from home that you could provide your IT to take a look at the environment.
I hope this helps!
Thank you!
Brandon Jarrett | Microsoft Support Engineer
Correct...because the payment is missing, I cannot Void it. Changing CURTRXAM to 0.00 on the Invoice still does not allow me to void it.
In the Test company I will try using Remove History to get rid of the invoice and ensure the GL is updated. Then I should be able to apply the newer payment to it.
If I need a support case I would have to go thru our VAR, likely they will contact Microsoft anyway. Thank you!
P.S. It seems with so many people working remotely (close to 200 users) our data issues and GP freezing issues have compounded dramatically!
Hello Barb,
With the Invoice in history, there is not much that can be done as when a Debit Document is in history, there are only two ways to get it back to open so it can be applied against.
My interpretation of the information provided is there is either no PM30300 or the PM30300 records is for a damaged payment that you cannot see in the front end. That would leave you with the having to remove history on the Invoice using the Remove History utility. You can then make adjustments to the GL if anything posted to the GL for this invoice. Once removed, you can recreate it and apply the payment to the Invoice to move both back to history.
Note: You might need to adjust the CURTRXAMT field if it is not correct to allow you to apply to it after it is brought back to open.
If you would like to create a support case, we can review the data and use scripting to move the Invoice back to open and you can apply the payment to it as needed.
I hope this helps!
Brandon Jarrett | Microsoft Support Engineer.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (