SICSR-16317

[SICSR-16317] When Importing TW from column spreadsheet, Accounting Period From date is not correct  
Product Line: P&C
Component/s: Accounting Technical Worksheet
Affects Version/s: SICS 4.9.1
Fix Version/s: SICS 20.1
Issue Links: is duplicated by SICSR-17571
Customer: Qianhai Re
External Issue ID: #61

Problem:
When Importing TW from column spreadsheet, Accounting Period From date is not correct
 

Solution:
When using the Import Technical Worksheet from Spreadsheet function with the AccYR and AccPeriod given in the spreadsheet, we must make sure these values are used as basis for the Accounting Period From - To fields. Make sure the AccYR value is used as the year in the Accounting Period From date.
Same behavior as for manual created worksheet.

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected