# Agreement Item Calculation

## **Overview**

This article explains how Maica uses a combination of `Invoice.Status` and the `Invoice Line Item.Include` field to determine which records contribute to the `Agreement Item → Total Delivered` calculation. This dual-condition logic ensures both flexibility and accuracy in how utilisation is tracked — supporting full invoice cancellation scenarios as well as granular exclusions of individual line items.

## **What Are Included Invoice Line Items?**

Included items are `Invoice Line Item` records where `Include = TRUE`. These are treated as valid and are rolled up to the corresponding `Agreement Item.Total Delivered` value.

This mechanism allows for two types of exclusion use cases:

1. **Full Invoice Cancellation:** If an `Invoice` has its `Status` set to **Cancelled**, *all* related `Invoice Line Items` are excluded from `Agreement Item` totals. This is useful when an entire invoice is no longer valid and should be ignored in utilisation figures.
2. **Line Item-Level Exclusion:** If a specific `Invoice Line Item` is updated with `Include = FALSE`, that individual item is excluded from the rollup, *even if* the parent invoice remains valid. This allows organisations to correct or void individual charges without affecting the entire invoice.

## **How Maica Supports This Feature**

* A checkbox field `Include` (default **TRUE**) exists on each `Invoice Line Item`.
* Maica’s rollup logic now checks both:
  * `Invoice_Line_Item__c.Include = TRUE`
  * Related `Invoice.Status` is **not** `Cancelled`

**This ensures:**

* Flexibility to cancel entire invoices
* Precision to exclude only specific line items as needed

This ensures accurate Agreement utilisation tracking and supports a range of real-world billing and reconciliation scenarios.

<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://knowledge.maica.com.au/maica-knowledge-base/service-agreements/agreement-item-calculation.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.