Oracle NetSuite to Peppol BIS Billing 3.0 Integration & Schema Crosswalk
NetSuite SuiteScript 2.1 Invoice Serialization to Peppol BIS 3.0
When generating UBL 2.1 XML via NetSuite `N/render` FreeMarker templates or SuiteScript 2.1:
1. **FreeMarker Null Tags (`PEPPOL-EN16931-R008`):** FreeMarker expressions like `<cbc:BuyerReference>${record.otherrefnum}</cbc:BuyerReference>` emit empty tags when `otherrefnum` is blank, causing instant Peppol failure. Wrap optional nodes in `<#if record.otherrefnum?has_content>`.
2. **Tax Subtotal Aggregation (`BR-S-08`):** NetSuite SuiteTax lines must be grouped by Tax Code & Rate in `cac:TaxTotal/cac:TaxSubtotal`.
Mandatory Oracle NetSuite to Peppol BIS Billing 3.0 Field Crosswalk Matrix
Deterministic attribute mapping from Oracle NetSuite payloads to EN 16931 Business Terms (BT) and UBL-2.1 XPaths.
| Oracle NetSuite Source Field | EN 16931 Business Term | Target UBL-2.1 XPath | Card. | Transformation & Normalization Rule | Schematron Rule |
|---|---|---|---|---|---|
| record.tranid String | BT-1 (Invoice Number) | /ubl:Invoice/cbc:ID | 1..1 | Map NetSuite Document Number directly | BR-01 ↗ |
| record.custbody_peppol_buyer_endpoint Custom Body Field | BT-49 (Buyer EndpointID) | /ubl:Invoice/cac:AccountingCustomerParty/cac:Party/cbc:EndpointID | 1..1 | Bind @schemeID from custbody_peppol_buyer_scheme | PEPPOL-EN16931-R010 ↗ |
| record.subtotal Currency | BT-106 (Sum of Line Net) | /ubl:Invoice/cac:LegalMonetaryTotal/cbc:LineExtensionAmount | 1..1 | Separate header discount items into cac:AllowanceCharge | BR-CO-10 ↗ |
Test Your Oracle NetSuite Peppol BIS Billing 3.0 XML Export Live
Validate your generated UBL-2.1 payload against EN 16931 & Peppol BIS Billing 3.0 rules directly in your browser.
Missing <cbc:CustomizationID> or value does not declare EN 16931 CIUS compliance.
Remediation: 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").
Remediation: 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.
Remediation: Strip empty <cbc:AdditionalStreetName> nodes prior to XML serialization.
Missing <cbc:EndpointID schemeID="..."> inside <cac:AccountingSupplierParty>/<cac:Party>.
Remediation: 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.
Remediation: 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.
Remediation: 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).
Remediation: Set cbc:LineExtensionAmount and cbc:TaxExclusiveAmount to 199.95.
TaxSubtotal/TaxableAmount reports 200.00, but Standard rated ("S") lines total 199.95.
Remediation: Recalculate BT-116 = 199.95, VAT BT-117 = 37.99, and PayableAmount BT-115 = 237.94.
Other ERP to E-Invoicing Compliance Bridges
Unlock Pro Batch XML / PDF Converter ($29/mo) →4 mandatory EN 16931 Business Term mappings
4 mandatory EN 16931 Business Term mappings
4 mandatory EN 16931 Business Term mappings
4 mandatory EN 16931 Business Term mappings