[SICSR-16758] The “Remove Currency” function truncates only fk_ledger from ac_bal_grp_parm, which causes SYN0002 (The ledger field is required but has not been specified)
Product Line:	P&C
Component/s:	Accounting Technical Worksheet
Affects Version/s:	SICS 4.8.6 SSP9
Fix Version/s:	SICS 4.9.5
Customer:	SOMPO JAPAN INSURANCE INC.
External Issue ID:	Dezie3683

Problem:
The "Remove Currency" function truncates only fk_ledger from ac_bal_grp_parm, which causes SYN0002 (The ledger field is required but has not been specified)

Solution:
When a worksheet is created and applied with booking details in a currency and the user add another currency to the worksheet and apply this without any details added to this currency, make sure the system cleans up the worksheet and remove table rows created by this additional currency - rows in table ac_bal_grp_parm - so that the worksheet later can be closed without the syntax validation saying that a ledger is missing.

Workaround:
If you come in the above situation so that you cannot close the worksheet, set the status to Inactive and make a new worksheet for the same.

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected