Manage receivables

Path: Business functionality > Finance > Manage receivables · tier official · system sales · narrative reviewed (checked by Opus)

Overview

This section covers the receivables cycle. Payments can be applied in several ways: the Payment Reconciliation Journal for bank statements and feeds, Payment Registration for unpaid sales documents, or the Cash Receipt Journal and customer ledger entries for manual application. A subtopic covers automatic payment application, matching rules, Text-to-Account mapping and bank reconciliation.

Other pages cover collection and risk: statements, reminders, finance charge memos, Copilot for Finance in Outlook, late payment prediction, and blocking customers. Further pages cover payment tolerances, SEPA Direct Debit, netting balances for a company that is both customer and vendor, analytics, sales tax, and Intrastat reporting.

Start with “Overview of tasks to manage receivables” to choose the right payment method. Then go to the page for that task, such as the reconciliation subtopic for bank-based matching or “Collect outstanding balances” for overdue amounts.

Key points

• Payment application options: Payment Reconciliation Journal, Payment Registration, and Cash Receipt Journal or customer ledger entries.
• The reconciliation subtopic covers importing bank statements or feeds, automatic matching to open entries, matching rules, and Text-to-Account mapping for recurring payments.
• Collection tools: Customer Statement report, Reminders, Finance Charge Memos with Finance Charge Terms, Copilot for Finance in Outlook, and Dispute Status.
• Payment tolerance and payment discount tolerance can be set by percentage and amount, per currency, with a grace period for discounts and blocking per customer or vendor.
• The Late Payment Prediction extension uses machine learning, shows confidence levels, and can use Microsoft models or custom Azure-based models.
• SEPA Direct Debit collects payments in EUR through export formats, mandates, and collection entries that export an XML file to the bank.
• Customers can be blocked for shipments, invoices, or all transactions, for example when insolvent.
• Sales tax in the default version is supported by Microsoft only in the United States and Canada; Intrastat extended capabilities start in 2022 release wave 2.

Subtopics

• Apply payments automatically and reconcile bank accounts (6 pages)

More Learn pages

• Accounts receivable analytics: Explore the reports and analytics in the standard version of Business Central that can help you track your accounts receivable.
• Apply payments to unpaid sales documents: You apply amounts paid by customers to related sales documents and post the payment to update the customer, general ledger, and bank ledger entries.
• Collect outstanding balances: Learn how to remind your customers of outstanding payments. Send a customer statement, issue a reminder, or send a finance charge memo.
• Consolidate Balances for a Company that is a Customer and a Vendor: Describes how to consolidate balances for a customer that is also a vendor.
• How to block sales to customers: If needed, you can block a customer from being included on sales documents and other sales transactions.
• Overview of tasks to manage receivables: This article outlines tasks to manage receivables and apply payments to customer or vendor ledger entries.
• Payment tolerance and payment discount tolerance: This article explains how to set up payment tolerance to close an invoice when the payment doesn’t fully cover the invoice amount.
• Predict late payments for sales documents: This article explains how to use our predictive model to predict whether a customer will pay an invoice on time.
• Reconcile customer payments with the cash receipt journal or from customer ledger entries: Apply customer cash receipts or refunds to one or more open customer ledger entries.
• Sales tax in the default version: Learn about how the base version of Business Central supports sales tax, and get a description of the basic concept.
• Send Reminders of Outstanding Balances: Learn how to issue a reminder to a customer about an overdue payment.
• SEPA Direct Debit in Business Central: With your customer’s consent, you can collect payments directly from the customer’s bank account according to the SEPA format.
• Work with Intrastat reporting: Learn how to report trade with companies in other EU countries/regions using the Intrastat system.

Videos, posts and code changes

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

