Skip to Content
0
Former Member
Feb 27, 2011 at 03:15 PM

Query that can retrieve data according to user currently login

36 Views

Hi All,

I have a query that will get the the 'Doctotal', 'DocNum', and 'Docdate' from oinv

The requirements are the following:

1. I have two users, UserA and UserB

2. If UserA is currently login, the query will retrieve the data according to her login. And not supposed to see the sales of UserB.

3. If UserB is currently login, then vice versa.

rgds,

vin