OneCore Docs
OneCore Docs
Breadcrumbs

Financed Object Profitability

The profitability of the financed object is used as an auxiliary calculation before determining the selling price of the financed object before the start of the sale in the case of returning the object under operating lease. It calculates the profit made on the contract (financing, services, insurance) and compares it with the outstanding principal or book value.

Open the Financed Object Profitability report

The functionality is available only for contracts with Financing with Services (4026780)=Y in the API Financing Contract Header (4026397), via the Item List or Object Cards, via the Processing/ Object Profitability button. It can only be run from the original contract (not from a change copy or variant).

The button opens the Financed Object Profitability overview. On the overview there are buttons:

  • Update Profitability

    • When pressed, it checks the contract flags:

      • if Change Copy=Y or Calculation Variant=Y, it will display an error message and will not continue.

      • If N and N, it performs the calculation (see description below) and opens the tab.

  • Delete

    • Deletes a row.

  • Edit

    • Editing the record.


Field:

General tab:

  • Financed Contract No.

    • Empty by default.

    • Fills in the system automatically when a row is created.

  • Financed Object No.

    • Empty by default.

    • Fills in the system automatically when a row is created.

  • Line No.

    • Empty by default, the system completes when a row is created, the number of the first row will be 1, then with an increment of +1.

  • Object Name

    • Empty by default, the system fills in the Name field (19065) from the API Financed Object (4026560) from which the line is created.

  • Purchase Price Excl.VAT

    • Empty by default. Completes the system when creating a line, the Purchase Price excl. field is complete. VAT (4047140) from the API Financing Contract Header (4026397).

  • Calculation Residual Value

    • Empty by default. Adds the Residual Value Calculated field (33) from the API Financing Contract Header (4026397) to the system when creating a line.

  • Unpaid Principal Amount

    • Empty by default. Completes the system when creating a line:

      • searches for the last posted line of the SPK. It then looks for a PC (Partial Credit=Y) with a Posting Date within Valid From<=Posting Date from PC<=Valid To on the posted payment. When the PC line does not check Posted, only the existence of the PC. If there is a PC, it takes the Principal Remaining value from it. If the PC does not exist, it takes the Principal Remaining from the last posted line.

      • If it doesn't find it, it looks for the first non-billed one. If it finds, it takes the value of Principal Remaining from it. 

      • If it is not found either, it takes the "Input Price" - "Down Payment" from the contract header

  • Book Value (LCY)

    • Empty by default. Completes the system when creating a line:

    • It takes the value from the Book Value field (17) from the FA Depreciation Book (5612) - Depreciaton Books subform on the Fixed Asset Card, as follows:

      • In the Fixed Asset table (5600), it looks for a record that has the Curr API. Fin. Contract No. (4047591) the same as Financing Contract No. (10) in API Financial Settlement (4046805) - the number of the contract for which the financial settlement is created.

      • Then, according to property number No. (1), you can search for an entry in the FA Depreciation Book (5612) that has:

        • FA No. (1) = Same

        • Default FA Depreciation Book (70)=Y

      • Takes the Book Value (17) from this record

  • Book Value

    • Empty by default. Completes the system when creating a line:

      • Book Value=round(Book Value (LCY)/Contract Exchange Rate; 2)

  • Created at

    • Fills in the system automatically, date and time of creation

Services Tab

  • Maintenance Maintenance Revenues

    • Empty by default. Completes the system when creating a line:

      • Maintenance Revenues = sum of posted payments (Amount) from all services of the Service Kind=Maintenance contract (including the first aliquot and PC line) + from the unposted PC partial payment credit line (Posted=N, Partial Payment Credit=Y)

      • Note: The Unpaid Principal Amount is also taken from an unaccounted PC, so we also include uncharged PC values in the service revenues

  • Maintenance Costs (Maintenance)

    • Empty by default. Completes the system when creating a line:

      • Maintenance Costs = sum of the Reinvoiced Amount Difference values from the service permission lines of the contract (object).

      • Filter for service permit lines:

        • Service Kind=Maintenance

        • Financed Object No.=Object No.

        • Purchase Invoice Created (275)=Y

  • Maintenance Balance Maintenance

    • Empty by default. Completes the system when creating a line:

      • Maintenance Balance = Maintenance Revenues - Maintenance Costs)

  • Tire Service Revenues

    • Empty by default. Completes the system when creating a line:

      • Replenishes the system automatically:

        • Tire Service Revenues = sum of posted payments (Amount) from all services of the contract Service Kind=Tire Service (including the first aliquot and PC line) + from the unposted PC partial credit line (Posted=N, Partial Payment Credit=Y)

        • Note: The Unpaid Principal Amount is also taken from an unaccounted PC, so we also include uncharged PC values in the service revenues

  • Tire Service Costs

    • Empty by default. Completes the system when creating a line:

      • Replenishes the system automatically:

        • Tire Service Costs = sum of the Reinvoiced Amount Difference values from the service permission lines of the contract (object).

        • Filter for service permit lines:

          • Service Kind=Tire Service

          • Financed Object No.=Financial Settlement Object No.

          • Purchase Invoice Created (275)=Y

  • Tire Service Balance Billing

    • Empty by default. Completes the system when creating a line:

      • Replenishes the system automatically:

        • Tire Service Balance = Tire Service Revenues – Tire Service Costs)

  • Other Services Revenues

    • Empty by default. Completes the system when creating a line:

      • Replenishes the system automatically:

        • Other Services Revenues = sum of posted payments (Amount) from all services of the Service Kind<>Tire Service and Maintenance contract (including the first aliquot and PC line) + from the unposted PC partial credit line (Posted=N, Partial Payment Credit=Y)

        • Note: The Unpaid Principal Amount is also taken from an unaccounted PC, so we also include uncharged PC values in the service revenues

  • Other Services Costs

    • Empty by default. Completes the system when creating a line:

      • Replenishes the system automatically:

        • Other Services Costs = sum of the Reinvoiced Amount Difference values from the service permission lines of the contract (subject).

        • Filter for service permit lines:

          • Service Kind<>Tire Service and Maintenance

          • Financed Object No.=Financial Settlement Object No.

          • Purchase Invoice Created (275)=Y

  • Other Services Balance

    • Empty by default. Completes the system when creating a line:

      • Replenishes the system automatically:

        • Other Services Balance = Other Services Revenues – Other Services Costs

