Mass Update Balances, Pairings and Worksheets

SICS lets you update many balances or worksheets at once by using the mass update facility. You can access this from the Periodic Functions folder on the SICS desktop. In that folder is a folder called Accounting Mass Update. Click this folder and you see seven (or eight) icons : ‘Business Partner Mass Update on Balances, Closed Balances, Last Completed Booking Year, Open Balances, Open Worksheets’, ‘Reporting Classification Detail Mass Update’ and ‘Reserve and Deposit Detail Mass Update and Accounting Balance Pairing Status Mass Update..’

Note! TheReporting Classification Detail Mass Update option is visible if Reporting Classification is in use on your system). The Accounting Balance Pairing Status Mass Update is visible if Pending Status for Balance Pairing is in use in your system. .

When you update balances using the mass update functionality, those balances are automatically updated on their corresponding worksheet s.

When you use the mass update functionality on open worksheet s, you are given the option to close or inactivate worksheet s. Because closing a worksheet often results in the creation of a new worksheet, the response time for this action may take longer than for updating balances.

Update Balances #

The Closed Balances icon and the Open Balances icon in the Mass Update folder have similar functionality, but the main difference is that one lets you update balances on open worksheets and the other on closed worksheets. See Update Worksheets on page 11-658for a definition of an ‘open worksheet’.

In this example, we have used the Closed Balances to demonstrate the feature. Click the Closed Balances icon to see the Find: Closed Balances Mass Update window.

Here you can search for orders that have been created in order to do mass updates on closed balances. (You cannot tell from the list whether or not the order has been run, but you can open the order by double-clicking it, which lets you view its properties.)

To do a mass update, you must first create a new order:

1. Click the display list and click the right-mouse button.
2. Select New from the pop-up menu. You see the Closed Balances Mass Update Order window.

3. Input an Order title and specify filters to narrow the results in the Balance List at the bottom of the window. After you have entered the information, click the OK button. The order appears in the Find window when you click the Find Now button. 4. Double-click the order in the Find window to open it. 5. Click the Edit Menu button and select List Closed Balances to see a list of balances that meet the filter criteria you entered. (This process takes a few minutes.) 6. Click the Edit Menu button again and select Mass Update. You see a new window where you can change information that applies to all the balances in the list.

If you select Edit from the Edit Menu button, you can edit the Order window and input new filter criteria in order to produce a new list of balances.

Note! DXC recommends that you do not update the Booking Year and Period on Closed Balances.

Update Worksheets #

Using the mass update facility in SICS, you can close or inactivate ‘open worksheets’.
The definition of ‘Open Worksheets’ in relation to the mass update functionality is:

• If the system parameter Advanced Use of Worksheet Status is in use:

  • Technical Worksheets with the worksheet status: Open, Unfinished or Corrected.
  • Claim Worksheets with the status Unfinished, Corrected or Authorized.

• If the system parameter Advanced Use of Worksheet Status is NOT in use:

  • Technical and Claim Worksheets with the worksheet status Open, Unfinished. Click the Periodic Functions folder on the desktop and then click the Accounting Mass Update folder. Open the Find: Open Worksheet Mass Update window by clicking the Open Worksheets icon.

Here you can search for orders that have been created for open worksheet s. You can select an item in the list to open that order and see its properties and to see whether or not it has been updated.

To update worksheets using the mass update functionality, you must first create an order:

1. Click the display list in the Find window.
2. Click the right-mouse button and select ‘New’ from the pop-up menu.

You see the Open Worksheet Mass Update window.

3. Enter an order title and filter criteria to narrow the open worksheet list results, (which appears at the bottom of the page).
4. Click OK to return to the Find window. Click ‘Find Now’to refresh the list and you see the order you just created.
5. Double-click the order to open it.
6. From the ‘Edit Menu’button, select the update option that you want. You can close and inactivate selected items in the list by selecting ‘Close Selected’ or ‘Inactivate Selected’, or you can close or inactivate all items in the list at the same time by selecting ‘Close’ or ‘Inactivate’.

Business Partner Mass Update on Balances #

In case of mergers and acquisitions, a transfer from one business partner to another may affect your portfolio and require that several businesses and their belonging balances get updated. Using the mass update facility in SICS, you can transfer the payment task on balances to another business partner. You can also update the current responsible business partner on the balances with a new partner.

You can also use this function to reverse balances with the current responsible business partner and replace them with new balances with a new responsible partner. This option should be used if you need to keep track of the shift of the partner and would like the changes to be reflected in the general ledger.

Mass Update Expected (Payment Partner) BP #

Depending on your system parameter settings, you can update the expected payment partner on all balances or on only unsettled and partially settled balances with a new business partner. If your system administrator has selected the system parameter Include Settled Balances on Payment Partner Mass Update, you will be able to update all balances. If not, you can only update outstanding balances. (For further information contact your system administrator.)

|
Business Partner Mass Update icon | 1. Click the Business Partner Mass Update on Balances icon in the Periodic Functions /Accounting Mass Update folder on the desktop. You see the Business Partner Balance Mass Update window. |

2. Click the Expected BP Update tab.

3. Select the Level of Business; Assumed Business or Retrocessionaire Participation.
4. Select Current Expected Payment Partner by using the Find Business Partner function.
5. Select New Expected Payment Partner by using the Find Business Partner function.
6. Select which worksheets that should be included in this update by either:

• Entering a Due Date From and To; and/or
• Selecting Booking Year and Period From and To

7. Click Find Now to show the balances.
   View Balances: You can inspect the balances in three different views:

• Original (default view).
• Account (if any of the balances are part of an Account Balance).
• Settlement (if any of the balances are part of a Settlement Balance).

8. Select the balances you want to include in the mass update by selecting Exclude/Include from the pop-up menu.
9. Select Mass Update from the pop-up menu. The system then replaces the current business partner with the new business partner as expected payment partner for all included balances.

Mass Update Reverse and Replace Expected Payment Partner #

If the expected payment partner has merged with another business partner, you can chose to reverse the necessary balances on the old partner and replace them with new balances on the new partner.

Note! I t is a requirement that the new partner is present on the affected businesses before you make the necessary change of the balances.

To reverse and replace the expected Business Partners using the mass update function: #

1. Click the Business Partner Mass Update on Balances icon in the Periodic Functions on the desktop. You see the Business Partner Balance Mass Update window.
2. Click the Expected BP Replace tab
3. Select the Level of Business; Assumed Business or Retrocessionaire Participation.
4. Specify the Current Payment Partner.
5. Specify the New Payment Partner.
6. To make limitation to the number of involved businesses and balances enter the necessary extraction criteria, e.g. by entering one or more Business Identifiers the balances belongs to, entering a span of Due Dates the balances should be within and/or entering a span of Booking Year and Period the balances should be within.
7. Click Find Now. You see all balances on which the selected business partner is Payment Partner .For a highlighted balance you can open the Business Ledger or the Business properties in case you need to investigate further before executing the mass update.
8. Highlight the balances you want to include in the mass update by selecting Exclude/Include option from the pop-up menu.
9. Select Mass Update from the pop-up menu. The system make reversal bookings of the included balances with the current payment partner and replacement bookings of the included balances with the new payment partner.
10. You can inspect the created bookings by selecting View Technical Worksheet/ View Claim Worksheet from the pop-up menu. Note! The new worksheets are automatically set to Closed so it is important that you pay attention to the above points 7 and 8.

Execute the Mass Update #

When the actual balances have been found and included in the Business Partner Balance Mass Update balance list, and a New Expected Payment Partner is defined the user can select the option Mass Update from the pop-up menu in the balance list.

Dependent on the Settlement Indicator of the selected balances the system do the following:

Unsettled #

• A reversal balance is booked for each of the balances included in the list
• The Expected Payment Partner linked to the reversal balance is the Business Partner in the field Current Payment Partner
• The reversal balance is paired with the source balance so that both the source and the reversal balance are marked Settled
• A replacement balance is booked for each of the balances included in the list
• The Payment Partner linked to the replacement balance is the Business Partner in the field New Payment Partner
• The replacement balance is marked Unsettled

Exceptions #

In case the Unsettled balance is part of either a Settlement Balance Group or an Account Balance Group both the source balance, the reversal balance and the replacement balance becomes Unsettled

Partially Settled #

• A reversal balance is booked for each of the balances included in the list
• The Payment Partner linked to the reversal balance is the Business Partner in the field Current Payment Partner
• The source balance Remains Partially Settled
• The reversal balance is marked Unsettled
• A replacement balance is booked for each of the balances included in the list
• The Payment Partner linked to the replacement balance is the Business Partner in the field New Payment Partner
• The replacement balance is marked Unsettled