• #10005 Improve error messages when there are no quantities to reverse in shipped/received lines in Sales/Purchase/Transfer (code change): “Error messages when reversing shipped or received lines now distinguish between”
• #10011 Improve performance when posting credit memos by skipping unnecessary lookups on empty keys (code change): “Credit memo posting now skips unnecessary table lookups when source keys are empty”
• #10504 [Reminders] Complete the communication texts model uptake (code change): “Reminder attachment and email communication model is now the permanent behavior”
• #11158 [Master]-“The record in table Reminder Line already exists.” error appears if you Create Reminders for a Customer with all the Open Entries On Hold and no Reminder Free applied on the Reminder Terms used (code change): “Fixed a duplicate record error in Reminder Communication when creating reminders”
• #11209 [29.x]-“The record in table Reminder Line already exists.” error appears if you Create Reminders for a Customer with all the Open Entries On Hold and no Reminder Free applied on the Reminder Terms used. (code change): “Fixed an error that occurred when creating reminders for customers with all open”
• #9089 Merge-ES-Excluded-from-Calculation-to-W1 (code change): “Customer, vendor, ledger entry and General Ledger Setup tables change”
• #9195 Fix Aged Accounts Receivable (Report 120) performance on large ledger history (code change): “Aged Accounts Receivable report (Report 120) now reads only the four columns”
• #9282 [Main]- Description field in the contact history is showing the number of the original unregistered reminder instead of the registered reminder number when using the reminder automation setup. (code change): “Contact history descriptions in reminder automation now display the registered reminder number”
• #9586 [master] Overdue Balance (LCY) filters do not behave as expected if you open the Customer Card from a document or journal. (code change): “The Customer Card now applies a default date filter in the OnAfterGetCurrRecord function”
• #9775 [Main]-Issued Reminders are printed without any header or footer in the United Kingdom version (code change): “The Reminder report in the United Kingdom version now displays header and footer content”
• Dynamics 365 Business Central – Three ways to post Sales Ledger Cash Receipts in Business Central (community post): “application of cash to invoices”
• Comparing entering Customer Cash Receipts in Dynamics GP to Dynamics 365 Business Central (2024) (video): “Cash receipts; customer payments; customer receivables; invoice application”
• Comparing Trial Balance and Aging Reports between Dynamics SL and Dynamics 365 Business Central (video): “aging reports; accounts receivable aging; aged accounts receivable report”
• What’s New: Financial Management - Reminder Automation (2024 release wave 1) (video): “reminder automation; role center; customer communication; batch jobs”

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Page 6 “Finance Charge Terms” · on Table 5 “Finance Charge Terms”
• Page 10 “Countries/Regions” · on Table 9 “Country/Region”
• Page 21 “Customer Card” · on Table 18 “Customer”
• Page 25 “Customer Ledger Entries” · on Table 21 “Cust. Ledger Entry”
• Page 118 “General Ledger Setup” · on Table 98 “General Ledger Setup”
• Page 255 “Cash Receipt Journal” · captioned “Cash Receipt Journals” · on Table 81 “Gen. Journal Line”
• Page 308 “Transaction Types” · on Table 258 “Transaction Type”
• Page 309 “Transport Methods” · on Table 259 “Transport Method”
• Page 310 “Tariff Numbers” · on Table 260 “Tariff Number”
• Page 314 “General Posting Setup” · on Table 252 “General Posting Setup”
• Page 315 “VAT Entries” · on Table 254 “VAT Entry”
• Page 371 “Bank Account List” · captioned “Bank Accounts” · on Table 270 “Bank Account”
• Page 395 “General Posting Setup Card” · on Table 252 “General Posting Setup”
• Page 405 “Areas” · on Table 284 “Area”
• Page 406 “Transaction Specifications” · on Table 285 “Transaction Specification”
• Page 423 “Customer Bank Account Card” · on Table 287 “Customer Bank Account”
• Page 424 “Customer Bank Account List” · on Table 287 “Customer Bank Account”
• Page 427 “Payment Methods” · on Table 289 “Payment Method”
• Page 431 “Reminder Terms” · on Table 292 “Reminder Terms”
• Page 432 “Reminder Levels” · on Table 293 “Reminder Level”
• Page 434 “Reminder” · on Table 295 “Reminder Header”
• Page 436 “Reminder List” · captioned “Reminders” · on Table 295 “Reminder Header”
• Page 437 “Reminder Statistics” · on Table 295 “Reminder Header”
• Page 440 “Issued Reminder List” · captioned “Issued Reminders” · on Table 297 “Issued Reminder Header”
• Page 442 “Reminder Comment Sheet” · captioned “Comment Sheet” · on Table 299 “Reminder Comment Line”
• Page 443 “Reminder Comment List” · captioned “Comment List” · on Table 299 “Reminder Comment Line”
• Page 448 “Finance Charge Memo List” · captioned “Finance Charge Memos” · on Table 302 “Finance Charge Memo Header”
• Page 452 “Issued Fin. Charge Memo List” · captioned “Issued Finance Charge Memos” · on Table 304 “Issued Fin. Charge Memo Header”
• Page 466 “Tax Jurisdictions” · on Table 320 “Tax Jurisdiction”
• Page 467 “Tax Groups” · on Table 321 “Tax Group”
• Page 468 “Tax Details” · on Table 322 “Tax Detail”
• Page 469 “Tax Area List” · captioned “Tax Areas” · on Table 318 “Tax Area”
• Page 1207 “Direct Debit Collections” · on Table 1207 “Direct Debit Collection”
• Page 1208 “Direct Debit Collect. Entries” · on Table 1208 “Direct Debit Collection Entry”
• Page 1230 “SEPA Direct Debit Mandates” · captioned “Direct Debit Mandates” · on Table 1230 “SEPA Direct Debit Mandate”
• Page 1287 “Payment Application Review” · on Table 274 “Bank Acc. Reconciliation Line”
• Page 1290 “Payment Reconciliation Journal” · on Table 274 “Bank Acc. Reconciliation Line”
• Page 1294 “Pmt. Reconciliation Journals” · captioned “Payment Reconciliation Journals” · on Table 273 “Bank Acc. Reconciliation”
• Page 1950 “LP Machine Learning Setup” · captioned “Late Payment Prediction Setup” · on Table 1950 “LP Machine Learning Setup”
• Page 1951 “LP Prediction FactBox” · on Table 21 “Cust. Ledger Entry”
• Page 4810 “Intrastat Report Setup” · on Table 4810 “Intrastat Report Setup”
• Page 4811 “Intrastat Report List” · on Table 4811 “Intrastat Report Header”
• Page 5050 “Contact Card” · on Table 5050 “Contact”
• Page 5052 “Contact List” · captioned “Contacts” · on Table 5050 “Contact”
• Page 36992 “Average Collection Period” · captioned “Average Collection Period (Power BI)”
• Page 36993 “Aged Receivables (Back Dating)” · captioned “Aged Receivables (Back Dating) (Power BI)”
• Report 33 “Reconcile Cust. and Vend. Accs” · captioned “Reconcile Customer and Vendor Accounts”
• Report 101 “Customer - List” · captioned “Customer List”
• Report 104 “Customer - Detail Trial Bal.”
• Report 109 “Customer - Summary Aging Simp.”
• Report 112 “Sales Statistics”
• Report 117 “Reminder”
• Report 120 “Aged Accounts Receivable” · captioned “Aged Accounts Receivable (Obsolete)”
• Report 121 “Customer - Balance to Date” · captioned “Customer Balance to Date”
• Report 129 “Customer - Trial Balance”
• Report 211 “Customer - Payment Receipt”
• Report 1316 “Standard Statement” · captioned “Customer Statement”
• Page 389 “Bank Account Statement List” · on Table 275 “Bank Account Statement” · via Apply payments automatically and reconcile bank accounts
• Page 1291 “Pmt. Recon. Journal Overview” · captioned “Payment Reconciliation Journal Overview” · on Table 274 “Bank Acc. Reconciliation Line” · via Apply payments automatically and reconcile bank accounts
• Page 1293 “Pmt. Rec. Journals Overview” · captioned “Unprocessed Payments” · on Table 273 “Bank Acc. Reconciliation” · via Apply payments automatically and reconcile bank accounts

Learn also names 11 objects with no object page: page/311, page/325, page/326, page/327, page/328, page/8451, page/10015, page/10016, page/10101, page/12202, page/31077.

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.