BR-FR-MV-05_EXT-FR-FE-BG-12: Top-level GROUP totals must match their child lines

What it means

For these billing frameworks in BT-23, the check applies to GROUP lines without a parent, identified in UBL by a billing reference to the current document. The absolute difference between the GROUP line's amount excluding VAT (BT-131) and the sum of its qualifying child-line amounts must be no greater than 0.01 times the number of qualifying child lines. The children are the lines whose parent identifier matches the GROUP line's identifier. Only child lines with a status value other than INFORMATION are included in the sum and count; in UBL, that status and the parent identifier must be in a billing reference identifying the current document. UBL uses cbc:LineExtensionAmount; CII uses ram:LineTotalAmount, ram:ParentLineID and ram:LineID.

Why it matters

The GROUP total summarises the amounts excluding VAT of the qualifying lines linked directly to that group.

How to fix it

Identify the child lines linked to the affected GROUP line with a status value other than INFORMATION and add their amounts excluding VAT; in UBL, use only those whose parent link and status are in a billing reference identifying the current document. Correct any wrong child amount or parent link, then update the GROUP total if necessary. Check direct parent links rather than including every descendant automatically. Export and recheck the file.

The rule as published

Num Fact : … - Ligne GROUP : … , Somme Sous lignes : … , Nbre sous-lignes: … . Valeur actuelle : " … ". Lorsque le cadre de facturation (BT-23) est S8, B8, M8 ou S9, B9, M9, le total HT (ram:LineTotalAmount) de la ligne GROUP doit être égal (tolérance ±0,01 * nombre de sous-lignes) à la somme des totaux HT des lignes enfants dont le ParentLineID correspond à l'identifiant de la ligne GROUP (ram:LineID).

Where France CTC (CII) run it, the rule reads:

Ligne GROUP : … , Somme Sous lignes : … , Nbre sous-lignes: … . Valeur actuelle : " … ". Lorsque le cadre de facturation (BT-23) est S8, B8, M8 ou S9, B9, M9, le total HT (BT-131 : ram:LineTotalAmount) de la ligne GROUP doit être égal (tolérance ±0,01 * nombre de sous-lignes) à la somme des totaux HT des lignes enfants dont le ParentLineID correspond à l'identifiant de la ligne GROUP (ram:LineID).

Business terms: BT-23

Where this rule applies