Liability Description
The liability is calculated from the customer's leasing contracts and entries, and is displayed on the customer card and in the Customer Liability report.
Liability view
There are two ways to view a customer's liability:
Liability on customer card
Customer's Liability from choice Risk Reports
Liability on customer card
On the customer card, the liability is shown in the Liability (LCY) field. The value of the field is calculated as the sum of the liability in local currency from the table: "Customer Liability" for all contracts of the customer.
When clicking on the "Liability (LCY)" field, the records from which the liability was calculated for the given customer will be displayed ("Customer Liability" records filtered to the customer number will be displayed).
For the logic of the obligation calculation, see below.
Customer's Liability from Risk Reports
The customer's liability can be opened from the option Risk Reports – Customer Liability
After clicking on the Customer Liability option, the Customer Liability table opens, which displays data for all customers and contracts.
The meaning of the fields is described below in the chapter Customer Liability Calculation Logic:
Financing Contract No.
Detailed Contract Status
Customer No.
Financing Type
Currency Code
Debit without Interest
Debit without Interest (LCY)
Open Items
Open Items (LCY)
Liability Amount
Liability (LCY)
Payment Periodicity
Purchase Price of Financing Objects
Down Payment
Residual Value
Date and Time of Insert
Date and Time of Update
The user can use the filter to filter the liability to a specific customer and his contracts, or the type of financing. Using the arrow on the right side of the mountain, it is possible to open the customer's obligation, or edit it in Excel, or copy the link.
Liability Calculation
The calculation of the liability is performed according to the underlying data in the table: "Customer Liability". The data in the underlying table must be updated regularly using the function: "Calculate customer liability". Manually by using the Calculate Customer Liability function, or by setting a job to a job queue (Job Scheduler).
The function can be run manually on a single customer or on all customers in a given company.
We recommend that you run the payability calculations for one customer manually during the day (if necessary) and have a periodic task set up in the task scheduler overnight to calculate the payable for all customers.
The Calculate Customer Liability function is located in the Customer Liability table on the bar.
After running the Calculate Customer Liability function, the Request form is displayed, where it is possible to set up filtering of customers for whom the liability is to be calculated.
"Customer" tab
No. – set the filter for customer numbers for whom we wish to calculate the liability. If the field is not filled in, the liability will be calculated for all customers in the company.
Add filter – To generate the report, it is possible to add any other filter to the customers for generating the report, for example: "Post Code", "Country", etc.
Buttons/Functions
Schedule – use this function to set the task to run later
OK – The function starts the calculation of the liability for customers, according to the set filters
Cancel – Close the Request form to generate a customer liability report
Customer Liability Calculation Logic
The Customer Liability and the data displayed in the Customer Liability table are filled using the function: "Calculate Customer Liability".
Logic of filling in individual fields in the table: "Customer Liability":
Field Name | Fulfillment Description | Source Table ID | Source Table Name | Source ID Field | Source Field Name |
Financing Contract No. | Financing Contract No. of the lease agreement | 4026397 | Financing Contract Header | 1 | Well. |
Customer No. | Contract Customer No. | 4026397 | Financing Contract Header | 2 | Customer No. |
Financing Type | Contract Financing Type | 4026397 | Financing Contract Header | 19007 | Financing Type |
Currency Code | Contract Currency | 4026397 | Financing Contract Header | 350 | Currency Code |
Debit without interest | The principal sum of all unposted payments for the contract in the contract currency
For contracts in Stave=Settled, Archived, the value is 0.
Field sum: "Principal" (10) of all payments for a given contract where field: "Posted" = FALSE" AND "Type" (6) = "Payment" If there is a different currency from the contract header in the "Currency Code" (350) field, then the value will be converted to the currency of the contract, according to the last exchange rate from the table: "Currency Exchange Rate" | 4026398 | Financing Contract Line | 10 | Principal |
Debit without Interest (LCY) | If the currency of the contract differs from the local currency of the company, the system will convert Debit without Interest to the local currency. If they do not differ, the system inserts the same value as in the Debit without Interest field. | 4026398 | Financing Contract Line | 10 | Principal |
Open Items | Contract Balance If the contract is with a Financing Type other than Instalment Sale: If these are contracts with Financing Type=Instalment Sale: - the system detects Document No. (SP) (19355) from the Contract Header and does not include the Remaining Amout (or Rem.Amuont (LCY) from this document in the Open Items
If there is a different currency on any customer entry in the field: "Currency Code" (1) compared to the contract header, then the value will be converted to the currency of the contract, according to the last exchange rate from the table: "Currency Exchange Rate" (the rate with the highest date) | 18 | Cust. Ledger Entry | 14 | Remaining Amount |
Open Items (LCY) | If the contract currency differs from the local currency of the company, the system will convert Open Items to the local currency. If they do not differ, the system inserts the same value as in the Open Items field. | 18 | Cust. Ledger Entry | 16 | Remaining Amount (LCY) |
Liability (Liability) | Contract Liability Value - Sum: Open Items + Debit Interest
Field Sum: "Debit without Interest" + "Open Entries" |
|
|
|
|
Liability (LCY) | Contract Bond Value in Local Currency - Sum: Open Items (LCY) + Debit on Interest (LCY) Field Sum: "Debit without Interest (LCY))" + "Open Entries (LCY))" |
|
|
|
|
Payment Periodicity | Periodicity of Lease Agreement Payments | 4026397 | Financing Contract Header | 22 | Part Payment Period |
Purchase Price of Financing Object | Input Price from Leasing Agreement | 4026397 | Financing Contract Header | 34 | Input Price |
Down Payment | Down Payment from Leasing Agreement | 4026397 | Financing Contract Header | 31 | Down Payment |
Residual Value | Residual Value from Leasing Agreement | 4026397 | Financing Contract Header | 33 | Residual Value |
Date and Time of Insert
| In the case of creating a new record, then the current date and time |
|
|
|
|
Date and Time of Update | If it is an update of an existing record, then the current date and time |
|
|
|
|
At the end of the fulfillment, the system deletes rows from the table that were not updated during the calculation.