Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Payment not found in GP

Posted on by 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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment not found in GP

    Hi Nhi,

    I'm glad it all worked out.

    Kind regards,

    Leh

  • NHI Profile Picture
    NHI 1,600 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    NHI 1,600 on at
    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?

     

    7183.2.JPG

     

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    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 Profile Picture
    NHI 1,600 on at
    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 Profile Picture
    Mahmoud Saadi 32,738 on at
    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 Profile Picture
    soma 24,406 on at
    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 Profile Picture
    NHI 1,600 on at
    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 ?

    6332.2.JPG

    4263.5.JPG

     

    6735.3.JPG

     

    2313.4.JPG

     

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    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!!!

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans