The Business Date is different than the System Date

The Business Date is different than the System Date

******* Internal to CitiXsys  *******

Environment:

iVend 6.6

Problem Statement:

Getting an error message
"the Business Date is 02\15\2021 is different than the System Date 02\14\2021" when trying to login the POS before 11:00 am.
However, the business date and system date is same at iVend Management Console and system is allowing to login the POS after 11:00 am.





Cause:

After investigation, we found wrong Company Time Zone Id, Company Time Zone Offset In Minutes in the table cfgenterprise.



It was Pacific Standard Time and system time zone was in Arab Standard Time.  Arab Standard Time is 11 hours ahead of Pacific Standard Time that why the POS was allowing to login the user after 11:00 am.

Solution:

We ran the SQL query and corrected the Company Time Zone Id, Company Time Zone Off Set In Minutes, and generated the replication events for the table cfgenterprise.



To calculate Off Set In Minutes  first check time zone in UTC and use formula (60*H + M).
Example - 1: Arab Standard Time is 3h. ahead of UTC (Coordinated Universal Time). The time offset from UTC can be written as UTC+03:00.
(3*60+0) = 180.
Example - 2: Indian Standard time (IST) is 5h 30 min ahead of UTC (Coordinated Universal Time) , The time offset from UTC can be written as UTC+05:30
(5*60+30)= 330