Other special rules: #

Extraction of one Insured Period when included in a balance containing more than one Insured Period

• Payment Partner is according to above
• All details with the extracted Insured Period within the listed balance are reversed.
• The balance amount of the reversals/replacements will be different from the source balance
• The source balance remains unchanged
• The reversed balance is marked Unsettled
• The replacement balance is marked Unsettled
• No pairing is created between the reversed balance and the replacement balance

Booking Period #

System assigns a Booking Year and Period according to the Booking Year and Period of the source details. If this Booking Year and Period is closed, the system assigns the default Booking Year and Period defined for the Base Company of the reversal/replacement balance.

Due Date #

The Due Date of the individual reversal/replacement balance is set equal the Due Date of source balance.

Worksheet Origin #

A special Worksheet Origin is assigned to the reversal/replacement balances created by the Business Partner Balance Mass Update, named Bp Balance Mass Update.

Release Indicator #

If some of the details are within the Entry Code Categories;

• Cash Claim
• Deposit
• Non-Liquid Deposit
• Premium Due Later

The Released indicator of the reversal/replacement detail is set to the same value as the source detail and if it is set to Released, no detail pairing is created

Booking on Retrocessionaire’s Participations #

Additional to the above description of the bookings created by the Business Partner Balance Mass Update there is one special rule for bookings on Retrocessionaire’s Participations. The booking detail included in the reversal/replacement balance has a Retro Detail Pairing to the same detail as the details in the (source) balance being reversed and replaced. #

Replace Expected Payment Partner #

Mass Update Reverse and Replace Expected Payment Partner #

If the expected payment partner has merged with another business partner, you can chose to reverse the necessary balances on the old partner and replace them with new balances on the new partner.

Note! I t is a requirement that the new partner is present on the affected businesses before you make the necessary change of the balances.

To reverse and replace the expected Business Partners using the mass update function: #

1. Click the Business Partner Mass Update on Balances icon in the Periodic Functions on the desktop. You see the Business Partner Balance Mass Update window.
2. Click the Expected BP Replace tab
3. Select the Level of Business; Assumed Business or Retrocessionaire Participation.
4. Specify the Current Payment Partner.
5. Specify the New Payment Partner.
6. To make limitation to the number of involved balances enter the necessary extraction criteria
7. Click Find Now. You see all balances on which the selected business partner is Payment Partner .For a highlighted balance you can open the Business Ledger or the Business properties in case you need to investigate further before executing the mass update.
8. Highlight the balances you want to include in the mass update by selecting Exclude/Include option from the pop-up menu.
9. Select Mass Update from the pop-up menu. The system make reversal bookings of the included balances with the current payment partner and replacement bookings of the included balances with the new payment partner.
10. You can inspect the created bookings by selecting View Technical Worksheet/ View Claim Worksheet from the pop-up menu. Note! The new worksheets are automatically set to Closed so it is important that you pay attention to the above points 7 and 8.

Execute the Mass Update #

When the actual balances have been found and included in the Business Partner Balance Mass Update balance list, and a New Expected Payment Partner is defined the user can select the option Mass Update from the pop-up menu in the balance list.

Dependent on the Settlement Indicator of the selected balances the system do the following:

Unsettled #

• A reversal balance is booked for each of the balances included in the list
• The Expected Payment Partner linked to the reversal balance is the Business Partner in the field Current Payment Partner
• The reversal balance is paired with the source balance so that both the source and the reversal balance are marked Settled
• A replacement balance is booked for each of the balances included in the list
• The Payment Partner linked to the replacement balance is the Business Partner in the field New Payment Partner
• The replacement balance is marked Unsettled

Exceptions #

In case the Unsettled balance is part of either a Settlement Balance Group or an Account Balance Group both the source balance, the reversal balance and the replacement balance becomes Unsettled

Partially Settled #

• A reversal balance is booked for each of the balances included in the list
• The Payment Partner linked to the reversal balance is the Business Partner in the field Current Payment Partner
• The source balance Remains Partially Settled
• The reversal balance is marked Unsettled
• A replacement balance is booked for each of the balances included in the list
• The Payment Partner linked to the replacement balance is the Business Partner in the field New Payment Partner
• The replacement balance is marked Unsettled

