Belgium (BE)

BC29 · country layer against W1 · Learn: local functionality · narrative reviewed (checked by Opus)

Overview

Belgium adds a large set of own objects on top of W1. Electronic banking (tables and codeunits in the 2000000 range) handles payment journals, export protocols, payment file reports and checks, domiciliation journals, and CODA import, application and posting. Learn documents these under Belgian Electronic Banking, Belgian electronic payments, Belgian CODA Bank Statements and Belgian Direct Debit Using Domiciliation.

For tax and statutory reporting, the country adds VAT reports (VAT form, annual listing, VAT-VIES disk, Intervat helper), manual VAT corrections, representatives, legal ledgers (sales, purchase, general, centralization, financial), a trial balance and the Link to Accon export. W1 tables get Enterprise No. fields, non-deductible VAT fields and Intrastat fields. Intrastat is implemented through extensions to the Intrastat report and tariff number import reports.

Other layers cover service documents (BE reports and header extensions), PEPPOL 3.0 validation and payment discount compensation, Shopify enterprise number mapping, journal template names made mandatory with upgrade tags, and cash flow VAT base amounts. The code also adds 18 events on W1 objects, for example in VAT Statement, Customer, Vendor and Country/Region.

Key points

• Electronic banking: payment journals, export protocols, domestic, international, SEPA and non-Euro SEPA payment files, with check codeunits and error logs
• CODA bank statements: import, application to ledger entries, financial journal transfer and posting; bank account fields Protocol No. and Version Code
• Domiciliation direct debit: journals, suggestions, test and file reports; Customer fields Domiciliation No. and VAT Liable
• Belgian VAT: VAT form and Intervat declaration, annual listing, VAT-VIES disk, manual VAT corrections, representatives
• Non-deductible VAT: % Non deductible VAT on G/L Account, amounts on VAT Entry, purchase lines and posting buffers
• Enterprise No. and Branch No. on Company Information, customers, vendors, contacts and document headers
• Intrastat: simplified and extended declarations, tariff number setup and import, OneGate export, Intrastat Establishment No.
• Legal reports: sales, purchase, general, centralization and financial ledgers, trial balance, Link to Accon export; PEPPOL 3.0 BE

Narrative written by Sonnet from the code diff and 38 Learn page summaries. In numbers: Belgium (BE) localization of Business Central in BC29: 129 objects of its own, 80 W1 objects changed (101 fields and 18 events added). From the code; country apps outside the Base Application are not included yet.

By area

Bank

Adds the Belgian electronic banking stack: payment journal templates, batches and lines, export protocols, check codeunits for domestic, international, SEPA and non-Euro SEPA payments, and payment file reports. Also adds domiciliation journals and CODA statement import, application and posting. Bank Account gets Protocol No., Version Code and Interbank Clearing Code.

Why: Learn explains that the setup supports electronic payments, CODA statements and domiciliation direct debits, with export protocols defining the payment file formats.

Objects: table/2000001 “Payment Journal Line” (own), codeunit/2000000 “PmtJrnlManagement” (own), report/2000005 “File SEPA Payments” (own), report/2000030 “Import CODA Statement” (own), codeunit/2000040 “Coda Import Management” (own), table/2000040 “CODA Statement” (own), report/2000021 “File Domiciliations” (own), table/2000022 “Domiciliation Journal Line” (own).

All 60 objects of Bank in the diff

Finance

Adds Belgian VAT handling: VAT form, annual listing, VAT-VIES disk, VAT statement reports, manual VAT corrections and representatives. Also adds legal ledger reports and Link to Accon. W1 VAT Statement and VAT Entry gain non-deductible VAT and Enterprise No. fields, and G/L Entry gets application fields.

Why: Learn documents monthly or quarterly VAT declarations, annual listings, manual VAT corrections and general ledger entry application for Belgium.

Objects: report/11307 “VAT - Form” (own), report/11308 “VAT Annual Listing” (own), table/11301 “Manual VAT Correction” (own), report/12 “VAT Statement”, table/254 “VAT Entry”, table/256 “VAT Statement Line”, table/17 “G/L Entry”, report/11313 “Link to Accon” (own).

All 48 objects of Finance in the diff

Inventory

Implements Belgian Intrastat through Intrastat report extensions, tariff number import reports and fields on Tariff Number and Intrastat lines. Adds conversion factor, unit of measure and supplementary unit fields, plus batch flags for reporting systems.

Why: Learn describes simplified and extended declarations and export to the OneGate portal.

Objects: codeunit/11346 “IntrastatReportManagementBE” (own), table/260 “Tariff Number”, table/263 “Intrastat Jnl. Line”, pageextension/11346 “Intrastat Report BE” (own), report/11333 “Import Tariff Numbers Part 1” (own), report/11332 “Import Tariff Numbers Part 2” (own), tableextension/11346 “Intrastat Report Header BE” (own), table/262 “Intrastat Jnl. Batch”.

All 18 objects of Inventory in the diff

Purchases

Adds non-deductible VAT percentages and amount procedures on purchase lines and posted lines. Adds Enterprise No. on purchase headers and vendors, Suggest Payments on Vendor, an Export Protocol Code on vendor bank accounts, and the Purchase Ledger report.

Why: Learn explains vendor setup for automatic payment suggestions and non-deductible VAT for expense accounts.

Objects: table/39 “Purchase Line”, table/23 “Vendor”, table/123 “Purch. Inv. Line”, table/288 “Vendor Bank Account”, codeunit/90 “Purch.-Post”, report/11301 “Purchase Ledger” (own), table/38 “Purchase Header”, page/161 “Purchase Statistics”.

All 18 objects of Purchases in the diff

Sales

Adds Enterprise No. to sales documents, reminders and finance charge memos. Customer gets VAT Liable and Domiciliation No. PEPPOL Management gains payment discount compensation procedures, and the Sales Ledger report is added.

Why: not explained by a Learn page in the input; the code shows the change, not the requirement.

Objects: table/18 “Customer”, table/36 “Sales Header”, codeunit/1605 “PEPPOL Management”, table/287 “Customer Bank Account”, report/11300 “Sales Ledger” (own), table/1381 “Customer Templ.”, codeunit/854 “Sales Post Invoice Events BE” (own), table/112 “Sales Invoice Header”.

All 18 objects of Sales in the diff

Service

Adds Belgian service invoice, credit memo, shipment and test reports, with table extensions on service headers and archive. Codeunits manage service lines and documents.

Why: not explained by a Learn page in the input; the code shows the change, not the requirement.

Objects: report/11321 “Service - Invoice (BE)” (own), report/11322 “Service - Credit Memo (BE)” (own), report/11323 “Service - Shipment (BE)” (own), report/11325 “Service Document - Test (BE)” (own), codeunit/11309 “Service Line Mgt. BE” (own), codeunit/11350 “Serv. Document Mgt. BE” (own), tableextension/11300 “Service Header BE” (own).

All 11 objects of Service in the diff

Peppol

Adds PEPPOL 3.0 Belgian format support with validation for sales and service documents, tax, payment and monetary info, a discount (Escompte) codeunit, subscribers and an upgrade codeunit.

Why: not explained by a Learn page in the input; the code shows the change, not the requirement.

Objects: codeunit/37312 “PEPPOL30 BE Initialize” (own), codeunit/37314 “PEPPOL30 BE Subscribers” (own), codeunit/37311 “PEPPOL30 BE Sales Validation” (own), codeunit/37310 “PEPPOL30 BE Service Validation” (own), codeunit/37315 “PEPPOL30 BE Tax Info” (own), codeunit/37316 “PEPPOL30 BE Escompte” (own), codeunit/37318 “PEPPOL30 BE Monetary Info” (own), enumextension/37310 “PEPPOL 3.0 Format BE” (own).

All 10 objects of Peppol in the diff

Foundation

Adds Belgian company identifiers to Company Information: enterprise and branch numbers, Intrastat establishment number and XML sequence numbers. Country/Region gets ISO, IBAN and SEPA fields, and Source Code Setup gets financial and domiciliation journal codes.

Why: Learn describes enterprise numbers issued by the Crossroads Bank for Enterprises and the Intrastat establishment number.

Objects: table/79 “Company Information”, table/9 “Country/Region”, table/242 “Source Code Setup”, tableextension/11307 “SourceCodeSetupBE” (own), pageextension/11307 “SourceCodeSetupBE” (own), table/10 “Shipment Method”, codeunit/11311 “Serv. Report Selection Mgt. BE” (own).

All 7 objects of Foundation in the diff

(no namespace)

Holds the Transaction Coding table and page used with CODA, plus a copy-invoice-number-to-payment-reference codeunit and ISO code upgrade plumbing.

Why: not explained by a Learn page in the input; the code shows the change, not the requirement.

Objects: table/2000043 “Transaction Coding” (own), page/2000045 “Transaction Coding” (own), codeunit/104153 “Copy Inv. No. To Pmt. Ref” (own).

All 5 objects of (no namespace) in the diff

CashFlow

Cash flow suggestions compute a VAT base amount for sales, purchase and service lines and ledger entries. Cash Flow Worksheet Line gets a VAT Base Amount field.

