Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - General
  New Posts New Posts RSS Feed - General Ledger Report not updated
  FAQ FAQ  Forum Search   Register Register  Login Login


General Ledger Report not updated

 Post Reply Post Reply
Author
Message Reverse Sort Order
Joseph A Nader View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: September 14 2006
Location: Lebanon
Status: Offline
Points: 360
Post Options Post Options   Thanks (0) Thanks(0)   Quote Joseph A Nader Quote  Post ReplyReply Direct Link To This Post Topic: General Ledger Report not updated
    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
Back to Top
Sponsored Links


Back to Top
acecapgr View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: December 11 2006
Location: United States
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote acecapgr Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Joseph A Nader View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: September 14 2006
Location: Lebanon
Status: Offline
Points: 360
Post Options Post Options   Thanks (0) Thanks(0)   Quote Joseph A Nader Quote  Post ReplyReply Direct Link To This Post Posted: December 11 2006 at 3:48pm

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

Joseph Abou Nader, PMP



MCT
,MCTS,MCBMSS,MCSA
Back to Top
acecapgr View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: December 11 2006
Location: United States
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote acecapgr Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com