Other special rules: #

Extraction of one Insured Period when included in a balance containing more than one Insured Period

• Payment Partner is according to above
• All details with the extracted Insured Period within the listed balance are reversed.
• The balance amount of the reversals/replacements will be different from the source balance
• The source balance remains unchanged
• The reversed balance is marked Unsettled
• The replacement balance is marked Unsettled
• No pairing is created between the reversed balance and the replacement balance

Booking Period #

System assigns a Booking Year and Period according to the Booking Year and Period of the source details. If this Booking Year and Period is closed, the system assigns the default Booking Year and Period defined for the Base Company of the reversal/replacement balance.

Due Date #

The Due Date of the individual reversal/replacement balance is set equal the Due Date of source balance.

Worksheet Origin #

A special Worksheet Origin is assigned to the reversal/replacement balances created by the Business Partner Balance Mass Update, named Bp Balance Mass Update.

Release Indicator #

If some of the details are within the Entry Code Categories;

• Cash Claim
• Deposit
• Non-Liquid Deposit
• Premium Due Later

The Released indicator of the reversal/replacement detail is set to the same value as the source detail and if it is set to Released, no detail pairing is created

Booking on Retrocessionaire’s Participations #

Additional to the above description of the bookings created by the Business Partner Balance Mass Update there is one special rule for bookings on Retrocessionaire’s Participations. The booking detail included in the reversal/replacement balance has a Retro Detail Pairing to the same detail as the details in the (source) balance being reversed and replaced.

Mass Update of Responsible Business Partner #

If a business partner acting as Cedent on your Assumed Businesses and/or as Retrocessionaire on your outward protections has merged with another business partner, you must change the affected businesses and their balances.

Note! DXC recommends that you update the Business Partner Roles on the affected businesses before you update the Responsible Business Partner on balances.

In case it is important to keep track of these change on the balances it is recommended to make the mass update from the Responsible BP Replace tab where the system will reverse balances with the old responsible partner and replace them with the new responsible partner

To change the responsibility of a Business Partner using the mass update function:

|
Business Partner Mass Update icon | 1. Click the Business Partner Mass Update on Balances icon in the Periodic Functions /Accounting Mass Update folder on the desktop. You see the Business Partner Balance Mass Update window. |

2. Click the Responsible BP Update tab.

3. Select the Level of Business; Assumed Business or Retrocessionaire Participation.
4. Specify the Current Responsible Partner.
5. Click Find Now. You see all balances on which the selected business partner is Responsible Business Partner.
6. Specify the new Responsible Partner.
7. Select the balances you want to in the mass update by selecting Exclude/Include option from the pop-up menu.
8. Select Mass Update from the pop-up menu. The system replaces the current business partner with the new business partner as Responsible Business Partner for all included balances.

Reverse and Replace Responsible Business Partner #

If a business partner acting as Cedent on your Assumed Businesses and/or as Retrocessionaire on your outward protections has merged with another business partner, you can chose to reverse the necessary balances on the old partner and replace them with new balances on the new partner.

Note! It is a requirement that you update the Business Partner Roles on the affected businesses before you make the necessary change of the balances.

To reverse and replace the responsibility of Business Partners using the mass update function: #

1. Click the Business Partner Mass Update on Balances icon in the Periodic Functions on the desktop. You see the Business Partner Balance Mass Update window.
2. Click the Responsible BP Replace tab

3. Select the Level of Business; Assumed Business or Retrocessionaire Participation.
4. Specify the Current Responsible Business Partner.
5. Specify the New Responsible Business Partner.
6. To make limitation to the number of involved balances enter the necessary extraction criteria
7. Click Find Now. You see all balances on which the selected business partner is Responsible Business Partner.
   For all the businesses included in the list the business partner defined in the field New Responsible Business Partner is registered on the Assumed Business as Cedent and on the Retrocessionaire’s Participation’ as Retrocessionaire.
   For a highlighted balance you can open the Business Ledger or the Business properties in case you need to investigate further before executing the mass update.
8. Highlight the balances you want to include in the mass update by selecting Exclude/Include option from the pop-up menu.
9. Select Mass Update from the pop-up menu. The system make reversal bookings of the included balances with the current business partner and replacement bookings of the included balances with the new business partner as Responsible Business Partner.
10. You can inspect the created bookings by selecting View Technical Worksheet/View Claim Worksheet from the pop-up menu. Note! The new worksheets are automatically set to Closed so it is important that you make attention to the above points 7 and 8.