Insurance Tab

  • Property Insurance Margin

    • Empty by default. Completes the system when creating a line:

      • the system searches for labels with Financed Object No.=object number from where the line is created, Product Base Type=Property, Insurance Type=Debit or Multiple (i.e. not Individual)

      • for these fuses, it finds lines with Posted=Y in API Ins. Client Payment Cal. (4027105)

        • from these lines calculates the Client Amount Total (it is enough for the variable) = the sum of Amount (50)

      • searches for found insurance policies and lines (probably via Part Payment No.) in API Ins. Company Payment Cal. (4027106)

        • from these rows, it calculates InsurAmountTotal (it is enough for the variable) = the sum of Amount (50)

      • Calculates:

        • Property Insurance Margin = Client Amount Total - InsurAmountTotal

  • Property Insurance Commission

    • Empty by default. Completes the system when creating a line:

      • the system searches for labels with Financed Object No.=object number from where the line is created, Product Base Type=Property, Insurance Type=Debit or Multiple (i.e. not Individual)

      • for these fuses, it finds lines with Posted=Y in API Ins. Client Payment Cal. (4027105)

      • for found insurance policies and lines (probably via Part Payment No.) it searches for lines in API Ins.Comm. Payment Calendar (4027107)

        • From these rows, it calculates Property Insurance Commission = Sum Amount (50)

  • Liability Insurance Margin

    • Empty by default. Completes the system when creating a line:

    • the system searches for labels with Financed Object No.=object number from where the line is created, Product Base Type=Liability, Insurance Type=Debit or Multiple (i.e. not Individual)

    • for these fuses, it finds lines with Posted=Y in API Ins. Client Payment Cal. (4027105)

      • from these lines calculates the Client Amount Total (it is enough for the variable) = the sum of Amount (50)

    • searches for found insurance policies and lines (probably via Part Payment No.) in API Ins. Company Payment Cal. (4027106)

      • from these rows, it calculates InsurAmountTotal (it is enough for the variable) = the sum of Amount (50)

    • Calculates:

      • Liability Insurance Margin = Client Amount Total - InsurAmountTotal

  • Liability Insurance Commission

    • Empty by default. Completes the system when creating a line:

      • the system searches for labels with Financed Object No.=object number from where the line is created, Product Base Type=Liability, Insurance Type=Debit or Multiple (i.e. not Individual)

      • for these fuses, it finds lines with Posted=Y in API Ins. Client Payment Cal. (4027105)

      • for found insurance policies and lines (probably via Part Payment No.) it searches for lines in API Ins.Comm. Payment Calendar (4027107)

        • From these rows, it calculates Liability Insurance Commission = Sum Amount (50)

  • Other Insurance Margin

    • Empty by default. Completes the system when creating a line:

    • the system searches for labels with Financed Object No.=object number from which the line is created, Product Base Type<>Property and Liability, Insurance Type=Debit or Multiple (i.e. not Individual)

    • for these fuses, it finds lines with Posted=Y in API Ins. Client Payment Cal. (4027105)

      • from these lines calculates the Client Amount Total (it is enough for the variable) = the sum of Amount (50)

    • searches for found insurance policies and lines (probably via Part Payment No.) in API Ins. Company Payment Cal. (4027106)

      • from these rows, it calculates InsurAmountTotal (it is enough for the variable) = the sum of Amount (50)

    • Calculates:

      • Other Insurance Margin = Client Amount Total - InsurAmountTotal

  • Other Insurance Commission

    • Empty by default. Completes the system when creating a line:

    • the system searches for items with Financed Object No.=object number from where the line is created, Product Base, TypeProperty and Liability, Insurance Type=Debit or Multiple (i.e. not Individual)

    • for these fuses, it finds lines with Posted=Y in API Ins. Client Payment Cal. (4027105)

    • for found insurance policies and lines (probably via Part Payment No.) it searches for lines in API Ins.Comm. Payment Calendar (4027107)

      • From these rows, it calculates Other Insurance Commission = Sum Amount (50)

Summary tab

  • Interest Margin

    • Empty by default. Completes the system when creating a line:

    • The system will find the lines in the payment cal. contract:

      • Financing Contract No. = from the object from which the line is created

      • Posted=Y

      • Type=Payment

    • Calculates:

      • Interest Margin = round (sum of Interest Margin Amount (1005); 2)

  • Total Margin

    • Empty by default. Completes the system when creating a line:

      • Total Profit = Maintenance Balance + Tire Service Balance + Other Services Balance + Property Insurance Margin + Property Insurance Commission + Liability Insurance Margin + Liability Insurance Commission + Other Insurance Margin + Other Insurance Commission + Interest Margin

  • Sales Price Excl.VAT

    • Empty by default. To be completed manually by the user.

  • Unpaid Principal Balance

    • The system calculates automatically when you create a line and when you change the Sales Price Excl.VAT:

      • Unpaid Principal Balance= Sales Price Excl. VAT - Unpaid Principal Amount

  • Book Value Balance

    • The system calculates automatically when you create a line and when you change the Sales Price Excl.VAT:

      • Book Value Balance= Sales Price Excl.VAT - Book Value