OneCore Docs
OneCore Docs
Breadcrumbs

Contract_Balance

The Contract Balance (LCY) field on the contract card, in the Contract Statistics or Services Utilization Fact. Box, displays the calculated value from the open entries in the Customer Ledger Entries from the Remainder for Contract Balance (LCY) field (Rem. Amt. for Contract Balance (LCY)), where this field represents the balance of the item recalculated only to the current contract.

The Contract Balance (LCY) field is blank when you open the Customer Ledger Entries table itself with a filter on the customer. The value of the field is displayed only when you click on the Contract Balance (LCY) field from the contract.

The value of the Remainder field for Contract Balance (LCY) is calculated by a function that works with 2 resources, namely:

  • Open customer ledger entries without mass invoicing, which have the value of the contract filled in in the Contract No. dimension or the original contract number in Change Copy. I.e. the contract dimension code is filled in the document header, e.g. individual invoice, individual credit note

      • in this resource, the remaining amount from the Remaining Amt. (LCY)), without a proportional budget

  • Customer open items from mass invoicing, i.e. those that have:

    • in the Contract No. dimension, fill in the same value as in the Contract with Service Setup, Mass Invoicing section, in the Contract Dimension Value (MASS) field.

    • have in the customer list in the field Mass Invoice = YES

      • in this source, the amount is calculated proportionally according to the share of the contract on the document, and if the item is partially settled, a ratio correction is made.

Calculation principle for mass invoicing items:

  • basic formula: Rem. Amt for Contract Bal. = Remaining Amt. (LCY) × (Contract Line Amount / Modified Original Document Amount) where:

    • where Contract Line Amount = sum of invoice/credit note lines that belong to the current contract

    • adjusted Original Document Amount = Original Document Amount after taking into account applications (offsets, partial credits, and links to other contracts)

  • correction: For partial credits or other applications, the system adjusts both the denominator (the adjusted original amount) and the contract amount on the lines so that only the actual share of the current contract remains in the open balance

    • in practice, the system searches for items related to the open document in the Customer Detail Entries and uses them when calculating the correction.

Entries that do not meet these conditions are not counted in the Remaining Value for Contract Balance (LCY) and therefore in the Contract Balance (LCY) field on the contract.


Practically, if the invoice is partially settled with a credit memo in which dimension is Contract No. from the invoice line, the system settles the Contract Balance (LCY) of the credit memo:

  • the system finds a settled customer entry of the Credit Memo type for a mass invoice and includes the rest of the uncredited amount of the contract in the balance. If a partially cancelled invoice is partially paid, the partial payment will be calculated according to the ratio of the non-cancelled contract amount to the non-cancelled invoice amount.

  • there will be a partially settled mass credit memo with payment, the same functionality will be displayed in the contract balance in the same way in the mass invoice.

  • there will be a partially settled mass credit note with an invoice that:

    • will have a contract dimension in the invoice header that occurs in the credit memo lines, then the system will count only in the contract balance of this contract,

    • but if it does not have a dimension or there is no dimension in the pile credit memo lines, then this invoice is budgeted into the balance of all contracts (it behaves as a matched payment).


EXAMPLE: An invoice is partially settled with a payment or partial credit memo from another contract. The system will reduce the individual values of the Contract Balance (LCY) proportionally

  • the share of the given contract from the mass invoice balance is calculated into the Contract Balance (LCY), i.e. it calculates the proportion of the given invoice/credit note lines according to the dimension, then calculates the given share from the invoice balance => the result is displayed in the Contract Balance (LCY) field

Contract No. 1 - invoiced amount = 10 thousand

Contract No. 2 - invoiced amount = 20 thousand

Contract No. 3 - Invoiced Amount = 30K

The mass invoice is in the total amount of 60 thousand.

partial Credit Memo of Contract No. 2 from Mass Invoice. A mass invoice is no longer displayed in the contract balance in contract no. 2.

IN Contract Balance No. 1, there is 10 in Contract Balance (LCY) - The system calculated: Mass Invoice Balance 40K * (10/(60/20))

and in Contract Balance (LCY) No.3 the value is 30 thousand. - The system calculated: Mass Invoice Balance 40K * (30/(60/20))

SUBSEQUENTLY, a partial payment of a collective invoice in the amount of 5 thousand came. The system displays:

  • in Contract Balance (LCY) No. 1 (60-20-5) * (10/(60-20)) = 8750  

  • in Contract Balance (LCY) No. 3 (60-20-5) * (30/(60-20)) =26,250.