Why: not explained by a Learn page in the input; the code shows the change, not the requirement.

Objects: report/840 “Suggest Worksheet Lines”, table/846 “Cash Flow Worksheet Line”, reportextension/6485 “Serv. Suggest Worksheet Lines”.

All 3 objects of CashFlow in the diff

Integration

Shopify integration maps the Belgian enterprise number as company tax ID through an enum extension and a codeunit.

Why: not explained by a Learn page in the input; the code shows the change, not the requirement.

Objects: codeunit/30461 “Shpfy Enterprise No. BE” (own), enumextension/30461 “Shpfy Comp. Tax Id Mapping BE” (own).

All 2 objects of Integration in the diff

Security

Changes the LOCAL and LOCAL READ permission sets to include Belgian objects.

Why: not explained by a Learn page in the input; the code shows the change, not the requirement.

Objects: permissionset/1001 “LOCAL”, permissionset/1002 “LOCAL READ”.

All 2 objects of Security in the diff

CRM

Contact gets an Enterprise No. field.

Why: not explained by a Learn page in the input; the code shows the change, not the requirement.

Objects: table/5050 “Contact”.

All 1 objects of CRM in the diff

Text

Selection filter helpers gain procedures for bank accounts and EB payment journals.

Why: not explained by a Learn page in the input; the code shows the change, not the requirement.

Objects: codeunit/46 “SelectionFilterManagement”.

All 1 objects of Text in the diff

Utilities

Document Totals gains procedures and an event to calculate non-deductible VAT in purchase totals.

Why: not explained by a Learn page in the input; the code shows the change, not the requirement.

Objects: codeunit/57 “Document Totals”.

All 1 objects of Utilities in the diff

Warehouse

Whse.-Post Receipt gets a procedure to get the source journal template, supporting mandatory journal template names.

Why: Learn describes making journal templates mandatory in the Belgian version.

Objects: codeunit/5760 “Whse.-Post Receipt”.

All 1 objects of Warehouse in the diff

Objects of its own

129 objects only this country has.

• codeunit/854 “Sales Post Invoice Events BE”
• codeunit/9997 “Upgrade Tag Def - Country”
• codeunit/11300 “VATLogicalTests”
• codeunit/11308 “INTERVAT Helper”
• codeunit/11309 “Service Line Mgt. BE”
• codeunit/11310 “VAT Amount Line Mgt. BE”
• codeunit/11311 “Serv. Report Selection Mgt. BE”
• codeunit/11346 “IntrastatReportManagementBE”
• codeunit/11350 “Serv. Document Mgt. BE”
• codeunit/30461 “Shpfy Enterprise No. BE”
• codeunit/37310 “PEPPOL30 BE Service Validation”
• codeunit/37311 “PEPPOL30 BE Sales Validation”
• codeunit/37312 “PEPPOL30 BE Initialize”
• codeunit/37313 “PEPPOL30 BE Upgrade”
• codeunit/37314 “PEPPOL30 BE Subscribers”
• codeunit/37315 “PEPPOL30 BE Tax Info”
• codeunit/37316 “PEPPOL30 BE Escompte”
• codeunit/37317 “PEPPOL30 BE Payment Info”
• codeunit/37318 “PEPPOL30 BE Monetary Info”
• codeunit/104151 “ISO Code UPG.BE”
• codeunit/104153 “Copy Inv. No. To Pmt. Ref”
• codeunit/2000000 “PmtJrnlManagement”
• codeunit/2000001 “CheckPaymJnlLine”
• codeunit/2000002 “Check Domestic Payments”
• codeunit/2000003 “Check International Payments”
• codeunit/2000004 “Check SEPA Payments”
• codeunit/2000005 “Check Non Euro SEPA Payments”
• codeunit/2000020 “DomiciliationJnlManagement”
• codeunit/2000021 “File Domiciliations”
• codeunit/2000040 “Coda Import Management”
• codeunit/2000041 “CODA Write Statements”
• codeunit/2000042 “Post Coded Bank Statement”
• enum/277 “VAT Stmt. Line Document Type”
• enumextension/30461 “Shpfy Comp. Tax Id Mapping BE”
• enumextension/37310 “PEPPOL 3.0 Format BE”
• page/11300 “Financial Journal”
• page/11301 “VAT VIES Correction”
• page/11303 “Manual VAT Correction List”
• page/11306 “Representative Card”
• page/11307 “Representative List”
• page/11308 “Electronic Banking Setup”
• page/2000000 “EB Payment Journal Templates”
• page/2000001 “EB Payment Journal”
• page/2000002 “IBLC/BLWI Transaction Codes”
• page/2000003 “EB Payment Journal Batches”
• page/2000005 “Export Protocols”
• page/2000006 “Export Check Error Logs”
• page/2000020 “Domicil. Journal Templates”
• page/2000021 “Domiciliation Journal Batches”
• page/2000022 “Domiciliation Journal”
• page/2000040 “CODA Statement”
• page/2000041 “CODA Statement Lines”
• page/2000042 “CODA Statement List”
• page/2000043 “CODA Statement Info”
• page/2000045 “Transaction Coding”
• pageextension/11307 “SourceCodeSetupBE”
• pageextension/11310 “VAT Specification Subform BE”
• pageextension/11346 “Intrastat Report BE”
• pageextension/11347 “Intrastat Report Subform BE”
• pageextension/11348 “Intrastat Report Item Card BE”
• pageextension/11349 “Intrastat Report FA Card BE”
• pageextension/11350 “Intrastat Report Tariff Ns. BE”
• permissionsetextension/11346 “Intrastat BE - Objects”
• report/11300 “Sales Ledger”
• report/11301 “Purchase Ledger”
• report/11302 “General Ledger”
• report/11303 “Centralization Ledger”
• report/11304 “Financial Ledger”
• report/11306 “Trial Balance - Debit/Credit”
• report/11307 “VAT - Form”
• report/11308 “VAT Annual Listing”
• report/11309 “VAT Annual Listing - Disk”
• report/11310 “VAT Statement Lines”
• report/11311 “VAT Statement Summary”
• report/11312 “Checklist Revenue and VAT”
• report/11313 “Link to Accon”
• report/11315 “VAT-VIES Declaration Disk BE”
• report/11321 “Service - Invoice (BE)”
• report/11322 “Service - Credit Memo (BE)”
• report/11323 “Service - Shipment (BE)”
• report/11325 “Service Document - Test (BE)”
• report/11332 “Import Tariff Numbers Part 2”
• report/11333 “Import Tariff Numbers Part 1”
• report/2000001 “File Domestic Payments”
• report/2000002 “File International Payments”
• report/2000004 “Payment Journal Post”
• report/2000005 “File SEPA Payments”
• report/2000006 “File Non Euro SEPA Payments”
• report/2000007 “File SEPA 001.001.09 Pmts”
• report/2000008 “File FCY SEPA 001.001.09 Pmts”
• report/2000019 “Suggest Vendor Payments EB”
• report/2000020 “Domiciliation Journal - Test”
• report/2000021 “File Domiciliations”
• report/2000022 “Create Gen. Jnl. Lines”
• report/2000030 “Import CODA Statement”
• report/2000039 “Suggest domicilations”
• report/2000040 “CODA Statement - Test”
• report/2000041 “CODA Statement - List”
• report/2000058 “Initialise CODA Stmt. Lines”
• report/2000059 “Post CODA Stmt. Lines”
• table/11300 “VAT VIES Correction”
• table/11301 “Manual VAT Correction”
• table/11303 “VAT Summary Buffer”
• table/11306 “Electronic Banking Setup”
• table/11307 “G/L Entry Application Buffer”
• table/11308 “Representative”
• table/2000000 “Payment Journal Template”
• table/2000001 “Payment Journal Line”
• table/2000002 “Paym. Journal Batch”
• table/2000003 “IBLC/BLWI Transaction Code”
• table/2000005 “Export Protocol”
• table/2000006 “Export Check Error Log”
• table/2000020 “Domiciliation Journal Template”
• table/2000021 “Domiciliation Journal Batch”
• table/2000022 “Domiciliation Journal Line”
• table/2000040 “CODA Statement”
• table/2000041 “CODA Statement Line”
• table/2000042 “CODA Statement Source Line”
• table/2000043 “Transaction Coding”
• tableextension/11300 “Service Header BE”
• tableextension/11301 “Service Cr.Memo Header BE”
• tableextension/11303 “Service Invoice Header BE”
• tableextension/11305 “Service Shipment Header BE”
• tableextension/11307 “SourceCodeSetupBE”
• tableextension/11308 “Service Header Archive BE”
• tableextension/11310 “Location BE”
• tableextension/11346 “Intrastat Report Header BE”
• tableextension/11347 “Intrastat Report Line BE”
• tableextension/11348 “Intrastat Report Tariff Nr. BE”

Other versions

• BC28: 184 objects differ from W1 (101 fields, 18 events added)
• BC30: 209 objects differ from W1 (101 fields, 18 events added)

Source: country layer of the Base Application compared with W1 of the same version (data/code/diffs/country/).