Microsoft Dynamics GP (Archived)

Payment not found in GP

(0) Share

Report

Posted on by NHI

1,600

Hi folks,

Could you please advise me on this issue?

I applied a payment (PYMNT000000003627) to invoice DI-002450 and the transaction got locked before I posted. I logged out from GP & re-logged in, now , I am somehow unable to see the payment that I chose to apply before. I have tried to enter the same payment number in the Cash REceipts Entry at it said "You cannot display the record while another user is editing it".

I cannot find it in backend too.

Thank you in advance for your suggestion.

*This post is locked for comments

All responses (11)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Payment not found in GP

Hi Nhi,

I'm glad it all worked out.

Kind regards,

Leh
NHI 1,600 on at

Like (0)

Report

RE: Payment not found in GP

Hi Leh,

I ran Checklinks after running the scipts and it works. Thank you so much for all of your help.

Regards,
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Payment not found in GP

Ask everyone to log off from Dynamics GP (if you can perform a quick backup of the both DYNAMICS and the company database, I highly recommend it).

Delete the record from the RM00401.

delete RM00401 where DOCNUMBR = 'your payment number'

Verify the SY00500 for any record that has the User ID as the BACHNUMB and the BCHSOURC as RM_Cash.

select * from SY00500 where BACHNUMB = 'userid' and BCHSOURC = 'RM_Cash'

If the above SQL query returns one record, delete that record.

delete SY00500 where BACHNUMB = 'userid' and BCHSOURC = 'RM_Cash'

Check the RM Cash Receipts Work File:

select * from RM10201 where DOCNUMBR = 'your payment number'

If the above SQL query returns one record, delete that record.

delete from RM10201 where DOCNUMBR = 'your payment number'

Run the following SQL Scripts:

use DYNAMICS;

go

delete SY00800

delete SY00801

delete ACTIVITY

use tempdb;

go

delete DEX_LOCK;

delete DEX_SESSION;

Log back into Dynamics GP and perform the checklinks in the Receivables Open Transaction Files.

Let me know if it helped resolve your problem.
NHI 1,600 on at

Like (0)

Report

RE: Payment not found in GP

I ran the scripts following support Article ID: 855351 but it does not resolve the incident. When I put in the payment # in Sales > Cash Receipts, it still says 'You cannot display this record while another user is editing it." However, I found the payment in backend without user id info. I found out that the document number that has a problem is in the RM Key File (RM00401) and Distribution Open and Work tables. Can I just deleted the document number to resolve thsi incident?
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Payment not found in GP

Apparently, we do have a corrupted transaction, You do need to track the payment in the following tables (preferably on test environment) and remove the transaction manually. The following is most of the tables to consider;

PM00400 – Payable Master key

PM30200 Historical Transactions

PM30300 - Apply to History

PM30600 – History Transaction GL Distribution

Two further things that you need to consider, the vendor balance and the GL balance. You do need to post a corrective journal entry on the GL level in order to correct the account balances. Additionally, after deleting the transaction, the reconcile will supposedly handle the vendor summary balance tables (PM00201 and PM00202) , in case they were not updated accordingly, you need to do it manually.

Never forget to be careful when handling Dynamics GP tables, in case you don't have proper knowledge, refer to your partner.

Your feedback is highly appreciated,
NHI 1,600 on at

Like (0)

Report

RE: Payment not found in GP

I ran Reconcile and Checks links but it does not help. Do you have scripts to delete damage records in backend withou exiting all users?
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Payment not found in GP

As previously mentioned, check links and reconciliation are the two primary prerequisites that should always be considered before digging deeper for any further analysis.

Although, I don't believe the corruption illustrated in the screen shots above would be handled by the check links.

Let's wait and check the results.

Your feedback is highly appreciated,
Suggested answer

soma 24,408 on at

Like (0)

Report

RE: Payment not found in GP

Try to run Check Links for Receivabels Open Transactions Files and Receivabeles History Transaction Files.

Hope this helps!!!
NHI 1,600 on at

Like (0)

Report

RE: Payment not found in GP

I ran Reconcile-Remove Sales Document against invoice DI-002450 and Checklinks for Sales series with rows start with "Sale...". When I hit Amount remaining for the invoice in Transaction by Customer, the payment window appears but I also get an error message saying the document does not exist.

When I go to Cash receipt and put in the same payment #, it still says "You cannot display the record while another user is editing it".

Should I run Reconcile-Remove Sales Document for PAYMNT000000003627 and Check Links for 'Receivables' rows ?
Suggested answer

soma 24,408 on at

Like (0)

Report

RE: Payment not found in GP

Please have a look on post from below link.

community.dynamics.com/.../user-id-batch-id-stucks-while-posting-reconciling-deleting-etc-in-dynamics-gp.aspx

Hope this helps!!!