Job Mass Insurance Contract Change Can be run from the Role Center Insurance across Actions/Changes/
Multiple Task A multiple task creates change copies of a financing contract and makes a change of changes insurance on them. The adjusted rates are stored for the modified insurance contract in the Insurance Contract Rate Changes table. The calculation of the insurance policy after modification is carried out in a standard way using the entry in the table of changes with regard to the validity of the rate.
User Setup
The right to run a batch task or edit "change of insurance contract rate" is granted only to a the user who has checked the field in the user settings Allow Change Insurance Contract Rate Change (Allow Change Insurance Contract Rate).
User Setup (User Setup) is described in detail in the PD_Business Settings document.
Contract Change Queue Sheet
It is necessary to set the "code" to the table for the batch task job Contract Change Queue Sheet (Contract Change Queue Batch) for a batch bulk job. The worksheet must have a check mark in the Insurance Contract Change field (Insurance Contract Change).
...
Types of Mass Insurance Changes
It is necessary to create for a mass change in of the rate of insurance contracts Insurance Mass Change Type (Insurance Mass Change Types).
Code (Code)
The user enters the designation of the type of mass insurance change
Description (Description)
The user enters a description
Type of Change Type (Type of Change)
The user User selects Change Insurance Rates from the list
Contract Change Type (Contract Change Type)
User selects a change from the Contract Change Types table
It will be saved in the Contract Change History after the change is made
Contract Change Queue Sheet (Contract Change Queue Sheet)
User The user selects the Contract Change Queue Sheet from the table, filtered to Insurance Contract Change flag
Insurance Termination Code (Insurance Termination Code)
Prepared for mass fuse termination - CR 164
Mass
...
Rate Change of Insurance Contracts
A user with permission can run a multiple mass task directly from the menu of the Insurance rollcenter (Insurance).
Specifying Job Parameters and Filters
The system opens a dialog box for you to enter entering the job parameters in the Options section (Option).
...
Insurance Company No. (Insurance Company No.)
It is necessary to select the insurance company for which the rates are changing
Insurance Product No. (Insurance Product No.)
You need to select an insurance product
Change Valid From (Change Valid From)
The user enters the beginning of the validity of a new rate, changed by the coefficient
Tenant Coefficient (Client Coefficient)
The user enters the coefficient for the recalculation of the insurance rate towards the client
If the rate does not change for the client, the user enters a coefficient of 1
Insurance Company Coefficient (Insurance Company Coefficient)
The user enters the coefficient for the recalculation of the insurance rate against the insurance company
If the rate with respect to the insurance company rate does not change, the user enters a coefficient of 1
In addition to the mandatory parameters, the user can limit restrict the rate changes using by other parameters, e.g. only change the rates for a specific variant of the insurance product, etc.
In the second On the Options tab in the first part of the dialog box, the user can enter data into the following fields:
Reason for Termination of Insurance Contract(Insurance Contract Termination Reason)
If the termination code is set on the Insurance Mass Change type, the system will pre-fill it. The user can change.
The reason for termination is then filled in by the system on the terminated insurance policy for possible use in reports.
Note (Descript)
The user can enter a text that the system will write into the Contract Change History for individual contracts that it processes
In the second part of the dialog window, it is possible to specify by means of filters over which financing contracts the change is to should be made.
The user can select a filter based on the fields from the header of the financing contract, e.g. a specific customer. Then the system looks for insurance policies only in the customer's contracts.
If the user does not specify any filter in the Filter: Financing Contract Header section, the system would perform the change over the entire portfolio of leasing contracts. Therefore, it prints a warning.
When you press After pressing Yes, it will start changing insurance policies over all leasing contracts, which can be time-consuming.
Controls
After confirming "OK", the task checks will check the required fields in the dialog box:
Type of Change Type
Insurance Company No.
Insurance Company Product No.
If all required fields are not entered, it will warn you warns with an error message. If the dialog box is filled in correctly, the system continues with checks:
Checking the Contract Change Queue Sheet
The contract change queue Contract Change Queue sheet for the change of insurance contracts Insurance Contract Change Queue must be empty. The previous change must be processed, i.e. the change copies are "transferred" or "deleted". Otherwise, the system outputs an error message:
...
Checking Financing Contracts
The system goes through the leasing contracts that match the filters entered in the dialog window and at the same time there is an insurance contract of the selected insurance company and product, valid at the time of the start of the change. Contracts must be in the status "Active", this is not a variant, i.e. the system adds fixed filters of the financing contract to the filters entered via the dialog window:
Calc.Variant = No
Status = Aktive
Change Copy Check
The system goes through leasing contracts and checks whether they are not change copies. If such a contract existsthere is one, it will record the an error message in the Insurance Contract Change Log "Financing Contract XXX is a Change Copy. Insurance contract will not be processed" and the system continues on the next contract.
Contract Payment Schedule Calendar Checks:
Whether at least one posted regular payment is madehas been posted.
If no such a payment does not exist exists (i.e. the contract is after activation and before the first regular payment is posted), then it writes an error message into the Insurance Contract Change Log, records an error message and does not process this contract and continues on with the next contract.
Checking Posted RS Payments
Checks contracts to see if On contracts, it checks whether the contract has an unposted RS payment. If such a contract exists, it does not process this contract, enters it into the Insurance Contract Change Log and continues to the next contract
Check for unposted regular payment
It checks the contracts to see if the contract has not yet posted to be accounted for a due payment. If such a payment an installment does not exist, it does not process this contract, but enters it in the Insurance Contract Change Log and continues to the next contract.
Note: If the last payment is posted on the contract and the automatic renewal will not take place until the next month is posted, no a change copy will not be created for the that contract and the contract will not be included in the queue of for changes to the insurance contract
The task continues by creating change copies of financing contracts that have successfully passed the checks, writing them in the Contract Change History, changing the insurance policies on the change copy, and writing them in the Insurance Contract Change Queue.
FinallyAt the end, he writes a summary of changed and erroneous contracts:
Changes
...
made to the change copy
The Insurance Contract Change Queue sheet is fullfilled
It is important to select the Sheet Name (Batch Name).
In the queue for changes to the insurance contract change queue, there is information about the change made, the leasing contract and the insurance policy:
Queue Sheet Name (Description of Contract Change Queue Sheet)
Entry No. (Entry No.)
Date Changed (Date Change)
Contains "Change Valid Change From" when the job is run
Type of Change (Type of Change)
Which type of mass insurance change has been triggered
Financing Contract No. (Financing Contract No.)
Customer No. (Customer No.)
Customer Name (Customer Name)
Contract Status (Contract Status)
Detailed Contract Status (Detail Contract Status)
Object Handover Date (Handover Date)
Expected action (Expected Termination Date)
Financing Period (Financing Period in Months)
Insurance Contract No. (Insurance Contract No.)
Insurance Contract Valid From (Insurance Contract Valid From)
Valid To Insurance Contract (Insurance Contract Valid To)
Insurance Company No. (Insurance Company No.)
Insurance Product No. (Insurace Product No.)
Framework Agreement No. (Framework Agreement No.)
Set No. (Set No.)
Original Tenant Monthly Insurance Amount (Original Client Month Amount)
Amount Before Changebefore change
New Tenant Monthly Insurance Amount (New Client Month Amount)
Amount after change
Original Insurance Company Monthly Amount (Original Company Month Amount)
Amount Before Changebefore change
New Monthly Insurance Company Amount (New Company Month Amount)
Amount after change
User ID (User ID)
...
602,000 / 100 * 2.4 (rate) * 0.95 (final coefficient) = 13,725.6
Original Annual Insurance Company Year AmountPremiums = 13,725.6:
602,000 / 100 * 2.4 (rate) * 0.95 (final coefficient) = 13,725.6
...
602,000 / 100 * 3.6 (rate) * 0.95 (final coefficient) = 20,588.4
Up-to-date Annual Insurance Company Year AmountPremiums = 30,622.51
602,000 / 100 * 3.12 (rate) * 0.95 (final coefficient) = 17,843.28
...
Insurance calendars are calculated at the changed rate from the beginning of the date of the respective change to until the end of the contract.
The record is registered in the Insurance Contract Change Queue.
A record of changes in to insurance contracts is also in the Insurance Contract Change Log.
The table can contain Table Insurance Contract Change Log (Insurance Contract Change Log) It contains the following information:
Entry No. (Entry No.)
Financing Contract No. (Financing Contract No.)
Insurance Contract No. (Insurance Contract)
Type of Change Type (Type of Change)
What type of change the job task was run with.
The log is common for all three types of mass changes to insurance contracts
Financing Contract Filter (Financed Contract Filters)
The system saves the filter above the financing contract header when the job is runstarted
Result (Result)
A positive result is marked as Success, a negative result as an Error
Error Text (Error Text)
In the event of an error, an error message is logged
Change Copy (Change Copy)
Change Copy Operations - whether there is a Change Copy Operation - whether Transfer or DeletionDelete of Change Copy has occurred
User ID (User ID)
The user who performed the action
For each Financing Contractfinancing contract, an entry is made in the Contract Change History Overviewoverview (Contract Change History) .
"Change Code" (Contract Change Type) in the history of contract change history changes according to the setting to "Insurance Mass Change Type" (Insurance Contract Change).
If a user entered a "note" when running the a task, its text was carried over transferred to the contract history.
Completion of Mass Insurance Contract Change
The user can check the results on of the change copies from the change queue of the insurance contract change queue and then transfer the change copies or delete the change copies.
It is possible to select and transfer or delete selected change copies via the markupmark.
Or perform Bulk a Mass Transfer or Deletion.
If the processed batch is not on the queue sheet of insurance contractscontract changes, it is not possible to insert another batch via the mass taskbatch job.
Starting via the scheduler
The task is modified so that it is possible to run via the scheduler - the Schedule button... (Schedule...) in the dialog box.
...
If the task will be run via the Schedule button... (Schedule...), the processing is taken over by the scheduler, then the presence of the user is not necessary required during the process.
The task is modified so that when if it is run via Schedule, it does not display any messages.
According to the scheduled date and time, the task will create a change copy, change insurance and write it to the insurance change queue and to the change log.
Mass Termination of Insurance Contracts
A user with permission can run a multiple mass task directly from the menu of the Insurance rollcenter (Insurance).
Specifying Job Parameters and Filters
The system opens a dialog box for you to enter entering the job parameters in the Options section (Option).
...
Insurance Company No.
It is necessary to select the insurance company for which the rates are changing
Insurance Product No.
You need to select an insurance product
Change Valid From (Change Valid From)
The user enters the end date of the insurance contracts, i.e. , that is, Valid to on the policy
Reason for Termination of Insurance Contract(Insurance Contract Termination Reason)
If the termination code is set to the insurance mass change on the Insurance Mass Change type, the system will pre-fill it. The user can change it.
The reason for termination is then filled in by the system on the terminated insurance policy for possible use in reports.
Note (Descript)
The user can enter the a text that the system will write into the Contract Change History for individual contracts that it processes
In addition to the mandatory parameters, the user can limit restrict the termination of insurance policies using by other parameters, e.g. only terminate insurance policies with a specific framework agreement, etc.
In the second part of the dialog window "Filter:Financing Contract Header" dialog window, it is possible to specify over which financing contracts the change is to be made.
If the Mandatory Product box field is checked on the insurance product (Mandatory Product).
...
After pressing Yes, it will terminate according to the specified parameters.
Controls
After confirming "OK", the task checks will check the required fields in the dialog box:
Type of Change Type
Insurance Company No.
Insurance Company Product No.
If all required fields are not entered, it will warn you warns with an error message. If the dialog box is filled in correctly, the system continues with checks:
Checking the Contract Change Queue Sheet
The contract change queue Contract Change Queue sheet for the change of insurance contracts Insurance Contract Change Queue must be empty. The previous change must be processed, i.e. the change copies are "transferred" or "deleted". Otherwise, the system outputs an error message:
Checking Financing Contracts
The system goes through the leasing contracts that match the filters entered in the dialog window and at the same time there is an insurance contract of the selected insurance company and product, valid at the time of the start of the change. Contracts must be in the status "Active", this is not a variant, i.e. the system adds fixed filters of the financing contract to the filters entered via the dialog window:
Calc.Variant = No
Status = Aktive
Change Copy Check
The system goes through leasing contracts and checks whether they are not change copies. If such a contract existsthere is one, it will record the an error message in the Insurance Contract Change Log "Financing Contract XXX is a Change Copy. Insurance contract will not be processed" and the system continues on the next contract.
Contract Payment Schedule Calendar Checks:
Whether at least one posted regular payment is madehas been posted.
If no such a payment does not exist exists (i.e. the contract is after activation and before the first regular payment is posted), then it writes an error message into the Insurance Contract Change Log, records an error message and does not process this contract and continues on with the next contract.
Checking Posted RS Payments
Checks contracts to see if On contracts, it checks whether the contract has an unposted RS payment. If such a contract exists, it does not process this contract, enters it into the Insurance Contract Change Log and continues to the next contract
Check for unposted regular payment
It checks the contracts to see if the contract has not yet posted to be accounted for a due payment. If such a payment an installment does not exist, it does not process this contract, but enters it in the Insurance Contract Change Log and continues to the next contract.
Note: If the last payment is posted on the contract and the automatic renewal will not take place until the next month is posted, no a change copy will not be created for the that contract and the contract will not be included in the queue of for changes to the insurance contract
The task continues by creating change copies of financing contracts that have successfully passed the checks, writing them in the Contract Change History, changing the insurance policies on the change copy, and writing them in the Insurance Contract Change Queue.
FinallyAt the end, he writes a summary of changed and erroneous contracts:
Changes
...
made to the change copy
The Insurance Contract Change Queue sheet is full.
...
The insurance policy is calculated in the contract payment schedule.
For each Financing Contractfinancing contract, an entry is made in the Contract Change History Overviewcontract change history overview.
If a user entered a "note" when running the a task, its text was carried over transferred to the contract history.
"Change Code" (Contract Change Type) in the history of contract change history changes according to the setting to "Insurance Mass Change Type" (Insurance Contract Change).
A record of the termination of insurance contracts is also in the Insurance Contract Change Log.
Completion of Mass Insurance Contract Change
The user can check the results on of the change copies from the change queue of the insurance contract change queue and then transfer the change copies or delete the change copies.
It is possible to select and transfer or delete selected change copies via the markupmark.
Or perform Bulk a Mass Transfer or Deletion.
If the processed batch is not on the given sheet batch of the insurance contract change queue, it is not possible to insert another batch via the mass taskbatch job.
Mass Creation of Insurance Contracts
A user with permission can run a multiple mass task directly from the menu of the Insurance rollcenter (Insurance).
Specifying Job Parameters and Filters
The system opens a dialog box for you to enter entering the job parameters in the Options section (Option).
...
Insurance Company No. (Insurance Company No.)
It is necessary to select the insurance company for which the rates are changing
Insurance Product No. (Insurance Product No.)
You need to select an insurance product
Product Variant Code (Product Variant Code)
Framework Agreement No. (Framework Agreement No.)
Insurance Set No. (Set No.)
Change Valid From (Change Valid From)
The user enters the end date of the insurance contracts, i.e. that is, Valid to on the policy
In addition to the mandatory parameters, the user can limit restrict the termination of insurance policies using by other parameters, e.g. only terminate insurance policies with a specific framework agreement, etc.
If the user enters text in the field when the task starts:
Note
The system will transfer transfers the text to the Contract Change History
In the second part of the dialog window, it is possible to specify by means of filters over which financing contracts the change is to should be made.
The user can select a filter based on the fields from the header of the financing contract, e.g. a specific customer. Then the system looks for insurance policies only in the customer's contracts.
If the user does not specify any filter in the Filter: Financing Contract Header section, the system would perform the change over the entire portfolio of leasing contracts. Therefore, it outputs a warning:
When you press After pressing Yes, it will start changing insurance policies over all leasing contracts, which can be time-consuming.
Controls
After confirming "OK", the task checks will check the required fields in the dialog box:
Type of Change Type
Insurance Company No.
Insurance Company Product No.
If all required fields are not entered, it will warn you warns with an error message. If the dialog box is filled in correctly, the system continues with checks:
Checking the Contract Change Queue Sheet
The contract change queue Contract Change Queue sheet for the change of insurance contracts Insurance Contract Change Queue must be empty. The previous change must be processed, i.e. the change copies are "transferred" or "deleted". Otherwise, the system outputs an error message:
...
Checking Financing Contracts
The system goes through the leasing contracts that match the filters entered in the dialog window and at the same time there is an insurance contract of the selected insurance company and product, valid at the time of the start of the change. Contracts must be in the status "Active", this is not a variant, i.e. the system adds fixed filters of the financing contract to the filters entered via the dialog window:
Calc.Variant = No
Status = Aktive
Change Copy Check
The system goes through leasing contracts and checks whether they are not change copies. If such a contract existsthere is one, it will record the an error message in the Insurance Contract Change Log "Financing Contract XXX is a Change Copy. Insurance contract will not be processed" and the system continues on the next contract.
Contract Payment Schedule Calendar Checks:
Whether at least one posted regular payment is madehas been posted.
If no such a payment does not exist exists (i.e. the contract is after activation and before the first regular payment is posted), then it writes an error message into the Insurance Contract Change Log, records an error message and does not process this contract and continues on with the next contract.
Checking Posted RS Payments
Checks contracts to see if On contracts, it checks whether the contract has an unposted RS payment. If such a contract exists, it does not process this contract, enters it into the Insurance Contract Change Log and continues to the next contract
Check for unposted regular payment
It checks the contracts to see if the contract has not yet posted to be accounted for a due payment. If such a payment an installment does not exist, it does not process this contract, but enters it in the Insurance Contract Change Log and continues to the next contract.
Note: If the last payment is posted on the contract and the automatic renewal will not take place until the next month is posted, no a change copy will not be created for the that contract and the contract will not be included in the queue of for changes to the insurance contract
The task continues by creating change copies of financing contracts that have successfully passed the checks, writing them in the Contract Change History, changing the insurance policies on the change copy, and writing them in the Insurance Contract Change Queue.
FinallyAt the end, he writes a summary of changed and erroneous contracts:
Changes
...
made to the change copy
The Insurance Contract Change Queue sheet is full.
A new insurance contract is created based on the change copies of on the respective contracts according to the assignment in the task.
...
The insurance policy is calculated in the contract payment schedule.
For each Financing Contractfinancing contract, an entry is made in the Contract Change History Overviewcontract change history overview.
If a user entered a "note" when running the a task, its text was carried over transferred to the contract history.
"Change Code" (Contract Change Type) in the history of contract change history changes according to the setting to "Insurance Mass Change Type" (Insurance Contract Change).
A record of the creation of insurance contracts is also in the Insurance Contract Change Log.
Completion of Mass Insurance Contract Change
The user can check the results on of the change copies from the change queue of the insurance contract change queue and then transfer the change copies or delete the change copies.
It is possible to select and transfer or delete selected change copies via the markupmark.
Or perform Bulk a Mass Transfer or Deletion.
If the processed batch is not on the given sheet batch of the insurance contract change queue, it is not possible to insert another batch via the mass taskbatch job.