GO

if (select count(0) from System_Default where Default_Name = 'Main_Store_ID' and Default_Value in 
(285,
307,
28,
29,
45,
47,
55,
59,
64,
65,
66,
73,
74,
79,
81,
89,
95,
99,
103,
105,
108,
112,
130,
140,
145,
159,
169,
176,
180,
194,
210,
211,
212,
217,
224,
235,
236,
237,
238,
247,
248,
249,
254,
258,
260,
261,
267,
272,
279,
287,
288,
291,
297,
303



  )) > 0

UPDATE SystemSetting SET SettingValueDecimal = '14' WHERE SettingKey = 'ProjectionPeriod'
go

Print 'If you see rows affected means it updated and ran script if you just see this message means nothing was updated';

GO

if (select count(0) from System_Default where Default_Name = 'Main_Store_ID' and Default_Value in 
(285,
307,
28,
29,
45,
47,
55,
59,
64,
65,
66,
73,
74,
79,
81,
89,
95,
99,
103,
105,
108,
112,
130,
140,
145,
159,
169,
176,
180,
194,
210,
211,
212,
217,
224,
235,
236,
237,
238,
247,
248,
249,
254,
258,
260,
261,
267,
272,
279,
287,
288,
291,
297,
303


  )) > 0

UPDATE SystemSetting SET SettingValueBit = 0 WHERE SettingKey = 'ProjectionPeriodEnabled' --DONT ALLOW THE DAYS TO BE CHANGED
go