Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / I cant open Sales tran...
Microsoft Dynamics GP (Archived)

I cant open Sales transaction Window

(0) ShareShare
ReportReport
Posted on by Jenny Peter 570

Yesterday i tried to post a sales invoice. After posting i cant open the sales transaction window. Its shows a error message. " Your previous transaction-level posting session has not finished processing.Please allow time for it finish.If you belive it has failed, log out of Microsoft Dynamics GP and log back in to recover transactions."

I log off and log in again ,but the same problem is still there. This problem is only for my user ID.

Please help me how to solve this problem

*This post is locked for comments

  • Jenny Peter Profile Picture
    Jenny Peter 570 on at
    Re: Re: I cant open Sales transaction Window
    Thanku very much for your valuable advice. I am not familiar with Database side, but i will show your message to the Expert and try to solve it. Thanks a lot.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: I cant open Sales transaction Window

    Hi Jenny,  the invoice you tried to post has become locked. Are you familiar with Query Analyser? 

    If you are, you need to do the following. Get everyone out of GP. Take a back up of your Dynamics database and the database of the company where the problem exists. Then go to query analyser and complete the following:

    Run DELETE SY00800 against the Dynamics database.

    Run the following queries against the company database:

    SELECT * FROM SY00500 WHERE BACHNUMB = ''

    SELECT * FROM SY00500 WHERE BACHNUMB = 'AAAA'  (where AAAA = your user ID)

    If you get results to eithre of these queries then run a delete query as follows:

    DELETE FROM SY00500 WHERE BACHNUMB = ''    or BACHNUMB = 'AAAA'    as appropriate.

    Go back into GP and test that you can open the Sales Transaction Entry window, and select existing transactions and create new ones. Also search for the Invoice you posted before you got this error and make sure you can enquire on it.

    If after the above, you are still having an issue, post here again.

    Ian Stewart - feel free to email me if you need help with the above.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans