Print Page | Close Window

General Ledger Report not updated

Printed From: Microsoft Dynamics Forums
Category: Microsoft Dynamics GP (Great Plains)
Forum Name: GP - General
Forum Discription: All other Great Plains (GP) Topics
URL: http://www.MicrosoftDynamicsForums.com/forums/forum_posts.asp?TID=895
Printed Date: October 21 2019 at 12:17pm


Topic: General Ledger Report not updated
Posted By: acecapgr
Subject: General Ledger Report not updated
Date Posted: December 11 2006 at 10:07am
Hi all, first post here =)

GP went live about 2 months ago and everything was going smooothly then on 12/8/2006, I cleared out some ghost users from SQL table (CFA cannot edit and post a sales batch because another user was editting it but that user was logged off).  Next day I discovered that all checks written that day were posted in General Ledger with an audit trail but  Account Transaction window does not show them, it only shows up to 12/7/2006.  Any ideas on where I should look at first?

Dennis



Replies:
Posted By: Joseph A Nader
Date Posted: December 11 2006 at 3:48pm

From which table have you deleted the users????



-------------
Joseph Abou Nader, PMP



MCT
,MCTS,MCBMSS,MCSA


Posted By: acecapgr
Date Posted: December 11 2006 at 5:25pm
I deleted the user row from Database ---> DYNAMICS --> TABLES --> dbo.ACTIVITY.  SQL Server Management Studio, 2005 version.  GP 9.0
Is this the proper way to resolve user activity issues?
Dennis


Posted By: Joseph A Nader
Date Posted: December 12 2006 at 6:25am
Hey...
 
Ok...it seems that you haven't done anything wrong. You have used the correct table to delete the user activity and it shouldn't affect anything else in the system. Now it seems that there is something else that happened.
 
Look man, you can try to check links may be something went wrong.
 
Take Care


-------------
Joseph Abou Nader, PMP



MCT
,MCTS,MCBMSS,MCSA



Print Page | Close Window