BeyondERP.Newsletter
Menu

Setup step on the Netting rules page · Cash and bank management

Set up netting rules

Use this page to decide the order and scope in which automatic netting settles invoices.

Used by
Accounts payable clerk, Accounts payable manager, Auditor and 15 more roles
Business process
Use netting agreements to settle customer balances with vendor balances in Dynamics 365 Finance
Menu item
CustVendNettingRule
Main table
CustVendNettingRule
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define a netting rule: the order invoices are netted in, which agreements are included and any extra criteria.
What you do hereUse this page to control which invoices automatic netting picks and in what order.
ExampleFor example, BEAT's rule BEAT-NET nets invoices by due date from newest to oldest, includes only the selected agreement BEAT-NET and leaves credit notes and debit notes out; its preview netted the 100.00 customer and vendor pair and posted two vouchers.
Netting rules page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up netting rules

Use this page to decide the order and scope in which automatic netting settles invoices.

Steps from Microsoft

  1. Go to Cash and bank management > Netting > Netting rules and create a record with a name and description.
  2. Choose the netting sequence: by due date (oldest or newest first) or by invoice balance (largest or smallest first).
  3. Set the netting agreement scope to All for every active agreement, or Selected and list the agreements.
  4. Choose whether credit notes and debit notes are included, and on the Netting criteria FastTab limit the rule to vendor accounts, customer accounts or an invoice currency if needed.
  5. Activate the rule, then run it from Automatic netting or schedule it in Process automations.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Netting sequenceThe order in which invoices are netted, by due date or by invoice balance.Microsoft Learn By due date - From newest to oldestSequence
Netting agreement scopeAll includes every active agreement; Selected uses a list you define.Microsoft Learn Selected
Include credit note and debit noteWhether credit notes and debit notes are included in automatic netting.Microsoft Learn NoIncludeCredDebtNote
Netting criteriaOptional limits on vendor accounts, customer accounts or invoice currency that the rule nets.Microsoft Learn
ActiveOnly an active rule can be chosen for automatic netting.Microsoft Learn Yes

Common errors and fixes

MessageWhat to do
The rule isn't offered when you run automatic nettingActivate the rule. An inactive rule (Active No) can't be chosen. Microsoft Learn
An invoice you expected to net isn't offered for nettingTransactions already included in a payment journal aren't part of netting. Run netting before you create the payment journal, and use Accounts payable > Periodic tasks > All marked transaction details to see which transactions are already marked for settlement. Microsoft Learn

Test checklist

  1. Create a rule with Netting sequence By due date - From oldest to newest and Netting agreement scope All, and activate it.
  2. Create open customer and vendor invoices for a pair in an active netting agreement.
  3. Run Automatic netting from the Netting menu.
  4. On Netting history, check that the oldest invoices were netted first.
  5. Repeat with Include credit note and debit note set to No and check that credit notes are left open.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up netting rulesNetting sequence By due date - From oldest to newest, agreement scope Selected with the agreements meant for automatic netting, credit and debit notes included only if the parties agree to it.Netting the oldest items first clears the most overdue balances; a Selected list keeps agreements that need manual review out of the automatic run.In what order should automatic netting settle invoices?Leaving agreement scope at All while some agreements need manual netting. Every active agreement is then netted by the rule.Test: The rule nets in its sequence

Feature management and licence

Feature to turn onCustomer and vendor netting (Generally available in 10.0.40; on by default from 10.0.43)
Licence or add-inIn this system 18 roles can open this page, among them Auditor, Collections agent, Collections manager and Chief financial officer.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyA rule includes all active netting agreements (scope All) or only the agreements on its list (scope Selected); netting agreements are kept per legal entity. Microsoft Learn
Can it be undoneReversible: A rule only selects invoices for later runs; posted netting is undone with Reverse netting.
If you change it laterThe sequence and criteria decide which invoices are netted first when amounts on the two sides differ. A change applies to the next automatic netting run. Microsoft Learn
Technical architect

6Technical

Menu itemCustVendNettingRule Checked in Dynamics 365
FormCustVendNettingRuleForm Checked in Dynamics 365
TableCustVendNettingRuleShown as “Netting rules” in Record infoKey field: RecIdChecked in Dynamics 365
Who can open itPrivilegesMaintain netting rule CustVendNettingRuleMaintainView netting rule CustVendNettingRuleViewDutiesInquire into invoice and cash policies CustInvoiceInvoiceAndCashPoliciesInquirEnable invoice and cash process CustInvoiceInvoiceAndCashProcessEnableInquire into customer payments status PaymCustomerPaymentsStatusInquireInquire into vendor payment status PaymVendorPaymentStatusInquireInquire into invoice and payment policies VendInvoiceInvoicePaymentPoliciesInquirEnable invoice and payment process VendInvoiceInvoicePaymentProcessEnable
18 security rolesAuditor AuditPolicyManagerCollections agent CollectionLetterCollectionsAgentCollections manager CollectionLetterCollectionsManagerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounting supervisor LedgerAccountingSupervisorAccounting manager LedgerAccountingManagerAccounts payable manager VendInvoiceAccountsPayableManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerRental manager RentalManagerTo use itChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantAuditor AuditPolicyManagerAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkGive people one of these roles. On this system, 18 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustVendNettingRule
Data migrationLoad order: A netting rule has no data entity in Data management, so it can't be loaded from a file or a configuration template. Create the rules by hand in each environment after the netting agreements are loaded, then activate them.Microsoft Learn
Everyone

8Sources

To cite this step: CB-NET-030, Set up netting rules. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-NET-030