Execute the Mass Update of the responsibility of Business Partners #

When the actual balances have been found and included in the Business Partner Balance Mass Update balance list, and a New Responsible Business Partner is defined the user can select the option Mass Update from the pop-up menu in the balance list.

Dependent on the Settlement Indicator of the selected balances the system will do the following:

Unsettled #

• A reversal balance is booked for each of the balances included in the list
• The Responsible Business Partner linked to the reversal balance is the Business Partner in the field Current Responsible Business Partner
• The reversal balance is paired with the source balance so that both the source and the reversal balance are marked Settled
• A replacement balance is booked for each of the balances included in the list
• The Responsible Business Partner linked to the replacement balance is the Business Partner in the field New Responsible Business Partner
• The replacement balance is marked Unsettled

Exceptions #

In case the Unsettled balance is part of either a Settlement Balance Group or an Account Balance Group both the source balance, the reversal balance and the replacement balance becomes Unsettled

Partially Settled #

• A reversal balance is booked for each of the balances included in the list
• The Responsible Business Partner linked to the reversal balance is the Business Partner in the field Current Responsible Business Partner
• The source balance Remains Partially Settled
• The reversal balance is marked Unsettled
• A replacement balance is booked for each of the balances included in the list
• The Responsible Business Partner linked to the replacement balance is the Business Partner in the field New Responsible Business Partner
• The replacement balance is marked Unsettled

Settled #

• A reversal balance is booked for each of the balances included in the list
• The Responsible Business Partner linked to the reversal balance is the Business Partner in the field Current Responsible Business Partner
• The Responsible Business Partner linked to the replacement balance is the Business Partner in the field New Responsible Business Partner
• Balance Pairing is created between the reversed balance and the replacement balance so that both becomes Settled

Other special rules: #

Extraction of one Insured Period when included in a balance containing more than one Insured Period

• Responsible Business Partner is according to above
• All details with the extracted Insured Period within the listed balance are reversed.
• The balance amount of the reversals/replacements will be different from the source balance
• The source balance remains unchanged
• The reversed balance is marked Unsettled
• The replacement balance is marked Unsettled
• No pairing is created between the reversed balance and the replacement balance

Booking Period #

System assigns a Booking Year and Period according to the Booking Year and Period of the source details. If this Booking Year and Period is closed, the system assigns the default Booking Year and Period defined for the Base Company of the reversal/replacement balance.

Due Date #

The Due Date of the individual reversal/replacement balance is set equal the Due Date of source balance.

Worksheet Origin #

A special Worksheet Origin is assigned to the reversal/replacement balances created by the Business Partner Balance Mass Update, named Bp Balance Mass Update

Release Indicator #

If some of the details are within the Entry Code Categories;

• Cash Claim
• Deposit
• Non-Liquid Deposit
• Premium Due Later

The Released indicator of the reversal/replacement detail is set to the same value as the source detail and if it is set to Released, no detail pairing is created

Booking on Retrocessionaire’s Participations #

Additional to the above description of the bookings created by the Business Partner Balance Mass Update there is one special rule for bookings on Retrocessionaire’s Participations. The booking detail included in the reversal/replacement balance has a Retro Detail Pairing to the same detail as the details in the (source) balance being reversed and replaced.

Update Last Completed Booking Year #

When you double-click the Last Completed Booking Year icon, you can select one or more businesses (from the Find Business window), and enter a year for which the Last Completed Booking Year on the business should be updated.

When you click the OK button, the Last Completed Booking Year is updated on the selected businesses and is shown in the Business Ledger and the Online Statistics windows.

Replace Business Partner on Open Reserves and Deposits #

Sometimes one business partner takes over businesses and their balances from other business partners, for example, after a company merger. The new business partner can then acts as an administrator for these businesses or take over the complete responsibility for the businesses and balances from the old business partner from a specified date. When the latter is the case, also open historical reserves and deposits balances should sometimes be transferred to the new business partner.

SICS has the functionality to replace the old business partner with the new business partner on the business and to transfer all the administration tasks, including the payment task to the new business partner. Functionality also exists to replace the old business partner with the new business partner both as responsible business partner and expected payment business partner on balances. This can be done for both unsettled, partially settled and settled balances for defined booking periods and/or due dates.

