Hello,

 

If you don’t have access to the VI Jobs, please ask Matthew to give you the permissions.

 

Use the VI Job named “GL DAILY CAL” and the CSV file GL UDT Daily Calendar 2020 to import the data on the UDT.

 

 

 

Use the VI JOB named “SY FISCAL WEEK” to import the data from the GL UDT Daily Calendar 2020 – weekly.

Change the data on the CSV file for UDF_PERIOD and UDF_WEEK fields to have a leading zero (as per the screenshot below).

 

 

 

If you need assistance to import the files, please let us know.

 

Thank you,

 

Mihai Patrutiu

Munjal White Consulting Corp

Tel – 416 703-3458 x200

[email protected]

 

SQL Scripts used for inconsistent dates.


Firstly, ensure there is backup taken for mas_gtl.dbo.GL_UDT_DAILY_CALENDAR and MAS_GTL.dbo.SY_UDT_FISCAL_WEEK tables.


update  mas_gtl.dbo.GL_UDT_DAILY_CALENDAR 

set UDF_DATE=CONVERT(datetime,

            STUFF(STUFF(CAST(UDF_DATE_YYYYMMDD AS varchar(8)), 5, 0, '-'), 8, 0, '-'),

            120)

where UDF_FISCAL_YEAR='2026'


update MAS_GTL.dbo.SY_UDT_FISCAL_WEEK  set udf_start_date= CONVERT(date, udf_start_date, 101),

UDF_END_DATE= CONVERT(date, UDF_END_DATE, 101) 

where UDF_FISCAL_YEAR=2026