End Of Day and showing error message Till Session not available
/*****INTERNAL TO CXS SUPPORT TEAM*****/Problem Statement
End Of Day and showing error message Till Session not available
Environment
iVend 6.5 With SAPB1(dated version)
Resolution/Work Around
We have to make the required changes using sql queries on Problematic Store db
take backup before excuting update query
Further we used SQL Script to update Till status correct so you were allowed to do EOD on Store MC Screen.
select * from CfgVersion
select * from CfgSiteInformation
select * from rtlstore where siteid='put in site id'
select * from TilTill where storekey='Put in store key'
and status not in ('3','4') and Tillkey in ('put in till id')
begin tran
update TilTill
set status=3
where storekey='Put in store key'
and status not in ('3','4') and Tillkey in ('put in till id')
commit tran
This KB article concludes here.