Maica Client Management V.0.333

NDIS-892: Agreement Item → Total Delivered Not Accounting for Voided Invoice Line Items

‍

Resolved: Support for Voided Invoice Line Item records

‍

An issue was identified where the Agreement Item Total Delivered field did not correctly exclude Invoice Line Item records that were marked as Voided, leading to inaccurate delivery totals.

‍

What’s Changed?

‍

Introduced a new Exclude checkbox field on Invoice Line Item (default FALSE):

- Description: Indicates if the Invoice Line Item Amounts should be excluded from the totals on the Invoice record. If an Agreement Item is linked, the amounts will also be excluded from its totals. The default value is unchecked.

- Help text: Check this box to exclude the Invoice Line Item Amounts from being rolled up into the totals on the Invoice record. If the Invoice Line Item is linked to an Agreement Item, the amounts will also be excluded from its totals. Leave unchecked to include them in both totals.

‍

Logic for Rolling Up Invoice Line Items to Agreement Item:

‍

- Source Object: Invoice_Line_Item__c

- Grouping: Records are grouped by Agreement_Item__c

- Fields Aggregated:

            - Line_Total__c is summed to represent the total dollar amount delivered.

            - Quantity_Delivered__c is summed to represent total quantity delivered.

- Exclude records where Exclude__c = TRUE

- Exclude records where the related Invoice (Invoice__r) has Cancelled__c = TRUE

- Exclude records where the related Invoice's Status__c = 'Voided'

‍

Example Scenarios:

‍

A Participant's invoice is voided: ✅ Agreement Item Total Delivered now correctly excludes all associated Invoice Line Item records

A single Invoice Line Item record is invalidated and flagged via Exclude = TRUE: ✅ The item is ignored in rollup totals without affecting the entire invoice record.