/
Liability Description

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.

 

image-20240612-195935.png

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:
Field Sum: "Remaining Amount" (14) from customer ledger entries where field: "Customer No." = contract customer AND "Global Dimension 2 Code" = contract number AND "open" = "Yes"

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.