BeyondERP.Newsletter
Menu

Setup page · Accounts receivable

Netting rules

Netting rules define how customer and vendor balances are netted automatically.

Used by
Accounts receivable clerk, Accounts receivable 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
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isNetting rules define how customer and vendor balances are netted automatically.
What you do hereUse this page to set the netting sequence (by due date or invoice balance), the netting agreement scope, whether credit and debit notes are included, and optional netting criteria, then activate the rule.
ExampleAutomatically netting only specific vendor accounts, customer accounts or invoice currencies by defining criteria on the Netting criteria FastTab.
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.

Steps from Microsoft

  1. Go to Netting rules.
  2. Create a record, and enter a name and description.
  3. Select a netting sequence, by due date or by invoice balance.
  4. Select the netting agreement scope: All, or Selected with a list of agreements.
  5. In the Include credit note and debit note field, select Yes or No.
  6. On the Netting criteria FastTab, limit the rule to specific vendor accounts, customer accounts or invoice currency if needed.
  7. Activate the netting rule.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Netting sequenceThe order invoices are netted in: by due date or by invoice balance.Microsoft Learn Sequence
Netting agreement scopeAll active agreements, or only a selected list.Microsoft Learn
Include credit note and debit noteWhether credit and debit notes are included in automatic netting.Microsoft Learn IncludeCredDebtNote
Netting criteriaLimits the rule to specific vendor accounts, customer accounts or invoice currency.Microsoft Learn

Test checklist

  1. Create a rule with Netting sequence By due date - From oldest to newest, Netting agreement scope All, and activate it.
  2. Make sure an active agreement has an open customer invoice and an open vendor invoice that aren't in a payment journal.
  3. Run Automatic netting from the Netting menu and check that the oldest invoices are netted first.
  4. Add an invoice to a payment journal, run automatic netting again and check that it isn't netted.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Feature management and licence

Feature to turn onCustomer and vendor netting (Mandatory, on by default)

Microsoft Learn

Solution architect

5Design impact

Can it be undoneReversible: A rule only decides what the next automatic netting run nets (sequence, agreement scope, credit and debit notes, criteria). Netting that a rule already posted is undone separately with Reverse netting on the Netting history page. Microsoft Learn
If you change it laterTransactions that are already in a payment journal aren't netted, so netting should run before payment journals are created. 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 itRental manager RentalManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerRental coordinator agent RentalCoordinatorAgentCollections manager CollectionLetterCollectionsManagerAccounting supervisor LedgerAccountingSupervisorTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive 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
Everyone

8Sources