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



    • Related Articles

    • Different iVend business date and system date

      Environment: iVend 6.6 and 6.5 Update 6 with SAPB1 Problem Statement : iVend MC screen displays the different business date and system date. Symptoms: Product Query Resolution/Work Around: The First date displays the business date and last date ...

    • Business date is different from System date.User not allowed to login, please contact manager

      Version: Not version-specific Issue: Not able to login to Point of Sale (POS), getting an error message "Business date is different from System date. User not allowed to login, please contact manager", below the screenshot of the error: Solution: ...

    • General Settings in SAP Business One

      Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...

    • SAP Business One - iVend Retail Integration Points

      Introduction SAP Business One software is created specifically for small and midsized businesses. It is a powerful application and iVend Retail seamlessly integrates with it to help retailers better manage every aspect of their daily retail ...

    • Business Date Different From System Date

      Article - Template Environment: iVend 6.5.6 Problem Statement: When tried to login in, the POS application was showing the below message. Symptoms: N/A Resolution/Work Around: Make sure the DB name should be corrected in the Connection Manager at ...