PrestaShop 8 to Factur-X 1.07 (French Mandate) Schema Crosswalk & XML Compiler
Why Native PrestaShop 8 Exports Fail Factur-X 1.07 (French Mandate) Validation
1. PrestaShop's `/api/order_invoices` endpoint does not expose a dedicated invoice number field compliant with Factur-X BT-1; the `number` field is a free-text string that may contain non-sequential characters, violating BR-02 and BR-FR-01 requirements for a unique, sequential invoice identifier.
2. Tax amounts are provided only as `total_paid_tax_incl` and `total_products`, lacking the granular tax breakdown per rate required for BT-110 (invoice total VAT) and BT-117 (VAT category breakdown); this causes BR-CO-15 and BR-S-08 failures due to missing VAT category taxable amounts and tax amounts.
3. The `address.siret` field is optional and not validated for the 14-digit SIREN/SIRET format, and `address.vat_number` may be absent or malformed, leading to BR-FR-01 and BR-CL-01 violations because the French mandate requires a valid SIREN (BT-30) and VAT identifier (BT-31) for the seller and BT-48 for the buyer.
| PrestaShop 8 API Field | EN 16931 Business Term | Target CII-D16B XPath | Card. | Normalization Rule | Assertion |
|---|---|---|---|---|---|
| number string, e.g., "INV-2024-001" | BT-1 | /rsm:CrossIndustryInvoice/rsm:ExchangedDocument/ram:ID | 1..1 | Trim whitespace and replace any non-alphanumeric characters (except hyphen and underscore) with an empty string; ensure the resulting string is unique and sequential by appending a zero-padded sequence number if necessary. | BR-02 β |
| total_paid_tax_incl decimal, e.g., 120.00 | BT-112 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:GrandTotalAmount | 1..1 | Round to 2 decimal places using half-up rounding; ensure the value equals the sum of line net amounts plus tax total (BR-CO-15). | BR-CO-15 β |
| address.siret string, e.g., "12345678900012" | BT-30 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SellerTradeParty/ram:SpecifiedLegalOrganization/ram:ID | 0..1 | Extract the first 9 digits as SIREN; if the field is missing or invalid, set to empty and flag for manual review; validate against the French SIREN checksum (Luhn algorithm). | BR-FR-01 β |
| address.vat_number string, e.g., "FR12345678901" | BT-31 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SellerTradeParty/ram:SpecifiedTaxRegistration/ram:ID[@schemeID='VA'] | 0..1 | Remove spaces and hyphens; ensure it starts with 'FR' followed by 2 alphanumeric characters and 9 digits; if invalid, omit and rely on SIREN for identification. | BR-CL-01 β |
Missing <cbc:CustomizationID> or value does not declare EN 16931 CIUS compliance.
fix: Insert <cbc:CustomizationID>urn:cen.eu:en16931:2017#compliant#urn:fdc:peppol.eu:2017:poacc:billing:3.0</cbc:CustomizationID>.
Found invalid or lowercase currency code "eur". Expected uppercase ISO 4217 (e.g. "EUR").
fix: Replace <cbc:DocumentCurrencyCode>eur</cbc:DocumentCurrencyCode> with uppercase "EUR".
Peppol Schematron forbids empty elements such as <cbc:AdditionalStreetName></cbc:AdditionalStreetName> serialized from null ERP fields.
fix: Strip empty <cbc:AdditionalStreetName> nodes prior to XML serialization.
Missing <cbc:EndpointID schemeID="..."> inside <cac:AccountingSupplierParty>/<cac:Party>.
fix: Add <cbc:EndpointID schemeID="9930">DE123456789</cbc:EndpointID> as the first child of Seller <cac:Party>.
Buyer <cbc:EndpointID> is either missing or lacks the mandatory EAS @schemeID attribute.
fix: Add schemeID="9930" (or "0088" for GLN / "0204" for Leitweg-ID) to Buyer <cbc:EndpointID>.
No <cbc:BuyerReference> (BT-10) found. Mandatory in XRechnung 3.0 (BR-DE-15) and required in Peppol BIS 3.0 (PEPPOL-EN16931-R003) when OrderReference is absent.
fix: Insert <cbc:BuyerReference>991-12849-74</cbc:BuyerReference> in the document header.
Mathematical discrepancy of 0.05 EUR between InvoiceLine sum (199.95) and LegalMonetaryTotal/LineExtensionAmount (200.00).
fix: Set cbc:LineExtensionAmount and cbc:TaxExclusiveAmount to 199.95.
TaxSubtotal/TaxableAmount reports 200.00, but Standard rated ("S") lines total 199.95.
fix: Recalculate BT-116 = 199.95, VAT BT-117 = 37.99, and PayableAmount BT-115 = 237.94.