Link to home
Start Free TrialLog in
Avatar of jana
janaFlag for United States of America

asked on

How to determine what option a user is at in GP Dynamics

Is there a way to know where a user is in GP either by SQL, VB.NET or by Retreiveglobal?

Avatar of Abdulmalek_Hamsho
Abdulmalek_Hamsho
Flag of United Arab Emirates image

What do you mean by "Where"?
Avatar of jana

ASKER

We've been having problems of who is at what option at any given moment.  That is, we have 5 user connected in various series and option (user1 is in PM doing check edit, user2 is GL printing statements; all user simultaneously).

What we are trying to do is to know at any given moment at what windows is USER1.

We seen a report in GP where it gives a history of where users visited, but is there anything that can tells us now?

We thought that maybe Retrieveglobal.dll could have an environment value that would give us the info.  Also, maybe a table that can tells us this (something like activity that tells who is connected).

Hope this info helped.

Thanx Lots!

ASKER CERTIFIED SOLUTION
Avatar of Abdulmalek_Hamsho
Abdulmalek_Hamsho
Flag of United Arab Emirates image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

SY00800 works perfect, but it all depends if user "saves" the batch if any.  And and SY05000 is history.

What is Audit Trail feature and how can we test that?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Will try it.... but is Audit Trail online; that is, not dependen to historical?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Thanx for clearing that up.

With Retreiveglobal.DLL we cam know in a VB Apps who is logged and what company is logged on.  There has to be a way to know this info.

With this in mind, is there anything else that we can do?

Thank you.

Why would one need to know what window every user is working on?

RetrieveGlobals has nothing to do with your requirement.
Avatar of jana

ASKER

Understood.  I refer to Retreiveglobal.DLL for the way it works.  We know it has nothing to do with our requirement.  We refer to the DLL Because if the way it works; it knows the user who is logged, what company is logged on, etc.  So we figure maybe there is something similar out there that would know what option the user is at.  We refer to the DLL to give a clear concept of what we want.

As to why we need to know what option the user is at us because of the Check Links and Conciliation.   We have found that when these maintenance has to be ruined to a specific series/module, we have to always call and ask for users to exit said module.

We use a script to see who is logged (Dynamics..Activity), but that only tells us who is logged.

Hope this info helped in what we're aiming for.

Thank you
Avatar of jana

ASKER

I guess, to rephrase the question:  "How to determine what module or series a user is logged in"
Yes, this is exactly what SY00800 does. Check Links and Reconciliation check SY00800 to see if any related Batch or Transaction is locked.
SOLUTION
Avatar of Victoria Yudin
Victoria Yudin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Hi Abdulmalek_Hamsho, when u mentioned sy00500 before we tested against what we want and u are correct, it checks for batches.  However, what we need is to know if the user is at the window option even if the user didn't vreat a batch.  We tested starting a transaction and the table didn't recognize any user since no batch file is open.  The reason we need know is to setup the user who is in charge of maintenance in order to notify the other user to exit the module.

From what we seen sy00500 is only useful if the user created a batch.
Avatar of jana

ASKER

Hi victoria_y, didn't see your post; we'll check your links
Avatar of jana

ASKER

Hi Victoria... we checked the script and it does tells us who is connected and batched info.  Unfortunately, it doesn't recognize when a user is at a certain screen (our of our question).  We wen to sales and called a transaction that was in a batch, and the script didn't display the result.

Is there a way we can detect when a user is at a certain window within GP, for example, PM Check Links, Customer Maintenance,  Item inquiry window?  We are not looking for historical or tracking info, we are looking for onlined or actual user connection regarding what window he/her is currently at.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Yes, thank you.  I see what you mean.  I opened up GP and went into various GP windows and noticed that the column that change is 'WINTYPE'.  We went into Cards, Reports, Transactions and maintenance and the following is what we observe:

     - GL = -32767
     - Bank = no change
     - SOP = 4
     - RM = no change
     - POP = 100
     - PM = no change
     - INVT = 1
     - PR = no change

Notices that when in windows screen of Cards, Reports, Inquiry and maintenance, there were no change in 'WINTYPE'.

I think this is the closest we gotten to see who is online and also in what module?
Avatar of jana

ASKER

We reviewed the script to try to see what user is in what option within GP and the closes is my comment on my previous post (ID: 36524666).

Is it safe to say that this is the closest we are going to get?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Understood.

Thanx
Avatar of jana

ASKER

Thanx