The wizard is used to change the detailed status of the contract (e.g. in case of early termination of the contract, return of the financed object, after financial settlement, etc.). The Action – Change Contract wizard option opens the Change Contract Wizard. In the first step of this wizard, in the "Change Type Code" field, the user selects a change with Wizard Object No. equal to 4046867. The "Change Contract" wizard is described in detail in the Změny smlouvy - změnové kopie / varianty Contract Changes - Change Copies/Variants
After completing the initial wizard, the "Change Detailed Status Wizard" opens:
Step 1/5
Field:
Financing Contract No.
Automatically completes the OC with the contract number (change copies/variants)
Financing Type
Fills in the OC automatically from the contract.
Customer No.
Fills in the OC automatically from the contract.
Customer Name
Fills in the OC automatically from the contract.
Object Handover Date
Fills in the OC automatically from the contract.
Detailed Contract Status
Fills in the OC automatically from the contract.
Change at Date
By default, the current working date is displayed. The user has the option to enter the date on which he wants to make the change.
Note: it is necessary to enter the date on which you want to change the detailed status:
Early termination: date of removal, date of confirmation of total, etc. This date is then entered into the Early Termination Date field on the contract, or on the subject (single-object contract) – if the target detailed contract status is Fill Early Termination Date. For multi-object contracts, writes the early termination date to those courses that have a detailed object status with field values
Early Terminated=N
After Fin. Settlement=N
After archiving=N.
After Financial Settlement: The date the financial settlement was created. This date is then entered in the Financial Settlement Date field on the contract or on the object (single-object contract) – if the target detailed contract status is Fill Fin. Settlement Date. In the case of multi-subject contracts, this date is not written by the system on the courses (the user fills in manually).
After archiving: the archive date. This date is then entered in the Actual Termination Date field on the contract, respectively. Archiving Date on Object (single-subject contract) – if it is on the target detailed contract status Fill in Actual Termination Date.. In the case of multi-subject contracts, this date is not written by the system on the courses (the user fills in manually).
In case of reverse changes, it deletes the relevant dates as follows:
Single-object contract – deletes the relevant date on the contract and on the subject
Multi-subject contract – can delete the date only on the contract, the user must delete them manually on the subjects.
Financed Object Return
Default N
Change the user to A if he/she wants to change the detailed status due to the return of the financed object, i.e. if he/she wants to add e.g. the mileage to the item when returning it (it can be related to the return/removal of the item, or even a total accident)
Switching to A changes the Item Return Date field to editable
Switch to N
Changes the Item Return Date field to non-editable, or deletes the value of the field as well
Deletes the value in the New Detailed Contract Status field, if the field has been filled in
Financed Object Return Date
Editable if Financed Object Return=A, otherwise not
The user enters the date of return of the object (e.g. from the acceptance protocol)
New Contract Detail Status
After clicking, the Detailed Status Sequence Definition table is displayed, from which the user selects the target detailed state (new desired state) – a lookup to the Det.Contr.Status Seq API. Def. (4046812) with filters:
Original Det. Status Code (1) = current Det. Contract Status
Financed Object Return = value from wizard
If Financed Object Return = N, then it is filtered to allowed det. status transitions that have Financed Object Return=N
If Financed Object Return = A, then it is filtered to allowed det. status transitions that have Financed Object Return=A
Allow Manual Status Change (10) = N – it is possible to select only those details that do not have manual status change enabled
If the Financing with Services (4026780) field is in the contract:
N – will filter to those transitions that have Financing with Services=All or N
Y – will filter to those transitions that have Financing with Services=All or Y
Early Termination Reason
The OC will add the Early Termination Code if Fill Termination Date=Y has been entered in the Detailed Contract Statuses table for the given target detailed status and if the Fill Termination Date=Y is on the given status
Editable if Fill Termination Date=Y is on the target detailed status, the user can manually delete or select another reason
The wizard then writes this value into the field of the same name in the contract header only if the target detailed status is Fill Termination Date=Y (otherwise not).
Create Partial Payment Credit
OC displays the flag for the new detailed status according to the settings on the detailed contract status
Field is non-editable
Delete Partial Payment Credit
OC displays the flag for the new detailed according to the status setting on the detailed contract status
Field is non-editable
...
searches for the last posted line (Posted=Y) of the Payment Balance Contract (any – regular, RS, partial credit...). If it finds it, it checks to see if Valid From > Date Changed on it. If so, it will display an error message that this line must not be flagged as being posted.
performs the same check as the last one in the Model block. Allow partial credit=A for insurance company calendar and insurance commission calendar, with the only difference being that when searching for active insurance contracts, it still deploys the filter Valid from is <= Date of change. Subsequently, he checks the insurance company's calendar and commission calendar in the same way as in the previous block.
Step 2/5:
This step is displayed only if in Step 1/5 there was flag Financed Object Return=A, otherwise not.
...
Note: After finishing the wizard, the entered values will be overwritten to the financed object - to the Termination tab:
Step No. 3/5
Step No. 3 is displayed only if the target detailed status is set to terminate an insurance contract in the relation table.
...
The user has to straighten the date of termination of insurance contracts with respect to the posted payment and the reported master statement to the insurance company
When the insurance policy is terminated, the system also checks the continuity of the insurance policies of the same insurance product on the contract. If the fuses do not connect smoothly to each other, the product will report a warning: "The insurance contract is not connected to the insurance contract XY valid until DD.MM.RR. Continue?"
Step No. 4/5
This step is displayed if there is a security report to be created in the Insurance Product and Status Relation to the Detailed Status.
...
Note: New insurance contracts are defined in the Insurance Product And Status Relation table (Framework Agreement No. - Liability Insurance and Framework Agreement No. - Property). If the "mandatory product" check box is entered in the "Insurance Product and Status Session" settings, the system will check for the existence of an insurance policy for the mandatory product after pressing the Finish button and will not allow the process to be completed if it is not valid
Step No. 5/5
Field:
Number of Insurance Contracts to Be Terminated
The OC will display the number of insurance contracts that will be terminated.
Number of new insurance contracts
The OC displays the number of new insurance contracts created when the contract status changes.
Number of terminated services
The OC displays the number of services that the wizard closes according to the settings in the Detail Status and Services Relation table:
The number of services from the temp table, those that have Service Status=Active and there is a record for them in the table Relation det. health and services with the flag Terminate Service=Y.
Note: The selection of services to terminate is determined by the setting in the Detail Status and Services Relation table. Here it is also possible to set the reason for the exclusion of the fuel card.
Number of blocked fuel cards
The OC displays the number of fuel cards for which the wizard sets the blocking date after transferring the change copy or variant. The important thing is that in the Relation of Detailed Status and Services table, the Fuel Card service has been set to terminate and there is a valid and not yet blocked fuel card on the object.
...
If it finds one, it creates a new line as a copy of it:
add 'PC' after the installment number
"Date From" sets as "Contract Termination Date + 1D"
"Date To" – set it as the last day in the same month as the "Date From" (at the end of the process, it is changed as "Date To" from the last posted row, but for the calculation it must leave the last day of the month).
On this new line, he resets the amounts and goes to calculate the values he will use for him:
If the last posted line satisfies that Date From <= Contract Termination Date<=Date To:
Thus, only this payment (the so-called source line) will be used for the calculation. See Example 1
If this is not met (there are subsequent posted instalments):
Searches for all posted regular payments where Date To >= Contract Termination Date.
He goes through these and creates a filter with the numbers of all installments, which are either partially or completely credited.
If the payment meets Date From < = Contract Termination Date <= Date To, it will note that it is a payment from which it will take a proportional part, from the others it will take the full amount of principal and interest. See Example 2
The new values are then calculated as follows:
Principal
Calculates the corresponding portion from the source line as follows:
If the Termination Date<>is the last day of the month, it executes:
finds the number of payment days as the difference Date To – Date From + 1 on the PC line.
Next, it finds out the number of days that the month has in total. With this ratio, the number of repayment days/days in a month multiplies the principal on the source line and thus calculates the part of the principal that will be credited from that line.
If Termination Date=last day of the month, it does not perform this calculation and continues to search for whole amounts.
To this is added the full principal amounts from any subsequent posted payments. This total value is written with a negative sign in the PC line in the Principal field
Interest
analogously, it just takes the values from the Interest field
Services
searches for contract services that have status=Active and Reflect Aliquot=Y (Example 1).
for each service found, it looks for a line in the payment calendar that has the same Contract Payment No. as the source payment of the SPK.
If such a line is found, a new PC line can be created in the SPK service:
The dates are filled in the same as the PC line in the Contract Payment Summary
The amounts will be filled in similarly
It takes a proportional part of the amount from the line that corresponds to the source line, and the entire amount of the payment/costs from the following (matching filter to the contract payment number).
It calculates the amounts in currency using the currency factor.
The total amount from all created PC service lines is entered into the TC of the contract with a negative sign in the Service field
Searches for contract services that have status=Active and Reflect Aliquot=N (see Example 2).
for each service found, it looks for a line in the payment calendar that has the same Contract Payment No. as the source payment of the SPK.
If such a line is found, a new PC line can be created in the SPK service:
The dates are filled in the same as the PC line in the Contract Payment Summary
Amounts to fill in
It doesn't take any part of the amount from the line that corresponds to the source line.
from the following (corresponding filter to the contract payment number) the entire amount of the installment/costs.
It calculates the amounts in currency using the currency factor.
The total amount from all created PC service lines is entered into the TC of the contract with a negative sign in the Service field
Insurance
searches for insurance contracts that have a Valid to Same as the Termination Date on the header of the financing contract.
Filters the client's calendar to rows that match the filter for Payment Numbers and Period To >= Contract Termination Date.
Copy the last line to the new one:
adds 'PC' to the payment number
Dates will be filled from the PC line from the T&A of the contract
He calculates the amounts as follows:
if the Termination Date<>is the last day of the month, then it takes a prorated portion of the payment that corresponds to the source line, and the entire value of the Amount and Amount (LCY) fields from the following rows.
The proportional part here is calculated differently than in the case of principal, interest and services. Calculates the daily coefficient using Period From and To on a new line and taking into account the value of the "Daily Rate Calculation" field on the insurance company's product. This coefficient is multiplied by the value of "Annual Client Insurance Premium" on the insurance contract card.
The proportional part (if calculated) is added to the whole amount from subsequent installments and the sum is written into the PC line of the client's calendar. Calculates the VAT amount. When generating these rows, it stores accumulated values in variables according to the type of basic product and insurance in total.
These values are then written to the PC line in the T&Cs of the contract in the fields Insurance, Liabilty Insurance Amount, Crash Insurance Amount and Other Insurance Amount.
Finally, in the PC line of the Bill of the contract, it validates the Amount and Balance fields to recalculate the Total Amount and Amount Including VAT and Balance fields.
if the Termination Date is the last day of the month and it is also the last posted month, then the created PC line (which is all zero) is deleted.
Example 1 – PC line for the last posted payment
Termination Date=11/10/2023, at that time in the last posted month. - there are no folded services in the PC that had Reflect Aliquot=N
...
Calculation of the share of services: The sum of services that have Reflect Aliquot YES = 2788.76. 20-day share = 1859.17, which corresponds to the value of the PC row in the Service field.
Services that have Reflect Aliquot YES
...
Example 2 – PC line for multiple months
Termination Date = 10/09/2023. On PC, the whole months are 11 and 10/23 (complete payment including all services) + aliquot 9/23 (services without Reflect Aliquot=N).
...
Example 3 – PC row in the same month as RS row
Rekalk (RS) and post. Spl. in 12/2023, in the same month also termination, i.e. in PC only an aliquot of the month of the last month.
...