This mass update is used to transfer open historical reserves and deposits details from the old business partner to the new business partner after a company merger for level of businesses: ‘Assumed Business and ‘Retrocessionaire Participation’.

Running the Reserve and Deposit Detail Mass Update #

Note! Note! DXC recommends that you update the Business Partners on the relevant Businesses and related Balances before the business partner shift takes place on open reserves and deposit.
See the Business Partner Roles Mass Update section in the Periodic Function chapter in the System Administration Guide for more information.
See also the Business Partner Mass Update on Balances earlier in this chapter.

Note! Note! Also note that businesses with open worksheets will be excluded from the mass update order. Businesses with open worksheets will be listed when the mass order is finished. To be able to have these businesses included the user must either Close or Inactivate the open worksheets and then run the order again.

To run the mass update:

1. Click the Reserve And Deposit Detail Mass Update icon in the Periodic Functions /Accounting Mass Update folder on the desktop. You see the Reserve And Deposit Detail Mass Update window.

2. Define the business and balances filter criteria by entering the required data in the fields. 3. Add the businesses to the display list.

• • Select the Add New Business option from the Menu button.
• option from the Menu button to let SICS find and display the business.

4. Exclude/include businesses from the list by using the Exclude/Include or_Exclude All/Include All_ options on the pop-up menu. The status ‘Yes’ in ‘Included’ column on the display list tells you which businesses are included.
5. Click the Mass Update button or select the Run Mass Update/Run Mass Update For Selected option from the Menu button.
6. Inspect the Claim- or Technical worksheet which SICS has created. To view either: Select View Technical Worksheet or View Claim Worksheet from the Menu button and then select View Worksheet.
7. From the View Worksheet window select Close Remaining Open Worksheets or Inactivate Selected Open Worksheets.

Re-running the Mass Update #

If you are not satisfied with the results of the mass update and you want to include/exclude more businesses you can re-run your mass update.

To re-run your mass update:

1. Select and inactivate the Selected Open Worksheets from the View Worksheet window.
2. Remove worksheets from the Reserve And Deposit Detail Mass Update by selecting the Remove All Worksheets from the Menu button.
3. Change the actual Business or Balance Criteria and follow the above “To Run the Mass Update” description from point 3.

Note! Note! If you remove the worksheet before it is inactivated it remains in the database as an open worksheet. An open worksheet must either be Closed or Inactivated before the involved business again can be included in another mass update.

Change Balance Pairing Status by Mass Update #

When Pending Status for Balance Pairing is in use in your system, the pairing status can be changed to Definite either manually from the Business Partner ledger, or through the Accounting Balance Pairing Status Mass Update function.

To change the status on a Pending Pairing to Definite by Mass Update:

1. Click on the Accounting Balance Pairing Status Mass Update icon in the Periodic Functions / Accounting Mass Update folder on the desktop. You see the Accounting Balance Pairing Status Mass Update window.
2. Click on Find Now to list all Pending Pairings, represented by their driving balance. You can limit the list by entering From and/or To dates in the Pairing Date Included between fields.
3. From the menu you have the option to include/exclude selected Pairings or include/exclude all Pairings. All Balance Pairings with Yes in the Included column will be included in the Mass Update.
4. Enter the Booking Year and Period to be used on the Balance Pairings.
5. Select Run Mass Update from the menu to change the status on all included Balance Pairings to Definite.

If your system has been set up to use Balance Pairing Group, each Balance Pairing will get a Pairing Id. In the Accounting Balance Pairing Status Mass Update window, this Id is shown in the Pairing ID column. Included Yes/No to specify whether or not to include in Mass Update is selected per Pairing Id. If a Pairing Id has more than one driving balance (i.e. it is created in the Pairing Group process), the Yes/No indicator must be the same for all driving balances. If a driving balance has more than one pairing Ids, these pairing Ids are shown one by one in separate rows, and it is possible to select per Pairing Id whether or not to include in Mass Update.

The number of Pairing Ids listed within the specified pairing period is shown in a field below the container.

Mass Pairing #

The Mass Pairing Order matches Unsettled Received Remittances with Unsettled and Partially Settled balances of type Technical, Claim, Cession, Expected Payment, Account Balance and Settlement Balance (later in this chapter referred to as Included Balances). When a match is made, system automatically creates a Balance Pairing between the Remittance (as the Driving Balance) and the Included Balance.

