Pre Filing and Tax year changes

PreFiling changes

Solution Name : ExpressExcise.Web.App

Solution Name : ExpressExcise.Efile.Web

Solution Name : api.expresstrucktax.com

Change UseAdvanceFiling - true in Web config File

Solution Name : mapi.expresstrucktax.com

Change UseAdvanceFiling - true in Web config File

Solution Name : ETT.Control.Web

Commit Id - 493a0627 - TY changes 2023 is done

Solution Name : TSNA.Control.Web

Commit Id - 7eb16131 - TSNA - Enable Prefiling (2023-2024 Tax Year)

Table Changes - For Pre file

SELECT * from ee_Static_Groups

SELECT * from ee_Static_Mail_Templates WHERE Mail_Template_Id=31

SELECT * from ee_Static_Tax_Years

--UPDATE ee_Static_Mail_Templates set Mail_Subject ='Congratulations! You Have Prefiled Your 2023-24 @@FormName!' WHERE Mail_Template_Id=31

--INSERT INTO ee_Static_Tax_Years VALUES ('2023','PreFile_Year',0,GETDATE(),GETDATE(),0)

--INSERT into ee_Static_Groups VALUES ('Pre-Filed 23-24','Pre Filed 2023 Tax Year',0, GETDATE(),GETDATE(),0)

–Tax Amount insert query

--INSERT INTO ee_Static_Vehicle_Taxes(Weight_Category_Id,

--Month_Name,

--Month_Number,

--Tax_Year,

--Except_Logging_Tax,

--Logging_Tax,

--Is_Deleted,

--Create_Time_Stamp,

--Update_Time_Stamp)

--SELECT Weight_Category_Id,

--Month_Name,

--Month_Number,

--'2023',

--Except_Logging_Tax,

--Logging_Tax,

--Is_Deleted,

--GETDATE(),

--GETDATE()

--FROM ee_Static_Vehicle_Taxes WHERE Tax_Year='2022'

— FRB Holiday Insert Query

--INSERT INTO ee_Static_FRB_Holidays(

--Holiday,

--Date_Value,

--Month_Value,

--Year_Value,

--Is_Deleted,

--Create_Time_Stamp,

--Update_Time_Stamp)

--select Holiday,

--Date_Value,

--Month_Value,

--'2024',

--Is_Deleted,

--Create_Time_Stamp,

--Update_Time_Stamp

--FROM ee_Static_FRB_Holidays WHERE Year_Value='2023'

**** Trigger change in ee_Efile_Temp table for prefile changes

Tax Year changes

Solution Name : ExpressExcise.Web.App

Commit Id - fae9570d -TaxYear 2023 changes completely done

Solution Name : ExpressExcise.Efile.Web

Change taxyear tag in web config

Change UseAdvanceFiling - false web config

Solution Name : api.expresstrucktax.com

Change SuppportedTaxYears,TYForCreditVehicles,TYForCreditVehicles8849 tag in web config - add new taxyear and remove old tax year

Change 8849TaxYear,TaxYear - tag in web config -change the current tax year

Solution Name : mapi.expresstrucktax.com

Change SuppportedTaxYears,TYForCreditVehicles,TYForCreditVehicles8849 tag in web config - add new taxyear and remove old tax year

Change 8849TaxYear,TaxYear - tag in web config -change the current tax year

Solution Name : ETT.Control.Web

Change taxyear tag in web config

Solution Name : TSNA.Control.Web

Commit Id - 79496de8 - Tsna TY2023 changes done

Solution Name : ExpressTruckTax.Web.Partners

Commit Id - 29f65c20 - Partner site Tax year changes for 2023-2024 done.

Table Changes -For Tax year changes

INSERT INTO ee_Static_Groups VALUES ('2290 Filed 23-24','For Taxyear 2023',0,GETDATE(),GETDATE(),0)

SELECT * from ee_Static_Tax_Years

UPDATE ee_Static_Tax_Years SET Tax_Years_Id =16 WHERE Tax_Years_Id =115

UPDATE ee_Static_Tax_Years SET Tax_Year_Type ='Prior_Paper' , Is_Efile_Certified= 0 WHERE Tax_Years_Id =13

UPDATE ee_Static_Tax_Years SET Tax_Year_Type ='Prior_EFile' , Is_Efile_Certified= 1 WHERE Tax_Years_Id =15

UPDATE ee_Static_Tax_Years SET Tax_Year_Type ='Current_Year' , Is_Efile_Certified= 1 WHERE Tax_Years_Id =16

**** Trigger change in ee_Efile_Temp table for Tax Year changes

EFile Schema Changes

Form2290 Schema Changes

Commit Id - 0b12f061 - Form 2290 Schema changes done (Business Validation and Convert IRS Schema & XML validation Folders)

Form8849 Schema Changes

Commit Id - 161063a8 - Form 8849 schema changes for TY 2023 done