Most common validation rules linked to CIUS-PT
Common errors related to CIUS-PT (ESPAP validation rule) are explained here. You have suggestions of what could cause the error and what needs to be addressed.
ID: BR-02
ESPAP validation rule: An invoice must include an invoice number. (BT-1).
Business-Oriented Description: An invoice must include an invoice number.
What went wrong: An incorrect invoice number was assigned to the invoice.
What needs to be addressed: Make sure the correct invoice number is assigned to the invoice.
ID: BR-AA-01
ESPAP validation rule: An invoice that includes an invoice line (BG-25), a document level allowance (BG-20), or a document level charge (BG-21) with a VAT category code (BT-151, BT-95, or BT-102) of 'Lower rate' must have at least one VAT category code (BT-118) of 'Lower rate' in the VAT Breakdown (BG-23).
Business-Oriented Description: If there are invoice lines, document level allowances, or document level charges with a VAT category code of 'Lower rate' (reduced or intermediate tax), all must be included in the VAT summary.
What went wrong: One or more VAT category codes marked as 'Lower rate' in the document lines, document level allowances, or document level charges are missing from the VAT summary.
What needs to be addressed: Make sure the VAT summary includes all VAT category codes shown in the invoice lines, document level allowances, or document level charges.
ID: BR-AA-07
ESPAP validation rule: In a document level charge (BG-21) with a VAT category code (BT-102) of 'Lower rate,' the VAT rate (BT-103) must be greater than zero.
Business-Oriented Description: In a document level charge with a VAT code of 'Lower rate,' the VAT rate must be greater than zero.
What went wrong: In a document level charge, the VAT rate doesn't follow the VAT category code.
What needs to be addressed: Make sure the VAT rate aligns with the VAT category code.
ID: BR-AA-08
ESPAP validation rule: For each different value of VAT category rate (BT-119) with a VAT category code (BT-118) of 'Lower rate', the VAT category taxable amount (BT-116) in a VAT Breakdown (BG-23) must equal the sum of invoice line net amounts (BT-131) plus the sum of document level charge amounts (BT-99) minus the sum of document level allowance amounts (BT-92) where the VAT category code (BT-151, BT-102, BT-95) is 'Lower rate' and the VAT rate (BT-152, BT-103, BT-96) equals the VAT category rate (BT-119).
Business-Oriented Description: The value of the VAT tax base per rate, where the VAT code is 'Lower rate,' must equal the sum of the net value of the lines, document charges, and document discounts, all aggregated by rate. Value of the VAT tax base per rate = SUM(Net value of the lines) + SUM(document charges) - SUM(document discounts).
What went wrong: The taxes were incorrectly aggregated, or the discount or charge documents were omitted.
Document discount
Document charges
ID: BR-AA-09
ESPAP validation rule: The VAT category tax amount (BT-117) in a VAT Breakdown (BG-23) with a VAT category code (BT-118) of 'Lower rate' must equal the VAT category taxable amount (BT-116) multiplied by the VAT category rate (BT-119).
Business-Oriented Description: In a VAT summary with a VAT code of 'Lower rate,' the VAT tax amount must equal the VAT taxable amount multiplied by the VAT rate. VAT tax amount = (VAT taxable amount) x (VAT rate).
What went wrong: In the VAT summary, the VAT tax amount or the VAT taxable amount isn't shown.
VAT tax amount
VAT taxable amount
ID: BR-AA-10
ESPAP validation rule: A VAT Breakdown (BG-23) with VAT Category code (BT-118) 'Lower rate' must not include a VAT exemption reason code (BT-121) or VAT exemption reason text (BT-120).
Business-Oriented Description: A VAT summary with the VAT code 'Lower rate' can't include a VAT exemption reason code or text.
What went wrong: In the VAT summary, the VAT exemption reason code or text is included.
VAT exemption reason code
VAT exemption reason text
ID: BR-AE-1
ESPAP validation rule: An invoice that has an invoice line (BG-25), a document-level allowance (BG-20), or a document-level charge (BG-21) with the VAT category code (BT-151, BT-95, or BT-102) 'Reverse charge' must include exactly one VAT category code (BT-118) 'VAT reverse charge' in the VAT breakdown (BG-23).
Business-Oriented Description: If there are invoice lines, document-level allowances, or document-level charges with the VAT category code 'Reverse charge tax,' it must be included in the VAT summary.
What went wrong: One or more 'Reverse charge' VAT category codes in the document lines, document-level allowances, or document-level charges are not included in the VAT summary.
What needs to be addressed: Make sure the VAT summary includes all VAT category codes from the invoice lines, document-level allowances, or document-level charges.
ID: BR-CIUS-PT-01
ESPAP validation rule: An invoice must include the Seller VAT identifier (BT-31).
Business-Oriented Description: Filling in the supplier VAT number is mandatory.
What went wrong: The supplier VAT number was not entered.
What needs to be addressed: Check the field to make sure it includes the supplier VAT number.
ID: BR-CIUS-PT-03
ESPAP validation rule: An invoice must include the buyer VAT identifier (BT-48).
Business-Oriented Description: Entering the customer VAT number is mandatory.
What went wrong: The customer VAT number wasn't entered.
What needs to be addressed: Check the field to make sure it is filled with the customer VAT number.
ID: BR-E-01
ESPAP validation rule: An invoice that has an invoice line (BG-25), a document-level allowance (BG-20), or a document-level charge (BG-21) with the VAT category code (BT-151, BT-95, or BT-102) 'Exempt from VAT' must include exactly one VAT breakdown (BG-23) with the VAT category code (BT-118) 'Exempt from VAT'.
Business-Oriented Description: If there are invoice lines, document-level allowances, or document-level charges with the VAT category code 'Exempt from VAT,' it must be included in the VAT summary.
What went wrong: One or more 'Exempt from VAT' VAT category codes in the document lines, document-level allowances, or document-level charges are not included in the VAT summary.
What needs to be addressed: Make sure the VAT summary includes all VAT category codes from the invoice lines, document-level allowances, or document-level charges.
ID: BR-E-08
ESPAP validation rule: In a VAT breakdown (BG-23) with the VAT category code (BT-118) 'Exempt from VAT,' the VAT category taxable amount (BT-116) must equal the sum of invoice line net amounts (BT-131) minus the sum of document-level allowance amounts (BT-92) plus the sum of document-level charge amounts (BT-99) where the VAT category codes (BT-151, BT-95, BT-102) are 'Exempt from VAT'.
Business-Oriented Description: In a VAT summary with the tax codes 'Exempt from VAT,' the taxable amount must equal the sum of invoice line net amounts minus the sum of document-level allowance amounts plus the sum of document-level charge amounts where the VAT category codes are 'Exempt from VAT.' Taxable amount = SUM (invoice line net amounts) - SUM (document-level allowance amounts) + SUM (document-level charge amounts).
What went wrong: In the VAT summary, the invoice line net amounts, document-level allowance amounts, or document-level charge amounts are not included.
The tax code for the document-level allowance must match the tax code in the VAT summary.
Net Amounts for Invoice Lines
Sum of Document-Level Allowance Amounts
Sum of Document-Level Charge Amounts
ID: BR-E-10
ESPAP validation rule: A VAT Breakdown (BG-23) with the VAT Category code (BT-118) "Exempt from VAT" must include either a VAT exemption reason code (BT-121) or a VAT exemption reason text (BT-120).
Business-Oriented Description: A VAT summary with the VAT code "Exempt from VAT" must include either a VAT exemption reason code or a VAT exemption reason text.
What went wrong: In the VAT summary, the VAT exemption reason code or VAT exemption reason text is missing when "Exempt from VAT" is used.
VAT exemption reason code
VAT exemption reason text
ID: BR-S-01
ESPAP validation rule: An invoice that has an invoice line (BG-25), a document-level allowance (BG-20), or a document-level charge (BG-21) with the VAT category code (BT-151, BT-95, or BT-102) "Standard rated" must include at least one VAT category code (BT-118) "Standard rated" in the VAT Breakdown (BG-23).
Business-Oriented Description: If there are invoice lines, document-level allowances, or document-level charges with the VAT category code "Standard rated tax," it must be included in the VAT summary.
What went wrong: One or more VAT category codes "Standard rate" shown in the document lines, document-level allowances, or document-level charges are missing in the VAT summary.
What needs to be addressed: Make sure the VAT summary includes all VAT category codes shown in the invoice lines, document-level allowances, or document-level charges.
ID: BR-S-07
ESPAP validation rule: In a document-level charge (BG-21) with the VAT category code (BT-102) "Standard rated," the VAT rate (BT-103) must be greater than zero.
Business-Oriented Description: For the Standard rated VAT category code (S or NOR), the VAT rate must be greater than zero.
What went wrong: The VAT rate for a Standard rated VAT category code is equal to or less than zero.
What needs to be addressed: Check all VAT rates and VAT category codes.
ID: BR-S-08
ESPAP validation rule: For each different VAT category rate (BT-119) where the VAT category code (BT-118) is "Standard rated," the VAT category taxable amount (BT-116) in the VAT Breakdown (BG-23) must equal the sum of invoice line net amounts (BT-131) plus document-level charge amounts (BT-99) minus document-level allowance amounts (BT-92). This applies where the VAT category code (BT-151, BT-102, BT-95) is "Standard rated" and the VAT rate (BT-152, BT-103, BT-96) matches the VAT category rate (BT-119).
Business-Oriented Description: The VAT tax base per rate, where the VAT code is "Standard rate," must equal the sum of the net value of the lines, document charges, minus document discounts, all aggregated by rate. VAT tax base per rate = SUM (Net value of the lines) + SUM (Document charges) - SUM (Document discounts).
What went wrong: The taxes were incorrectly aggregated, and either the document discount or the document charges were omitted.
Document discount
Document charges
ID: BR-S-09
ESPAP validation rule: The VAT category tax amount (BT-117) in the VAT Breakdown (BG-23) with the VAT category code (BT-118) "Standard rated" must equal the VAT category taxable amount (BT-116) multiplied by the VAT category rate (BT-119).
Business-Oriented Description: In a VAT summary with the VAT code "Standard rate," the VAT tax amount must equal the VAT taxable amount multiplied by the VAT rate. VAT tax amount = VAT taxable amount × VAT rate
What went wrong: In the VAT summary, either the VAT taxable amount or the VAT rate is not included.
VAT taxable amount
VAT rate
ID: BR-Z-1
ESPAP validation rule: An invoice that has an invoice line (BG-25), a document-level allowance (BG-20), or a document-level charge (BG-21) with the VAT category code (BT-151, BT-95, or BT-102) "Zero rated" must include exactly one VAT category code (BT-118) "Zero rated" in the VAT breakdown (BG-23).
Business-Oriented Description: If there are invoice lines, document-level allowances, or document-level charges with the VAT category code "Zero rated tax," it must be included in the VAT summary.
What went wrong: One or more VAT category codes "Zero rated" shown in the document lines, document-level allowances, or document-level charges are not included in the VAT summary.
What needs to be addressed: Make sure the VAT summary includes all VAT category codes shown in the invoice lines, document-level allowances, and document-level charges.
ID: DT-CIUS-PT-009
ESPAP validation rule: The BT-10 doesn't meet the required format: alphanumeric, with a length between one and 50 characters.
Business-Oriented Description: The buyer reference must be completed and must not exceed 50 characters.
What went wrong: The buyer reference either exceeds 50 characters or has not been entered.
What needs to be addressed: Make sure the buyer reference is entered and doesn't exceed 50 characters.
ID: DT-CIUS-PT-010
ESPAP validation rule: The BT-11 doesn't meet the required format: alphanumeric, with a length between one and 50 characters.
Business-Oriented Description: The project reference must be completed and must not exceed 50 characters.
What went wrong: The project reference either exceeds 50 characters or has not been entered.
What needs to be addressed: Make sure the project reference is entered and doesn't exceed 50 characters.
ID: DT-CIUS-PT-011
ESPAP validation rule: The BT-12 doesn't meet the required format: alphanumeric, with a length between one and 20 characters.
Business-Oriented Description: The contract reference must be completed and must not exceed 20 characters.
What went wrong: The contract reference either exceeds 20 characters or has not been entered.
What needs to be addressed: Make sure the contract reference is entered and doesn't exceed 20 characters.
ID: DT-CIUS-PT-012
ESPAP validation rule: The BT-13 doesn't meet the required format: alphanumeric, with a length between one and 20 characters.
Business-Oriented Description: The purchase order reference must be completed and must not exceed 20 characters.
What went wrong: The purchase order reference either exceeds 20 characters or has not been entered.
What needs to be addressed: Make sure the purchase order reference is entered and doesn't exceed 20 characters.
ID: DT-CIUS-PT-013
ESPAP validation rule: The BT-14 doesn't meet the required format: alphanumeric, with a length between one and 20 characters.
Business-Oriented Description: The sales order reference must be completed and must not exceed 20 characters.
What went wrong: The sales order reference issued by the supplier either exceeds 20 characters or has not been entered.
What needs to be addressed: Make sure the sales order reference is entered and doesn't exceed 20 characters.
ID: DT-CIUS-PT-014
ESPAP validation rule: The BT-15 does n't meet the required format: alphanumeric, with a length between one and 20 characters.
Business-Oriented Description: The referenced return receipt number must be completed and must not exceed 20 characters.
What went wrong: The referenced return receipt number either exceeds 20 characters or has not been entered.
What needs to be addressed: Make sure the referenced return receipt number is entered and does not exceed 20 characters.
ID: DT-CIUS-PT-015
ESPAP validation rule: The BT-16 doesn't meet the required format: alphanumeric, with a length between one and 20 characters.
Business-Oriented Description: The receiving advice reference must be completed and must not exceed 20 characters.
What went wrong: The receiving advice reference either exceeds 20 characters or has not been entered.
What needs to be addressed: Make sure the receiving advice reference is entered and doesn't exceed 20 characters.
ID: DT-CIUS-PT-016
ESPAP validation rule: The BT-17 doesn't meet the required format: it must be alphanumeric and between one and 20 characters.
Business-Oriented Description: The tender or lot reference must be completed and cannot exceed 20 characters.
What went wrong: The tender or lot reference either exceeds 20 characters or has not been entered.
What needs to be addressed: Make sure the tender or lot reference is entered and doesn't exceed 20 characters.
ID: DT-CIUS-PT-080
ESPAP validation rule: The BT-83 doesn't meet the required format: it must be prefixed with '#REFERENCE@ATMPAYMENT#' or '#REFERENCE@DUCPAYMENT#' and suffixed with '#'.
Business-Oriented Description: The remittance information doesn't meet the required format: it must be prefixed with '#REFERENCE@ATMPAYMENT#' or '#REFERENCE@DUCPAYMENT' and suffixed with '#'.
What went wrong: The remittance information doesn't meet the required format.
What needs to be addressed: Make sure the remittance information meets the required format.
ID: DT-CIUS-PT-114.2
ESPAP validation rule: The BT-126 value must be unique.
Business-Oriented Description: The invoice line identifier must be unique and cannot be repeated within the invoice.
What went wrong: There is at least one duplicated invoice line identifier in this document.
What needs to be addressed: Make sure each invoice line identifier is unique in the document.
ID: DT-CIUS-PT-120
ESPAP validation rule: The BT-133 doesn't meet the required format: it must be alphanumeric and between one and 200 characters.
Business-Oriented Description: The invoice line buyer accounting reference doesn't meet the required format: it must be alphanumeric and between one and 200 characters.
What went wrong: The invoice line buyer accounting reference must be alphanumeric and between one and 200 characters.
What needs to be addressed: Make sure the invoice line buyer accounting reference is between one and 200 characters.
ID: DT-CIUS-PT-127.1
ESPAP validation rule: The BT-146 doesn't meet the required format: it must be a decimal value with eight decimal places and 13 digits.
Business-Oriented Description: The item's net price doesn't meet the required format.
What went wrong: The item's net price doesn't meet the required syntax format: it must be a decimal value with two to eight decimal places and one to 13 digits.
What needs to be addressed: Format the item's net price to have between one and eight decimal places and one to 13 digits.
ID: DT-CIUS-PT-130.2
ESPAP validation rule: The BT-149 unit code must follow the UN/ECE Recommendation 20 and Rec 21 extension.
Business-Oriented Description: The item price base quantity unit code must follow the UN/ECE Recommendation 20 and Rec 21 extension.
What went wrong: A code that doesn't follow the UN/ECE Recommendation 20 and Rec 21 extension was used.
What needs to be addressed: Correct the code to follow the UN/ECE Recommendation 20 and Rec 21 extension.
ID: DT-CIUS-PT-143
ESPAP validation rule: The BT-130 unit code must follow the UN/ECE Recommendation 20 and Rec 21 extension.
Business-Oriented Description: The unit of measure for the line invoiced quantity must follow the UN/ECE Recommendation 20 and Rec 21 extension.
What went wrong: One of the invoice lines includes a unit of measure that isn't on the approved list.
What needs to be addressed: Make sure all units of measure in the invoice lines follow the UN/ECE Recommendation 20 and Rec 21 extension.
ID: DT-CIUS-PT-157
ESPAP validation rule: BT-131 must equal the product of the quantity (InvoicedQuantity) and price (PriceAmount), divided by the base quantity (BaseQuantity), minus the sum of discounts, plus the sum of charges for the line. The acceptance range is €1.00, though this tolerance may not be accepted by the customer.
Business-Oriented Description: The document line net amount must equal the product of the invoiced quantity and price amount, divided by the base quantity, minus the sum of discounts, plus the sum of charges for the line, with an acceptance range of €1.00. The calculation is: Value of the invoice line net amount = ((Quantity * Price) / Base quantity) - sum (discounts) + sum (charges) ± €1.
What went wrong: The document line net amount doesn't equal the product of the quantity (InvoicedQuantity) and price (PriceAmount), divided by the base quantity (BaseQuantity), minus the sum of discounts, plus the sum of charges for the line, within an acceptance range of €1.00. The calculation is: Value of the invoice line net amount = ((Quantity * Price) / Base quantity) - sum (discounts) + sum (charges).
What needs to be addressed: Make sure the document line net amount is within the acceptance range of €1.00, calculated as: (Quantity * Price) / Base quantity - sum (discounts) + sum (charges).
ID: DT-CIUS-PT-158
ESPAP validation rule: BT-92 must equal the product of the Document level allowance base amount (BT-93) and the Document level allowance percentage (BT-94), with an acceptance range of €1.00. Note that this tolerance may not be accepted by the customer.
Business-Oriented Description: The document level allowance amount equals the product of the document level allowance base amount and the document level allowance percentage, with an acceptance range of €1.00.
What went wrong: The document level allowance amount wasn't calculated correctly.
Document level allowance base amount
Document level allowance percentage
ID: DT-CIUS-PT-160
ESPAP validation rule: Sum of invoice line net amount (BT-106) = Σ invoice line net amount (BT-131), with an acceptance range of €1.00. Note that this tolerance may not be accepted by the customer.
Business-Oriented Description: Sum the invoice line net amounts, with an acceptance range of €1.00.
What went wrong: The sum of the invoice line net amount is outside the acceptance range of €1.00.
What needs to be addressed: Make sure the sum of the invoice line net amount is within the acceptance range of 1.00 €.
ID: DT-CIUS-PT-171
ESPAP validation rule: For each VAT category rate (BT-119) with the code 'Lower rate' (BT-118), the VAT category taxable amount (BT-116) in a VAT Breakdown (BG-23) must equal the sum of invoice line net amounts (BT-131), plus document level charge amounts (BT-99), minus document level allowance amounts (BT-92). This applies where the VAT category code (BT-151, BT-102, BT-95) is 'Lower rate' and the VAT rate (BT-152, BT-103, BT-96) matches the VAT category rate (BT-119), with an acceptance range of €1.00. Note that this tolerance may not be accepted by the customer.
Business-Oriented Description: The VAT tax base per rate, where the VAT code is 'Lower rate,' must equal the sum of the net value of the document lines, document charges, and document discounts, aggregated by rate, with a tolerance of €1.00.
What went wrong: The taxes weren't calculated correctly, or the document discount or charges weren't considered.
VAT category rate
Document discount
Document charges
ID: DT-CIUS-PT-172
ESPAP validation rule: The VAT category tax amount (BT-117) in a VAT Breakdown (BG-23) with the code 'Lower rate' (BT-118) must equal the VAT category taxable amount (BT-116) multiplied by the VAT category rate (BT-119), with an acceptance range of €1.00. Note that this tolerance may not be accepted by the customer.
Business-Oriented Description: The VAT category tax amount for the 'Lower rate' in the VAT summary must equal the VAT taxable amount multiplied by the VAT rate, with a tolerance of €1.00. Note that this tolerance may not be accepted by the customer.
What went wrong: The taxes weren't calculated correctly, or the VAT taxable amount or VAT rate weren't considered.
VAT taxable amount
VAT rate
ID: DT-CIUS-PT-173
ESPAP validation rule: For each VAT category rate (BT-119) with the code 'Standard rated' (BT-118), the VAT category taxable amount (BT-116) in a VAT Breakdown (BG-23) must equal the sum of invoice line net amounts (BT-131), plus document level charge amounts (BT-99), minus document level allowance amounts (BT-92). This applies where the VAT category code (BT-151, BT-102, BT-95) is 'Standard rated' and the VAT rate (BT-152, BT-103, BT-96) matches the VAT category rate (BT-119), with an acceptance range of €1.00. Note that this tolerance may not be accepted by the customer.
Business-Oriented Description: The VAT tax base per rate, where the VAT code is 'Standard rate,' must equal the sum of the net value of the lines, document charges, minus document discounts, aggregated by rate, with a tolerance of €1.00. The calculation is: VAT tax base per rate = Sum (Net value of the lines) + Sum (document charges) - Sum (document discounts).
What went wrong: The taxes were incorrectly aggregated, or the document discount and charges weren't applied.
Document discount
Document charges
ID: DT-CIUS-PT-174
ESPAP validation rule: The VAT category tax amount (BT-117) in a VAT Breakdown (BG-23) with a Standard rated VAT category code (BT-118) must equal the VAT category taxable amount (BT-116) multiplied by the VAT category rate (BT-119), with an acceptance range of €1.00. This tolerance may not be accepted by the customer.
Business-Oriented Description: The VAT category tax amount for the Standard rate in the VAT summary must equal the VAT taxable amount multiplied by the VAT rate, with a tolerance of €1.00. This tolerance may not be accepted by the customer.
What went wrong: The taxes were incorrectly calculated, or the VAT taxable amount or the VAT rate weren't considered.
VAT taxable amount
VAT rate
ID: DT-CIUS-PT-175
ESPAP validation rule: In a VAT Breakdown (BG-23) where the VAT category code (BT-118) is Exempt from VAT, the VAT category taxable amount (BT-116) must equal the sum of Invoice line net amounts (BT-131) minus Document level allowance amounts (BT-92) plus Document level charge amounts (BT-99), all with Exempt from VAT category codes (BT-151, BT-95, BT-102). An acceptance range of €1.00 applies, but this tolerance may not be accepted by the customer.
Business-Oriented Description: In the VAT summary, the VAT category taxable amount, where the VAT category is Exempt from VAT, must equal the sum of invoice line net amounts minus document level allowance amounts plus document level charge amounts, all with Exempt from VAT category codes. An acceptance range of €1.00 applies, but this tolerance may not be accepted by the customer.
Not including all invoice line net amounts with Exempt from VAT category.
Including items with non-Exempt from VAT category.
Not including document level charge amounts with Exempt from VAT category.
Including document level charge amounts with non-Exempt from VAT category.
What needs to be addressed: Check the VAT summary to make sure the VAT category taxable amount, where the VAT category is Exempt from VAT, matches the sum of invoice line net amounts minus document level allowance amounts plus document level charge amounts, all with Exempt from VAT category codes.
ID: DT-CIUS-PT-176
ESPAP validation rule: An invoice with lines (BG-25) that have different VAT exemption reason codes, where the VAT category code (BT-151) is Exempt from VAT, must include exactly one VAT Breakdown (BG-23) with the VAT category code (BT-118) as Exempt from VAT for each VAT exemption reason code (BT-121).
Business-Oriented Description: One or more different VAT exemption reason codes shown in the document lines, where the VAT category is Exempt from VAT are missing in the VAT summary.
What went wrong: One or more VAT exemption reason codes present in the invoice lines, where the VAT category is Exempt from VAT, are missing in the VAT summary. Also, one or more VAT exemption reason codes may exist in the VAT summary but not in the invoice lines.
What needs to be addressed: Make sure that VAT exemption reason codes in the VAT summary, where the VAT category is Exempt from VAT, match all invoice lines with different VAT exemption reason codes, where the VAT category is Exempt from VAT.