Netherlands (NL)

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

Overview

The Dutch layer is built around telebanking. Transaction modes, proposals, payment history and export protocols are own pages, reports and codeunits, mostly numbered in the 11000000 range. Transaction Mode Code fields are added to customers, vendors, employees, ledger entries, sales and purchase documents and journal lines. Bank accounts, customer bank accounts and vendor bank accounts get account holder fields. SEPA credit transfer and direct debit exports are extended, and SEPA CAMT statement import is supported. Learn documents telebanking, the three payment scenarios, SEPA activation and docket reports.

Bank/Giro and Cash journals (CBG statements) are own pages and codeunits. They tie into GenJnlManagement and Payment Tolerance Management, and Gen. Journal Template gets a No. of CBG Statements field. Source Code Setup gets cash and bank journal source codes. Learn describes posting these journals, importing and reconciling bank statements, and printing test reports. Separately, G/L Entry gains fields such as Open, Remaining Amount and Applies-to ID so that G/L entries can be applied and unapplied.

Tax and statutory features include electronic VAT and ICP declarations sent through Digipoort (setup, VAT categories, certificates, response messages), the tax authority audit file, CMR notes for sales, transfer and return shipments, and the VIES declaration. Company Information gets a Fiscal Entity No. field. Learn also covers editing document amounts on purchase invoices and credit memos. The layer also adds Dutch post code import with update logging, Intrastat export, and service document extensions.

Key points

• Telebanking: payment and collection proposals, payment history, and export via BTL91 (ABN AMRO, Rabobank), BBV, PAYMUL and SEPA ISO 20022 (credit transfer pain.001, direct debit pain.008).
• Transaction Mode Code is added to customers, vendors, employees, templates, ledger entries and sales and purchase documents to drive payment handling.
• Bank/Giro and Cash journals with CBG statements, electronic statement import (SEPA CAMT, Rabobank protocols), automatic reconciliation and a CBG posting test report.
• Electronic VAT and ICP declarations through Digipoort, with VAT category setup, certificates and response message processing.
• Tax Authority Audit File (XAF) and Export Financial Data to XML reports.
• CMR notes for sales shipments, transfer shipments and return shipments.
• Dutch post code import and update logs, plus Intrastat report export extensions.
• G/L Entry gains application fields, and G/L Account has a field for required descriptions in journals.

Narrative written by Sonnet from the code diff and 27 Learn page summaries. In numbers: Netherlands (NL) localization of Business Central in BC29: 154 objects of its own, 50 W1 objects changed (81 fields and 9 events added). From the code; country apps outside the Base Application are not included yet.

By area

Bank

Own telebanking suite: proposals, proposal detail lines, payment history, transaction modes, export and import protocols, SEPA and BTL91/BBV/PAYMUL checks and exports. It also adds CBG Bank/Giro journals, SEPA CAMT import and statement reconciliation. Bank Account gets account holder, proposal, payment history and creditor identifier fields, and SEPA CT codeunits are extended.

Why: Learn explains that Dutch electronic banking covers payment files, direct debit files and bank statement import via telebanking protocols.

Objects: table/270 “Bank Account”, codeunit/11000000 “Process Proposal Lines” (own), codeunit/11000001 “Financial Interface Telebank” (own), codeunit/11000005 “Import Protocol Management” (own), codeunit/11404 “Import SEPA CAMT” (own), codeunit/11405 “Process CBG Statement Lines” (own), codeunit/1222 “SEPA CT-Prepare Source”, page/11000001 “Telebank Proposal” (own).

All 83 objects of Bank in the diff

Finance

Electronic VAT and ICP declarations with Digipoort communication, the tax audit file, VIES report and cash journals. W1 tables get fields for G/L entry application, SEPA priority, and VAT statement category codes. VAT registration checks add mod 11 and mod 97 algorithms.

Why: Learn describes submitting XBRL VAT and ICP declarations through Digipoort and creating an audit file for the tax authority.

Objects: codeunit/11409 “Elec. Tax Declaration Mgt.” (own), codeunit/11000054 “Digipoort Communication” (own), report/11403 “Create Elec. VAT Declaration” (own), report/11404 “Create Elec. ICP Declaration” (own), report/11412 “Tax Authority - Audit File” (own), table/17 “G/L Entry”, table/256 “VAT Statement Line”, table/381 “VAT Registration No. Format”.

All 52 objects of Finance in the diff

Service

Page and table extensions add Dutch fields, such as transaction mode and bank account, to service contracts, orders, quotes, invoices, credit memos and their archives. A codeunit supports service document handling.

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

Objects: codeunit/11412 “Serv. Document Mgt. NL” (own), tableextension/11451 “Service Header NL” (own), tableextension/11450 “Service Contract Header NL” (own), pageextension/11454 “Service Order NL” (own), pageextension/11453 “Service Invoice NL” (own), pageextension/11450 “Service Contract NL” (own).

All 18 objects of Service in the diff

Foundation

Dutch post code ranges with import and update reports and update logs. Company Information gets a fiscal entity number, Country/Region a SEPA Allowed flag, and Source Code Setup cash and bank journal codes.

Why: Learn documents subscribing to and importing post code data and monthly updates.

Objects: codeunit/11401 “Post Code Management” (own), table/11406 “Post Code Range” (own), table/11407 “Post Code Update Log Entry” (own), report/11414 “Import Post Codes” (own), report/11415 “Import Post Codes Update” (own), table/79 “Company Information”, table/242 “Source Code Setup”, table/9 “Country/Region”.

All 14 objects of Foundation in the diff

Purchases

Vendors, vendor templates, purchase headers and posted purchase documents get transaction mode and bank account fields. Vendor Bank Account gets account holder and national bank code fields. Vendor Ledger Entry gets payment-in-process fields. A CMR return shipment report is added.

Why: Learn describes CMR notes for purchase returns and transaction modes for vendor payments.

Objects: table/23 “Vendor”, table/25 “Vendor Ledger Entry”, table/288 “Vendor Bank Account”, table/38 “Purchase Header”, table/122 “Purch. Inv. Header”, table/124 “Purch. Cr. Memo Hdr.”, report/11410 “CMR - Return Shipment” (own), table/1383 “Vendor Templ.”.

All 10 objects of Purchases in the diff

Sales

Customers, templates, sales headers and posted sales documents get transaction mode and bank account fields. Customer Bank Account adds account holder and direct debit mandate fields with update procedures. A CMR sales shipment report is added.

Why: Learn describes CMR notes for sales shipments and direct debit collection through proposals.

Objects: table/18 “Customer”, table/21 “Cust. Ledger Entry”, table/287 “Customer Bank Account”, table/36 “Sales Header”, table/112 “Sales Invoice Header”, table/114 “Sales Cr.Memo Header”, report/11401 “CMR - Sales Shipment” (own), table/1381 “Customer Templ.”.

All 9 objects of Sales in the diff

Inventory

Intrastat export is extended with Dutch management and export codeunits and a subform page extension. Intrastat batches get export date and time fields. A CMR transfer shipment report is added.

Why: Learn describes CMR notes for transfer shipments.

Objects: codeunit/11426 “Intrastat Report Management NL” (own), codeunit/11427 “Intrastat Report Exp. Ext. NL” (own), pageextension/11426 “Intrastat Report Subform NL” (own), table/262 “Intrastat Jnl. Batch”, table/263 “Intrastat Jnl. Line”, report/11402 “CMR - Transfer Shipment” (own), permissionsetextension/11426 “Intrastat NL - Objects” (own).

All 7 objects of Inventory in the diff

HumanResources

Employee gets transaction mode and bank name and city fields. Employee Ledger Entry gets the same payment-in-process fields as customer and vendor entries so employees can be paid through telebanking.

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

Objects: table/5200 “Employee”, table/5222 “Employee Ledger Entry”.

All 2 objects of HumanResources in the diff

Security

The LOCAL and LOCAL READ permission sets are replaced to include the Dutch 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

IO

The XML import preprocessing codeunit adds a check of the bank account number.

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

Objects: codeunit/1262 “Pre & Post Process XML Import”.

All 1 objects of IO in the diff

Utilities

Local Functionality Mgt. is an own codeunit holding Dutch helper logic.

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

Objects: codeunit/11400 “Local Functionality Mgt.” (own).

All 1 objects of Utilities in the diff

Objects of its own

154 objects only this country has.

• codeunit/1883 “Sandbox Cleanup local”
• codeunit/9997 “Upgrade Tag Def - Country”
• codeunit/11400 “Local Functionality Mgt.”
• codeunit/11401 “Post Code Management”
• codeunit/11402 “Post Code Lookup - Table”
• codeunit/11404 “Import SEPA CAMT”
• codeunit/11405 “Process CBG Statement Lines”
• codeunit/11406 “Imp. SEPA CAMT Pre-Mapping”
• codeunit/11407 “Imp. SEPA CAMT Post-Mapping”
• codeunit/11408 “Imp. Bank Trans. Data Updates”
• codeunit/11409 “Elec. Tax Declaration Mgt.”
• codeunit/11411 “Serv. Post Code Mgt.”
• codeunit/11412 “Serv. Document Mgt. NL”
• codeunit/11420 “Validate Elec. Tax Declaration”
• codeunit/11421 “Create Elec. Tax Declaration”
• codeunit/11422 “Submit Elec. Tax Declaration”
• codeunit/11423 “Digital Tax. Decl. Mgt.”
• codeunit/11424 “Receive Elec. Tax Declaration”
• codeunit/11425 “Digital Tax Decl. Install”
• codeunit/11426 “Intrastat Report Management NL”
• codeunit/11427 “Intrastat Report Exp. Ext. NL”
• codeunit/104170 “UPG SEPA NL”
• codeunit/104171 “Elec. Tax. Decl. Upgrade”
• codeunit/11000000 “Process Proposal Lines”
• codeunit/11000001 “Financial Interface Telebank”
• codeunit/11000002 “CBG Journal Telebank Interface”
• codeunit/11000005 “Import Protocol Management”
• codeunit/11000006 “CBG Statement Reconciliation”
• codeunit/11000007 “Check BTL91”
• codeunit/11000008 “Check BBV”
• codeunit/11000009 “Check PAYMUL”
• codeunit/11000010 “Check SEPA ISO20022”
• codeunit/11000011 “Check SEPA Pain 008.001.02”
• codeunit/11000012 “Report Checksum”
• codeunit/11000052 “Digipoort Onprem Communication”
• codeunit/11000053 “Digipoort SaaS Communication”
• codeunit/11000054 “Digipoort Communication”
• enum/11409 “Elec. Tax Declaration Period”
• enum/11000006 “CBG Statement Information Type”
• enum/11000007 “CBG Statement Line Account Type”
• interface/digipoort communication “DigiPoort Communication”
• page/11400 “Bank/Giro Journal”
• page/11401 “Bank/Giro Journal Subform”
• page/11402 “Bank/Giro Journal List”
• page/11403 “Cash Journal”
• page/11404 “Cash Journal Subform”
• page/11405 “Cash Journal List”
• page/11406 “Freely Transferable Maximums”
• page/11407 “Post Code Ranges”
• page/11408 “Post Code Updates”
• page/11409 “Gen. Journal Templ. List (CBG)”
• page/11410 “Elec. Tax Declaration Setup”
• page/11411 “Elec. Tax Declaration Card”
• page/11412 “Elec. Tax Declaration List”
• page/11413 “Elec. Tax Decl. Line Subform”
• page/11414 “Elec. Tax Decl. VAT Categ.”
• page/11415 “Elec. Tax Decl. Error Log”
• page/11416 “Elec. Tax Decl. Response Msgs.”
• page/35001 “Bank/Giro Jnl. Subf. Info”
• page/11000000 “Telebank - Bank Overview”
• page/11000001 “Telebank Proposal”
• page/11000002 “Proposal Detail Line”
• page/11000003 “Detail Line Subform”
• page/11000004 “Detail Lines”
• page/11000005 “Payment History Card”
• page/11000006 “Payment History Line Overview”
• page/11000007 “Payment History List”
• page/11000008 “Payment History Line Subform”
• page/11000009 “Payment History Line Detail”
• page/11000010 “Transaction Mode List”
• page/11000011 “Transaction Mode Card”
• page/11000012 “Export Protocols”
• page/11000014 “CBG Statement Line Add. Info.”
• page/11000015 “Import Protocols”
• page/11000016 “Import Protocol List”
• page/11000017 “AL Objects (Telebanking)”
• pageextension/11400 “SourceCodeSetupNL”
• pageextension/11426 “Intrastat Report Subform NL”
• pageextension/11450 “Service Contract NL”
• pageextension/11451 “Service Contract Quote NL”
• pageextension/11452 “Service Credit Memo NL”
• pageextension/11453 “Service Invoice NL”
• pageextension/11454 “Service Order NL”
• pageextension/11455 “Service Quote NL”
• pageextension/11456 “Posted Service Credit Memo NL”
• pageextension/11457 “Posted Service Invoice NL”
• pageextension/11458 “Filed Service Contract NL”
• pageextension/11460 “Service Quote Archive NL”
• pageextension/11461 “Service Order Archive NL”
• permissionsetextension/11426 “Intrastat NL - Objects”
• query/11400 “Data Exch. Find Column No.”
• query/11401 “CountPartnerTypes”
• report/11400 “CBG Posting - Test”
• report/11401 “CMR - Sales Shipment”
• report/11402 “CMR - Transfer Shipment”
• report/11403 “Create Elec. VAT Declaration”
• report/11404 “Create Elec. ICP Declaration”
• report/11405 “Submit Elec. Tax Declaration”
• report/11406 “Process Response Messages”
• report/11408 “Receive Response Messages”
• report/11409 “VAT- VIES Decl. Tax Auth NL”
• report/11410 “CMR - Return Shipment”
• report/11412 “Tax Authority - Audit File”
• report/11414 “Import Post Codes”
• report/11415 “Import Post Codes Update”
• report/11420 “Export Financial Data to XML”
• report/11000000 “Get Proposal Entries”
• report/11000001 “Proposal Overview”
• report/11000002 “Payment History Overview”
• report/11000003 “Paymt. History - Change Status”
• report/11000004 “Docket”
• report/11000007 “Export BTL91-ABN AMRO”
• report/11000008 “Export BBV”
• report/11000009 “Export PAYMUL”
• report/11000010 “Export BTL91-RABO”
• report/11000011 “Export SEPA ISO20022”
• report/11000012 “SEPA ISO20022 Pain 01.01.03”
• report/11000013 “SEPA ISO20022 Pain 008.001.02”
• report/11000014 “SEPA ISO20022 Pain 01.01.09”
• report/11000015 “SEPA ISO20022 Pain 008.001.08”
• report/11000021 “Import Rabobank mut.asc”
• report/11000022 “Import Rabobank vvmut.asc”
• report/11000023 “Import Rabobank ASCII”
• table/11307 “G/L Entry Application Buffer”
• table/11400 “CBG Statement”
• table/11401 “CBG Statement Line”
• table/11403 “Reporting ICP”
• table/11404 “Audit File Buffer”
• table/11405 “Freely Transferable Maximum”
• table/11406 “Post Code Range”
• table/11407 “Post Code Update Log Entry”
• table/11408 “Elec. Tax Declaration Setup”
• table/11409 “Elec. Tax Declaration Header”
• table/11410 “Elec. Tax Declaration Line”
• table/11411 “Elec. Tax Decl. VAT Category”
• table/11412 “Elec. Tax Decl. Error Log”
• table/11413 “Elec. Tax Decl. Response Msg.”
• table/11000000 “Proposal Line”
• table/11000001 “Payment History”
• table/11000002 “Payment History Line”
• table/11000003 “Detail Line”
• table/11000004 “Transaction Mode”
• table/11000005 “Export Protocol”
• table/11000006 “CBG Statement Line Add. Info.”
• table/11000007 “Import Protocol”
• table/11000008 “Reconciliation Buffer”
• table/11000009 “Payment History Export Buffer”
• tableextension/11400 “SourceCodeSetupNL”
• tableextension/11450 “Service Contract Header NL”
• tableextension/11451 “Service Header NL”
• tableextension/11453 “Service Cr.Memo Header NL”
• tableextension/11454 “Service Invoice Header NL”
• tableextension/11455 “Filed Serv. Contract Header NL”
• tableextension/11460 “Service Header Archive NL”

Other versions

• BC28: 194 objects differ from W1 (81 fields, 9 events added)
• BC30: 204 objects differ from W1 (81 fields, 9 events added)

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