When the Mass Pairing Order is run, it goes through 5 different processes:

1. Extract Remittances to be included

The Order selects Unsettled Received Remittances with specified Base Company/Companies, Payment Partner(s), Remittance Type(s), Direction and with Final Date equal to or later than the specified date. If no extraction is made on the order, all Base Companies and/or Payment Partners and/or Remittance Types and/or Directions and/or Final Dates will be included. Only Unsettled, Received Remittances with status equal to Final are included, i.e. no Partially Settled Remittances are included. Remittances already linked to a single balance or a Balance Group are excluded. 2. Extract Included Balances to be matched with the Remittances

The Order selects unsettled or partially settled balances of type Technical, Claim, Cession, Account, Settlement Balance and Expected Payment. Balances which are included in Account- or Settlement Balances will NOT be included as such, but the relevant Account- or Settlement Balance will be included and the balances included in the matched groups will be paired. If a balance has an Expected Payment balance, system tries to match the currency and amount of the Expected Payment balance, not with the Original Balance. Balances already linked to a Remittance balance will be excluded. 3. Match extracted Remittance balances with extracted Included balances

The actual matching process depends on the Matching Routine defined on the Mass Pairing Order. a) When Match on Unique Reference is selected on the Order, the system enables some reference fields representing various fields on the Included Balances. By default all fields are selected. The user can select one or more of these fields, at least one must be selected. By limit the matching to only one reference field, e.g. BP Reference, this will increase the performance. The system reads the reference entered in the Partner’s Reference field on the Remittance and searches for matching references in all the selected fields on the Included Balances. For Technical-, Claim, and Cession balances, system searches through the following fields when they are selected: BP Reference, Worksheet Id, TA Process ID, CL Process ID, London Reference, Bulk Reference, Referred eMessage UUID, eMessage UUID and Resett Reference. For Expected Payment balances system searches through the same fields for the belonging original balance. For Settlement and Account balances, system searches for match by use of the Worksheet Id and the BP Reference and match it with the Balance Group Identifier and the Reference field. When match is found, system checks if the currency and amount of the Remittance matches the currency and amount of the Included balance. If a Tolerance Limit is defined on the Order, the amount is defined to match if the difference between the two amounts is within the defined Tolerance Limit. If no Tolerance Limit is defined, the amounts must have an exact match. In addition, system checks the Due Date on the Remittance against the Due Date on the Included Balances. Only Included Balances with a due date less than or equal to the Due Date on the Remittance + number of days defined in the Due Dates in future field on the Order are matched. b) When Match on Payment Partner is selected on the Order, the system matches the Payment Partner on the Remittance with the Payment Partner on the included balances. For Remittance Balances and Included balances with same Payment Partner, system checks if the currency and amount of the Remittance matches the currency and amount of the Included balance. If a Tolerance Limit is defined on the Order, the amount is defined to match if the difference between the two amounts is within the defined Tolerance Limit. If no Tolerance Limit is defined, the amounts must have an exact match. In addition, system checks the Due Date on the Remittance against the Due Date on the Included Balances. Only Included Balances with a due date less than or equal to the Due Date on the Remittance + number of days defined in the Due Dates in future field on the Order are matched. If a remittance balance matches more than one included balance, no pairing will take place. 4. Create Balance Pairing between Remittance and matched Included Balance

When the matching is complete, system automatically creates Balance Pairings for the matched balances, with the Remittance balance as the driving balance. If a Tolerance Limit has been defined on the Order and the Remittance amount is different from the amount of the Included Balance, a Write Off is created in the pairing. When the Remittance Balance is paired with more than one Included Balance (i.e. paired with a balance group) any Write Off is created on the pairing object with the largest balance (absolute amount). If the currency of the Remittance Balance is different from the currency of the Included Balance an exchange rate difference is created. If a match is found between the remittance balance and a balance group (SBG or ABG) the pairings are created between the remittance and the members of the group. 5. Create a log on Remittances included in the order

When the matching and pairing has taken place, system writes a log in the Notes field on each remittance Balance that was included in the order. This log includes the Order Id, date and time when it was run, whether or not the remittance was paired and the reason for not pairing if it was not paired.

Create and run the Mass Pairing Order #

