Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error while running Re...
Microsoft Dynamics GP (Archived)

Error while running Reconcile Receivables

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Good day to everyone,

I'm trying to run the process in Reconcile Receivables Amount window, however I got an error prompted: 

Error: Another user is aging or reconciling debtor information. Please try again later.


I have already check the User Activity , as well as using script on SSMS to ensure no one is using Dynamics GP at that point.

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_LOCK

SELECT * FROM TEMPDB..DEX_SESSION

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

Nevertheless, the error remain still, anyone may help please? 

Thanks, 

Vince

*This post is locked for comments

  • Tim W Profile Picture
    Tim W 2,925 on at
    RE: Error while running Reconcile Receivables

    RMAging.jpg

  • Tim W Profile Picture
    Tim W 2,925 on at
    RE: Error while running Reconcile Receivables

    Sounds like someone started an Aging and then client was killed off before it finished.

    select * from RM10901

    If you have a record delete the row.

  • Alvaro Rodríguez Ochoa Profile Picture
    Alvaro Rodríguez Ochoa 2,395 on at
    RE: Error while running Reconcile Receivables

    Have you tried looking into activity monitor using managment studio to see if there's an activity running and killing the process?

  • Alvaro Rodríguez Ochoa Profile Picture
    Alvaro Rodríguez Ochoa 2,395 on at
    RE: Error while running Reconcile Receivables

    You could try David Musgrave script to see if it makes any difference:

    — Dexterity Sessions Table
    delete S
    — select *
    from tempdb..DEX_SESSION S
    where not exists (
     select * from DYNAMICS..ACTIVITY A
     where S.session_id = A.SQLSESID)

    — Dexterity Locks Table
    delete L
    — select *
    from tempdb..DEX_LOCK L
    where not exists (
     select * from DYNAMICS..ACTIVITY A
     where L.session_id = A.SQLSESID)

    — Batch_Headers table in each company
    exec sp_MSforeachdb
    ‘ use [?]
    if exists ( select INTERID from DYNAMICS..SY01500 D where INTERID = ”?” )
    begin
     update S set BCHSTTUS = 0, MKDTOPST = 0, USERID = ””
     — select *
     from SY00500  S
     where BCHSTTUS in (1,2,3,4,5,6)
     and not exists (
      select * from DYNAMICS..ACTIVITY A
      JOIN DYNAMICS..SY01500 C ON C.CMPNYNAM = A.CMPNYNAM
      where S.USERID = A.USERID and C.INTERID = db_name())
     and exists (
      select * from DYNAMICS..SY00800 B
      where not exists (
       select * from DYNAMICS..ACTIVITY A
       where B.USERID = A.USERID and B.CMPNYNAM = A.CMPNYNAM)
      and S.BCHSOURC = B.BCHSOURC and S.BACHNUMB = B.BACHNUMB)
     print ””
     print ”(” + ltrim(str(@@ROWCOUNT)) + ” row(s) affected) – Database ” + db_name()
    end
    ‘

    — SY_Batch_Activity_MSTR table
    delete  B
    — select *
    from DYNAMICS..SY00800 B
    where not exists (
     select * from DYNAMICS..ACTIVITY A
     where B.USERID = A.USERID and B.CMPNYNAM = A.CMPNYNAM)


    — SY_ResourceActivity table
    delete  R
    — select *
    from DYNAMICS..SY00801 R
    where not exists (
     select * from DYNAMICS..ACTIVITY A
     JOIN DYNAMICS..SY01500 C ON C.CMPNYNAM = A.CMPNYNAM
     where R.USERID = A.USERID and R.CMPANYID = C.CMPANYID)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans