Hi everyone!
In the near future we will have two time zones in one company. This fact will grow up some problems.
There will be troubles if users with two different time zones make transactions. If these transactions stores dates and times in sort keys then the order of the datas are not correct.
Maybe someone of you had already solved such a problem.
Please help us in this case!
Thanx.
Vichtl

Are you going to have two databases in separate time zones? Even though we have 3 sites in two times zones all of our servers reside just in one time zone. So no problems with date and time stamps.

Mark

Hi!
Unfortunately we only have one server in europe for all companies.
Mybe there is any ohter solution.
Thanx for replying.

If you only have one server it should be okay. The transaction date and time are based off that server. Your users will just have to understand that when looking at transactions to add or subtract the time difference between the server and the company site. But the transactions should go into the system in a consistant manor - keeping transactions in the correct order.

Mark

Since you are using Unix you can set the TZ environment variable for each user depending on what time zone they are in. Dates and times will be displayed correctly for each user. The date and time are stored in the baan tables in GMT (Grenich mean time) and displayed (or entered) with the user's TZ in question. In BaanERP5c it is stored in UCT.

Set the user's TZ in their profile, or you can get fancy and have scripts depending on their bshell names or something.

TZ examples:

EST5EDT - eastern time
PST8PDT - pacific time ... (get the idea?)

Hi Eric!

We do it so as you described. So we set time zone variables under Unix. And so we get the problems, because we have two different time zones in one company. Some users have the time zone form Califonia and some have the time zone from Micigan. Thats the problem.

Thanx!


Roland

We have the exact same scenario…. we are single logistic company offices in different time zones. (EST & CST)
What we did was….we created 2 separate User Data templates for both EST and CST Users. (ttams1110m000)
The difference between EST & CST template is “time Zone” value in form 2.
We enclosed EST Template to all Eastern Time users and CST template to all CST Users….Now all transactions are coming into to our database as per local times.
I hope that is clear…

mraguthu, your suggestion will work, but that is BaanVc functionality. There are no time zone templates in BaanIVc4.

Roland, I am not sure I am following you. Depending on the TZ you are in, it should not matter. The data is stored in GMT, and displayed as the TZ of the user that is either reporting, displaying or entering.

e.g. user A in EST, user B in PST (3 hours early).

A enters transaction 1 at 11:00 AM EST
B enters transaction 2 at 11:00 AM PDT.

If user A looks at the data he will see the first transaction at 11:00 AM and the second one at 2:00 PM.

If user B looks at the data he will see the first transaction as 8:00 AM and the second as 11:00 AM.

Is this not what you are seeing?

Eric

Thanx mraguthu but estotz is wright. Regrettably.
Estotz you got the problem. Exactly as you described is our situaton. I will give you an example where we can get troubles wiht user A and user B in two different time zones.
Table tdinv700:
After every accounting transaction at this table one new entry will be created in this table. The primary index is the following.
Article, stock, transaction date, transaction time.
If two users in different time zones now make an accounting transaction on the same article and the same stock then the following situation can happen.
Local time User1: 08:00
Local time User2: 13:00
User time Quantity inventory after transaction
User1 08:00 1 1
User2 13:00 3 4
User1 08:01 2 6

If you now select this datas you get the following output
User time Quanity inventory after transaction
User1 08:00 1 1
User1 08:01 2 6
User2 13:00 3 4

This is the main problem.

Roland