1. In the Periodic Functions folder, select Mass Pairing. This opens the Find: Mass Pairing Orders window.
   
   
2. Press the Create New button or right click in the list and select New from the menu to create a new order
   
   
3. Specify the different extract and matching criteria
4. Select the option “Update Paid Column in Administration Condition” if wanted
5. Press OK to save the Mass Pairing Order
6. Press the menu button and select Run Now to run the Order

Mass Pairing of Paid Remittance #

The Mass Pairing Of Paid Remittance Order makes an Automatic Balance Pairing between a Paid Remittance with Status ‘Final’ and a linked Unsettled balance of type Technical, Claim, Cession, Expected Payment and Settlement Balance (later in this chapter referred to as Included Balances). Both the Remittance and the Included Balance are marked as Settled after the pairing.

When the Mass Pairing Order is run, it goes through 4 different processes:

1. Extract Remittances to be included
   The Order selects Remittances with specified Base Company/Companies. If no extraction is made on the order, all Base Companies will be included. Only Unsettled, Paid Remittances with status equal to Final are included, i.e. no Partially Settled Remittances are included. The Remittance balance must have a link to an Included Balance.

2. Extract Included Balances to be matched with the Remittances
   The Order selects unsettled balances of type Technical, Claim, Cession, Settlement Balance and Expected Payment with a link to the extracted Remittance (refer to 1 above). Balances which are members of Settlement Balances will NOT be included as such, but the linked Settlement Balance will be included and the member of the Settlement Balance will be paired.

3. Create Balance Pairing between Remittance and linked Included Balance
   When the extraction is completed, system automatically creates Balance Pairing between the extracted Remittance balance and the linked Included Balance (for a linked balance group it is the members of the group that are paired with the remittance). Validations are performed according to online functionality ‘Automatic Balance Pairing’ (started from the Business Partner Ledger).

4. Create a log on Remittances included in the order
   When the pairing is completed, system writes a log in the Notes field on each involved Remittance Balance. This log includes the Order Id, date and time when it was run. If no pairing took place, the reason for the failure (i.e. error message text/- id) is also written in the Notes field.

Create and run the Mass Pairing Of Paid Remittance Order #

1. In the Periodic Functions folder, select Mass Pairing Of Paid Remittance. This opens the Find: Mass Pairing Of Paid Remittance Orders window.
   
   
2. Press the Create New button or right click in the list and select New from the menu to create a new order
   
3. Enter a title for the order if you want
4. Specify the extract criteria (Base Company)
5. Select the option “Update Paid Column in Administration Condition” if wanted
6. Press OK to save the Mass Pairing Of Paid Remittance Order
7. Press the menu button and select Run Now to run the Order

Estimate Settlement Indicator Mass Update #

When booked, the Settlement Indicator on all non zero Estimate balances are set to Unsettled. Since Estimate balances cannot be included in balance pairing, the balances will always remain Unsettled. If you want to mark these balances as Settled when the estimation is complete and the accruals are reversed, this can be done with the Estimate Settlement Indicator Mass Update.

The Mass Update selects all Unsettled balances with details matching the criteria on the order. If option “Validate Complete Flag” is selected, the Period Estimates on each section will also be checked. For the Insured Period to be included, all Estimation items with a liquid Accrual Entry Code defined in the Period Estimation rules must be set to Complete. I option “Validate Complete Flag” is cleared, the Complete Flag in Period Estimates are not validated.

For all balances matching the above, the order will check if the liquid details sum up to zero on each Insured Period, Section and Currency. If this is the case, the Settlement Indicator on the balances will be changed to Settled. In addition, the Unsettled Amount on each balance is set to 0.

Create and run the Estimate Settlement Indicator Mass Update #

In the Periodic Functions folder, select Estimate Settlement Indicator Mass Update. This opens the Find: Estimate Settlement Indicator Mass Update Orders window.

Press the Create New button or right click in the list and select New from the menu to create a new order

1. Enter a title for the order if you want
2. Specify the extract criteria. Mandatory criteria are U/W Year (both From and UpTo), Level of Business and Base Company
3. Select option ‘Validate Complete Flag’ if you want the mass update only to include businesses where the Complete indicator is set in Period Estimates on all Estimation Items which is linked to liquid entry codes.
4. Press OK to save the Estimate Settlement Indicator Mass Update Order
5. Press the menu button and select Run Now to run the Order