SICSR-17626

[SICSR-17626] Internal Received date set on worksheets created from spreadsheet, even when it is not in use
Product Line:	P&C
Component/s:	Accounting Technical Worksheet
Affects Version/s:	SICS 4.9.5
Fix Version/s:	SICS 20.1
Customer:	DXC

Problem:
Internal Received date set on worksheets created from spreadsheet, even when it is not in use

Solution:
The Received External date on the worksheet can be changed per Business on the worksheet, but the user will be asked if the change should affect only this business or all businesses on the worksheet.
The Received Internal date on the worksheet can only be changed for the whole worksheet (the column is in the AC_WORKSHEET table).
Existing Rule: The Received Internal must be equal or higher than the Received External.
When a the Received date (and this is the Received External date) is given in the spreadsheet, on one or more businesses, then this date is set as Received External date on the businesses where this is given.
If at least one of the businesses in the worksheet has the system parameter defined to also use the Received Internal date on the worksheet ( "Is Received Internal Date On Worksheet In Use" ), then the system will set HIGHEST Received External date found on the worksheet in the Received Internal date and this will be shown on ALL businesses independent if it belongs to a BC with this parameter on or off.
It is now possible to change the Received External date on the business with the BC that also use the Received Internal date and the latter will be reset equal the Received External date (also for all other businesses on the worksheet). In this case we may come in a situation where the Received External date is HIGHER than the Received Internal date for a business.
1. Therefore we need to make the following change on the worksheet when the user change the Received External date for a business and where the Received Internal date is changed on all businesses at the same time;
Make sure the system check the Received Internal data on ALL businesses, and if it finds a business where the Received Internal is LESS than the Received External, then the message AC0483 must apply, telling the user that The Received External date cannot exceed the Received Internal date. In this way the user can change the Received External date on the businesses where this is not less than the Received Internal.
2. In case all the base companies on the businesses on the worksheet has the parameter OFF, then we need to set the Received Internal date to null (same as the system does when the user creates a worksheet manually).

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected