The users want to get the statistic from the past history data in AX.
I think the key here is where can we define relationship between the users and their located office.
The first place I am thinking about is the user → Company. However, User → company is just the default startup company. So I cannot use that.
Then I also think about Employee. However, employee is a local (not share) table. Users do not want to share employee data, since they don’t want to share the global address book.
as i have told before it is all about time sheet. To get statistic from the past history data, we need to define time sheet of past and then to maintain it for present.
Now the question arises where we can define this??
For that I believe it will be better if we define separateform for this and which will maintain only timesheet giving following details
Username
From Date & time
To Date & time
Specific office (It will have different office history).
and it needs one validation so that no one can enter some mutually exclusive data.